Excel Insider
Probability & Z-Scores

Critical Z Value Calculator

Finds the boundary mark (cut-off point) on a bell curve needed to reject a hypothesis at a certain confidence level.

The precise Z-value needed for hypothesis testing — like 1.96 for a 95% confidence level.

Enter confidence parameters
Pick your risk tolerance and test direction — the critical value appears with the rejection region on the curve.

Critical z-value

± 1.960

Reject H₀ when |z| > 1.960

Rejection Region: Area = 0.05 (0.03% in each tail) — reject the null hypothesis if your test statistic falls in the red zone.

-1.9601.960-3-2-10+1+2+3Red Area = Rejection Region

Confidence level

95%

Your chosen level of certainty

Upper critical z

1.960

Right boundary of acceptance

Lower critical z

-1.960

Left boundary of acceptance

About this calculator

Every scientific experiment has a turning point — the point where data stops looking average and becomes statistically significant. The Critical Z-Value Calculator finds this boundary in seconds, whether you use a 95% confidence level or a stricter 99% study.

Think of a game where you throw a ball into a bucket: a small miss feels normal, a large miss feels unusual. The critical z-value sets that limit — if your result stays inside the acceptance region, it is normal chance. If it goes into the rejection zone, you call it statistically significant.

Formula

z_critical = Φ⁻¹(1 − α) [one-tailed] · z_critical = ±Φ⁻¹(1 − α/2) [two-tailed]

How to use it

  1. 1

    Pick the significance level (α): 0.05 for most studies, 0.01 for medical studies, or 0.10 for exploratory marketing work.

  2. 2

    Choose the test type: two-tailed (standard — checks for any difference) or one-tailed (left/right — checks one direction only).

  3. 3

    Read the critical z-value, the rejection region area, and the confidence level — the curve shows the rejection zones in red.

Example: 95% confidence, two-tailed

α = 0.05 split into two tails of 2.5% each. The calculator finds the cutoff for both ends: ±1.960. If your z-score goes above 1.96 or below −1.96, you reject the null hypothesis.

Understanding the logic — tails and alpha

The significance level (α) sets your risk limit: 0.05 means 95% confident, 0.01 means 99% confident, 0.10 means 90% confident. Most studies use 0.05; medical studies prefer 0.01 for extra safety.

Two-tailed test (the standard): you look for any kind of difference — the calculator splits α in half, putting α/2 on each side of the curve. One-tailed test: you care about only one direction — the calculator places the full α on one side, which lowers the cutoff to 1.645 instead of 1.96, making significance easier to reach.

Two-tailed: α/2 in each tail · One-tailed: full α in one tail

1. The big three numbers

Statisticians memorize three critical values: ±1.645 for 90% confidence (or 95% one-tailed), ±1.960 as the standard for 95% confidence, and ±2.576 for 99% confidence in strict tests. If you see a z-score of 3.0, it already passes all three.

2. Critical values define the rejection region

The red zone on the graph is the rejection region — where the null hypothesis fails. If your test statistic enters this zone beyond the critical value, you reject the null. Most experiments aim for this result because it shows a meaningful finding.

3. Z vs. T — the sample size rule

This calculator uses critical z-values, which work when your sample size exceeds 30. With a small sample — like 5 patients — z-values do not work well; you need a critical t-value instead, which uses a higher cutoff to handle the uncertainty.

When to use this calculator

A/B testing (marketing)

You test two website headlines at 95% confidence. Before collecting data, set the cutoff at 1.96. After a week, your z-score of 2.1 exceeds 1.96 — the result is significant, switch to the new headline.

Quality assurance (factories)

A factory making 10mm steel bolts sets a strict 99% confidence level (α = 0.01), giving a critical value of ±2.576. A batch returns a z-score of −2.8 — in the rejection region. The bolts are too thin; the manager stops the machine.

Political polling

When news channels say 'Candidate A leads by 4 points with a margin of error of 3%,' they base the margin on critical values. The margin of error equals the critical value multiplied by the standard error — 1.96 for 95% confidence.

In Excel: In Excel use =NORM.S.INV(1 − α/2) for two-tailed critical values, or =NORM.S.INV(1 − α) for one-tailed.

Frequently asked questions

What is the difference between a z-score and a critical value?

Think of the critical value as the goal post and the z-score as the ball. The critical value sets a fixed line before the test — it depends on your confidence level. The z-score shows your result after collecting data. You score a goal when your z-score passes the critical value.

Why is the critical value lower for a one-tailed test?

A one-tailed test puts the full error budget on one side, moving the cutoff closer to the center. Two-tailed at 5%: cutoff is 1.96. One-tailed at 5%: cutoff is 1.645. This makes significance easier to reach, but you must ignore results in the opposite direction.

Can a critical value be negative?

Yes. A left-tailed test uses a negative value because it looks for a decrease — for example, −1.645. A two-tailed test uses both sides, so it includes a positive and a negative value such as ±1.96.

What happens if my z-score matches the critical value?

This is a borderline case. Most rules say you reject only when |z| exceeds the critical value strictly. At exactly 1.96 vs. 1.96, you fail to reject — you are close but do not pass. Collect more data for a clearer result.

Does the sample size change the critical z-value?

No. The z-distribution keeps it fixed: a 95% confidence level always uses 1.96, whether you have 50 people or 5 million. Note: this rule does not apply to t-tests, where t-values change with sample size.