How to Use a Z Table: Step-by-Step Guide

A standard normal distribution table, commonly called a z-table, maps standard deviations (z-scores) to cumulative probabilities under the standard normal curve. In quantitative research and hypothesis testing, researchers use the z-table to determine p-values, set confidence boundaries, and test whether an observed sample deviates significantly from a hypothesized population mean. This guide provides the complete cumulative normal table, the underlying mathematical formulas, worked calculation examples, and code implementations in Excel, R, and Python.

What Is a Z-Table and How Does It Work?

A z-table is a reference grid displaying cumulative probabilities for the standard normal distribution, denoted as Z ~ N(0, 1), where the mean (μ) is 0 and the standard deviation (σ) is 1. The total area underneath the normal distribution curve is exactly 1.0 (100% cumulative probability).

When assessing quantitative data, researchers select their test distribution based on sample size and variance knowledge. As detailed in the t-distribution vs normal distribution comparison, a z-distribution is used when population standard deviation is known or sample size is large (n ≥ 30). For smaller samples with unknown variance, Student’s t-distribution is preferred.

Standard normal tables typically follow one of three layout formats:

• Cumulative from left tail: The cell gives P(Z ≤ z), measuring the area from -∞ to z. This is the modern standard used below.
• Cumulative from the mean: The cell gives P(0 ≤ Z ≤ z), measuring only the area between 0 and z. Classical engineering references, including older editions of the NIST/SEMATECH e-Handbook, use this layout.
• Upper tail: The cell gives P(Z > z), measuring the right-hand rejection region.

To identify your table layout immediately, check the value at z = 0.00: in a cumulative left-tail table, it is exactly 0.5000; in a mean-to-z table, it is 0.0000.

Standard Normal Distribution and Z-Score Formula

To look up an observation in a z-table, raw values must be transformed into standardized z-scores. A z-score measures how many standard deviations an observation x lies above or below the population mean μ.

For an individual observation, the standardization formula is:

z = (x – μ) / σ

When testing sample means, the denominator is the standard error of the mean (SE = σ / √n). As outlined in the fundamental test statistic formula, the sample z-score is:

z = (x̄ – μ) / (σ / √n)

Per NIST e-Handbook Section 1.3.6.6.1, the probability density function (PDF) generating the standard normal curve is:

f(z) = (1 / √(2π)) × exp(-z² / 2)

The cumulative distribution function Φ(z) represents the integral from -∞ to z. Because this integral has no closed algebraic solution, values are calculated numerically and tabulated.

How to Read a Z-Table: Step-by-Step Lookup Method

To read a cumulative left-tail z-table:

1. Locate the row: Find the integer and first decimal digit in the left vertical column (e.g., for z = 1.45, find 1.4).
2. Locate the column: Find the second decimal digit across the top horizontal row (for z = 1.45, find .05).
3. Find the intersection: The intersecting cell contains 0.9265, indicating that 92.65% of the distribution lies below z = 1.45.
4. Use symmetry for negative z-scores: Apply the standard normal symmetry rule P(Z ≤ –z) = 1 – P(Z ≤ z). For example, P(Z ≤ -1.45) = 1 – 0.9265 = 0.0735.

Cumulative Standard Normal Distribution Table (Z-Table)

The table below provides cumulative standard normal probabilities Φ(z) = P(Z ≤ z) for z-scores from 0.00 to 3.09. Values are rounded to four decimal places (0.0001 precision) and benchmarked against NIST/SEMATECH Section 1.3.6.7.1 and OpenStax Introductory Statistics Chapter 6.

Key Critical Values for Hypothesis Testing

In statistical significance testing, critical values mark the boundaries of rejection regions. In one-tailed vs two-tailed tests, the test direction determines whether significance level α is placed in one tail or divided across both. Critical values sourced from NIST Section 1.3.6.7.1 include:

Worked Examples: Step-by-Step Probability Calculations

Depending on research design, researchers compute lower-tail, upper-tail, or bounded interval probabilities.

Worked Example 1: Finding Cumulative Lower-Tail Probability

Scenario: An automated laboratory analyzer has a normally distributed processing time with mean μ = 100 seconds and standard deviation σ = 10 seconds. Find the probability that a sample run completes in 114.5 seconds or less.

1. Standardize the raw value: z = (114.5 – 100) / 10 = 14.5 / 10 = 1.45.
2. Locate in z-table: Row 1.4 and column .05 intersect at 0.9265.
3. Result: P(X ≤ 114.5) = P(Z ≤ 1.45) = 0.9265. Approximately 92.65% of test runs complete within 114.5 seconds.

Worked Example 2: Finding an Interval and Two-Tailed Probability

Scenario: For the same analyzer (μ = 100, σ = 10), find the probability that a test run lasts between 88.0 and 118.0 seconds.

1. Standardize both bounds:
   • Lower bound: z₁ = (88.0 – 100) / 10 = -1.20.
   • Upper bound: z₂ = (118.0 – 100) / 10 = +1.80.
2. Look up cumulative areas:
   • Upper bound: Φ(1.80) = 0.9641 (Row 1.8, Column .00).
   • Lower bound: Φ(-1.20) = 1 – Φ(1.20) = 1 – 0.8849 = 0.1151.
3. Calculate the interval: P(-1.20 ≤ Z ≤ 1.80) = Φ(1.80) – Φ(-1.20) = 0.9641 – 0.1151 = 0.8490.
4. Result: 84.90% of all analyzer runs fall between 88.0 and 118.0 seconds. When performing two-tailed hypothesis testing, this interval subtraction separates the acceptance region from extreme rejection tails.

How to Calculate Z-Scores and Probabilities in Excel, R, and Python

Modern quantitative analysis computes normal distribution probabilities programmatically. Below are syntax templates across three standard research environments.

1. Microsoft Excel

• Cumulative probability P(Z ≤ 1.45): =NORM.S.DIST(1.45, TRUE) (yields 0.9265)
• Upper-tail probability: =1 - NORM.S.DIST(1.45, TRUE) (yields 0.0735)
• Two-tailed 95% critical value (α = 0.05): =NORM.S.INV(0.975) (yields 1.9600)
• Standardize raw score: =STANDARDIZE(114.5, 100, 10) (yields 1.45)

2. R

# Cumulative probability P(Z <= 1.45)
p_lower <- pnorm(1.45)

# Upper-tail probability
p_upper <- pnorm(1.45, lower.tail = FALSE)

# Interval between -1.20 and 1.80
p_between <- pnorm(1.80) - pnorm(-1.20)

# Critical z-value for two-tailed 95% confidence (alpha = 0.05)
z_crit <- qnorm(0.975)

3. Python (scipy.stats)

from scipy import stats

# Cumulative probability P(Z <= 1.45)
p_lower = stats.norm.cdf(1.45)

# Upper-tail probability
p_upper = stats.norm.sf(1.45)

# Interval between -1.20 and 1.80
p_between = stats.norm.cdf(1.80) - stats.norm.cdf(-1.20)

# Critical z-score for two-tailed 95% confidence (p = 0.975)
z_critical = stats.norm.ppf(0.975)

Common Pitfalls When Using Standard Normal Tables

When working with standard normal tables manually, watch for these common calculation errors:

• Misidentifying table layout: Confusing a mean-to-z table with a cumulative left-tail table introduces an error of 0.5000. Always check the cell value at z = 0.00 first.
• Using z-scores when sample size is small without known variance: When sample standard deviation s estimates unknown population standard deviation σ with n < 30, use Student's t-distribution. Review our guide to types of test statistics for test selection criteria.
• Splitting alpha incorrectly in two-tailed tests: In two-tailed tests at α = 0.05, each tail receives α/2 = 0.025, corresponding to critical z-values of ±1.960, not ±1.645.
• Premature rounding: Rounding intermediate z-scores before table lookup compounds rounding error. Retain full precision until looking up the two-decimal z-score.

Frequently Asked Questions About Z-Tables

What is the difference between a positive and negative z-table?

A positive z-table gives cumulative probabilities for z-scores ≥ 0.00 (probabilities from 0.5000 to 1.0000). A negative z-table gives probabilities for z-scores < 0.00 (probabilities from 0.0000 to 0.5000). If only a positive table is available, calculate negative probabilities using symmetry: Φ(-z) = 1 – Φ(z).

Can a z-score exceed 3.0?

Yes. While most printed tables end at z = 3.09 or 3.49, z-scores can take any real value. For z > 3.09, the cumulative probability exceeds 0.9990. Evaluate extreme z-scores programmatically using functions like scipy.stats.norm.cdf.

When should I use a z-table instead of a t-table?

Use a z-table when the population standard deviation (σ) is known or when sample size is large (n ≥ 30). When σ is unknown and sample size is small, use Student’s t-distribution.

What does a z-score of 0 mean?

A z-score of 0 indicates that the observed value is identical to the population mean (μ). Under the standard normal distribution, exactly 50% of the distribution lies below z = 0, giving a cumulative probability of 0.5000.