Excel Insider
Probability & Z-Scores

P Value from Z Score Calculator

The ultimate evidence calculator: the probability of finding a result as extreme as the one you observed.

A small decimal (the P-Value) — if it is low, usually under 0.05, your result is statistically significant.

Enter z-score parameters
Your test statistic, the hypothesis direction, and the significance cutoff.

Preset loaded (95th Perc.)

P-value result

0.0500

Two-tailed · z = 1.96

Significant — p = 0.0500 < α = 0.05. Null hypothesis rejected: the result likely did not happen by chance.

-1.961.96-3-2-10+1+2+3Red Area = P-Value

Statistically significant?

Yes

p < α = 0.05

One-tailed p

0.0250

Area in one tail

Two-tailed p

0.0500

Both tails combined

About this calculator

In statistics, numbers need proper meaning. You may find a difference in your results, but that difference may come from random chance. The p-value measures that chance — it shows how likely your result appeared by accident.

The p-value is a number between 0 and 1 that measures the strength of evidence against the null hypothesis (H₀). The null hypothesis means nothing changed — a medicine shows no effect, or two groups stay the same. The p-value shows the chance of getting results this extreme if the null hypothesis is true.

Formula

P = 2 × (1 − Φ(|z|)) for two-tailed · P = 1 − Φ(z) for one-tailed

How to use it

  1. 1

    Enter your z-score — the test statistic from your z-test or analysis.

  2. 2

    Pick the hypothesis type: two-tailed (any difference), left-tailed (decrease), or right-tailed (increase).

  3. 3

    Pick the significance level (α) — 0.05 is standard, 0.01 is strict, 0.10 is exploratory.

  4. 4

    Read the p-value, the significance verdict, and the bell curve showing the p-value as the shaded area.

Example: the classic boundary

z = 1.96 with a two-tailed test gives p = 0.0500 — exactly at the edge of significance at α = 0.05. A z-score of 2.576 gives p = 0.0100; a z of 3.00 gives p = 0.0027 (extremely significant).

How to use this calculator — tails & alpha

Two-tailed test (standard): use when you check for a difference in any direction. 'Is Class A's average height different from Class B?' — it could be taller or shorter. The calculator doubles the single-tail probability to cover both extremes.

Left-tailed test: use when you test for a decrease. 'Did the new engine design lower fuel consumption?' The calculator finds the area on the far left of the z-score. Right-tailed test: use when you test for an increase. 'Did the study course improve scores?' The area sits on the far right.

Two-tailed: P = 2 × tail area · One-tailed: P = single tail area

1. The 0.05 alpha level

Most scientific fields use 0.05 (5%) as the significance cutoff, called alpha (α). A p-value of 0.04 passes; 0.06 does not. But the threshold varies: particle physicists require 0.0000003 (5 Sigma) for a discovery, while social scientists may accept 0.10.

2. P-value is NOT the probability of truth

A p-value of 0.05 does NOT mean 'there is a 95% chance my hypothesis is true.' It means 'there is a 5% chance of getting this data if the hypothesis is wrong.' The p-value measures how unusual the data looks — it does not prove a theory is true.

3. Z-score relationship

The p-value connects directly to the z-score. At z = 0, p = 1.0 (exactly average). At z = 1.96, p = 0.05 (the edge of significance). At z = 3.00, p = 0.0027 (extremely significant).

When to use this calculator

A/B testing conversion rates

Marketers compare two website versions. Version B gives a z-score of 2.5 → p = 0.012 (two-tailed). The result likely did not happen by chance — the new layout works better.

Quality control

A factory machine fills bottles with 500ml of soda. One batch averages only 495ml. A z-test measures the chance of a 5ml error. A low p-value tells the team to inspect the machine.

Medical trials

Researchers compare people who took a drug with people who took a placebo. They calculate a z-score from the difference in results. The final p-value helps experts decide if the drug works well enough for FDA approval.

In Excel: In Excel: =2*(1-NORM.S.DIST(ABS(z),TRUE)) for two-tailed, or =1-NORM.S.DIST(z,TRUE) for right-tailed.

Frequently asked questions

Why is the p-value 0.00000?

A very high or very low z-score (above 4 or below −4) creates a tiny probability that rounds to zero. This result shows very strong statistical significance — your result is extremely unlikely to have happened by chance.

Can I use this for t-scores?

No. T-scores use a different formula that includes degrees of freedom. People use t-scores for small sample sizes (n < 30). This calculator works only with z-scores and normal distribution data.

What does statistically significant mean?

This term means your p-value falls below the significance level (usually 0.05). It tells you the result likely did not happen by chance — there is a real effect worth investigating.

Why does the graph change shape?

The bell curve keeps the same shape every time. The shaded area changes with your hypothesis type — left-tailed, right-tailed, or two-tailed. The shaded red part shows the p-value percentage visually.