Explore 11 statistical tables, look up probabilities and critical values, and download printable PDF tables or a filterable Excel workbook.

Statistical Tables and Calculator for 11 Common Lookups

Statistical Tables and Calculator for 11 Common Lookups
ECONOMICS.MBA / ECONOMETRICS

Statistical tables can give three different answers to a question about two failures in ten trials. Do you want exactly two failures, at most two, or at least two? At a failure rate of 20%, those answers are about 30%, 68% and 62%. The calculation starts with the wording of the question.

Use the calculator to find a probability or critical value, then follow the worked example for your table. For a printed reference, download the PDF. The Excel workbook contains the full lookup grids and preserves the leading zeros in the random numbers.

Statistical tables calculator

Choose a table and its inputs. Each selector shows the available grid points, and the result updates immediately. For example, choose Student’s t, 9 degrees of freedom and 0.05 to see both the one-tail and two-tail cutoffs.

Which table answers your question?

Probability, critical value, or observed statistic?

A probability lookup starts with an outcome and returns an area. For example, a z score of 1.96 gives an upper area near 0.025. A critical-value lookup reverses the question. Start with a tail area and find the boundary that leaves that much probability beyond it. Finally, an observed statistic comes from the data. Compare it with a cutoff only after matching the model, tail and degrees of freedom.

Binomial distribution table for a fixed number of trials

A supplier ships ten components. Each has a 20% chance of failing an inspection, and the outcomes are independent. How often should an inspector expect exactly two failures? First, choose n = 10 and p = 0.20. Then read across k = 2. The point probability is 0.301990, or about 30.2%. Although two is the expected count, the inspector will see some other count on roughly seven out of ten shipments.

Independent trials with the same success probability. Both tails include k.
Trials nSuccess probability pCount kP(X = k)P(X ≤ k)P(X ≥ k)
100.200.1073740.1073741
100.210.2684350.375810.892626
100.220.301990.67780.62419
100.230.2013270.8791260.3222
100.240.088080.9672070.120874
100.250.0264240.9936310.032793
100.260.0055050.9991360.006369
100.270.0007860.9999220.000864
100.287.3728e-050.9999967.79264e-05
100.294.096e-0614.1984e-06
100.2101.024e-0711.024e-07

Exactly, at most, or at least?

For an acceptance rule that permits up to two failures, use the cumulative column instead. It gives 0.677800. By contrast, an investigation that opens at two or more failures has probability 0.624190. Those two probabilities add to more than one because both include exactly two failures. In fact, their sum equals one plus the point probability. That identity gives you a quick way to audit all three columns.

For sampling without replacement, ask how much each draw changes the pool. For example, drawing ten invoices from a batch of twelve with a known number of errors changes the odds substantially. A hypergeometric model accounts for the shrinking pool. The binomial calculation assumes the same success probability on each trial.

Source · SciPy binomial functions

Poisson distribution table for arrivals and event counts

Suppose a help desk receives an average of two calls per half hour. Under a homogeneous Poisson process, the count in that interval has mean λ = 2. Consequently, a quiet half hour with zero calls has probability about 0.135335. More surprisingly, exactly one call and exactly two calls have equal probabilities of about 0.270671 each.

Use the expected count for the entire observation window. Both tails include k.
Mean λCount kP(X = k)P(X ≤ k)P(X ≥ k)
200.1353350.1353351
210.2706710.4060060.864665
220.2706710.6766760.593994
230.1804470.8571230.323324
240.0902240.9473470.142877
250.0360890.9834360.052653
260.012030.9954660.016564
270.0034370.9989030.004534
280.0008590.9997630.001097
290.0001910.9999540.000237
2103.81899e-050.9999924.64981e-05

Match the rate to the window

For a full hour at the same rate, switch to λ = 4. The probability of no calls falls to about 0.018316. Alternatively, multiply the two half-hour zero-call probabilities because the model gives independent counts in disjoint intervals. Both routes produce the same answer.

A staffing manager may care about overload instead. For example, if the desk can handle three calls, overload begins at four. Use P(X ≥ 4) with λ = 2 to get 0.142877. Before applying that result to Monday mornings, check whether calls arrive in bursts or whether the rate changes across shifts. Either feature can make a single average misleading.

Source · SciPy Poisson functions

Standard normal distribution table for areas under the curve

A normal table can show the area below z, above z, or between zero and z. First, inspect the row for zero. A left-area table returns 0.500000 there, whereas a mean-to-score table returns zero. Next, inspect z = 1.00. A left-area table increases to 0.841345, while a right-area table decreases to 0.158655. Together, these two checks identify the convention.

Z has mean zero and standard deviation one. Two-tail area means P(|Z| ≥ |z|).
Score zLeft areaRight areaTwo-tail area |z|
-30.001350.998650.0027
-2.580.004940.995060.00988
-1.960.0249980.9750020.049996
-10.1586550.8413450.317311
00.50.51
10.8413450.1586550.317311
1.640.9494970.0505030.101005
1.960.9750020.0249980.049996
2.580.995060.004940.00988
30.998650.001350.0027

Translate a measurement into a z score

Suppose a filling machine produces normally distributed weights with mean 500 g and standard deviation 4 g. A 508 g package sits two standard deviations above the mean because (508 − 500) / 4 = 2. Therefore, about 2.28% of packages exceed 508 g. If the customer also flags packages under 492 g, the two-tail probability rises to about 4.55%.

For a sample mean, standardize using its standard error. For instance, averaging four independent packages divides the standard deviation of the mean by two. The same physical threshold now represents a different z score. Record whether the question concerns one item or an average before consulting the table.

Source · SciPy normal functions

Table of random numbers for reproducible sampling

A random-number table gives you a sequence of digits. Each five-digit group here preserves zeros on the left. To reproduce the sequence in Python, initialize random.Random(417) once, draw randrange(100000) for each cell, and format each integer to five digits. Then move across ten columns before starting the next row.

Five-digit groups in reading order
Row12345678910
178315947701047905247975665084437481868540600545824
200835856266058100042508171030004063416825064500681
334440107224621133355014214356654902140106160464934
403460795227581253547920941455567145567863290393880
547940193671653254734956346862655463791413660885949
646779175794280337355209234501325169122527871504050
767820967491633666689523483481354846037096533648885
893811892068640327470773014398335477891629023395327
997540305854106004240132710297788978801763925130624
1051118534121526806614267068992015460602618321722084
1109681829433509610540442186067852372914062997970013
1222481960642379579566060550994554350180920924079942
1328091359669361959188926944919665359371954898960429
1468227358836606013586651961824011154734750565494322
1554940775074279805936059244869177189401508424934332
1627332249845813409775074174772331979703659312485142
1734621216641236715379280538590749440524411274510017
1837088218431154014880981000097147991515119984146328
1929181765529308527163515601766036246921247665004657
2008046207958393236245643397735397429159420515293130

Draw invoice IDs without favoring low numbers

Imagine a population of 73 invoices labeled 01 through 73. Before looking at the digits, choose the first row, start in column one, and take the first two digits of each group. Accept 01 through 73. For a sample without replacement, skip 00, values above 73, and any ID already selected. Continue in the same direction until the sample reaches its planned size.

In the first row, 78 and 94 fall outside the roster. The next two groups select invoices 10 and 05. After skipping 97, the next valid ID is 50. Why skip instead of wrapping 74 back to 01? With 100 possible two-digit strings and 73 IDs, a wraparound rule gives some IDs two chances and others only one. By contrast, rejecting out-of-range values gives every eligible ID one route to selection. A fixed seed lets a reader audit the classroom example. For a real audit, record the roster order, starting rule and selection procedure before drawing the sample.

Source · Python random number generator

Student’s t distribution table for an estimated mean

Suppose ten independent observations from a normal population give a mean of 12 and a sample standard deviation of 3. The standard error is 3 / √10, or about 0.949. Because the mean calculation uses one degree of freedom, select df = 9. For a two-sided 95% confidence interval, read the 0.05 row and the two-tail column to get 2.262157.

The two-tail column gives the positive magnitude. Use its negative for the left cutoff.
dfαUpper one-tailTwo-tail ± cutoff
10.056.31375212.706205
20.052.9199864.302653
50.052.0150482.570582
90.051.8331132.262157
100.051.8124612.228139
150.051.753052.13145
200.051.7247182.085963
250.051.7081412.059539
300.051.6972612.042272
600.051.6706492.000298
1200.051.6576511.97993

Build the interval and check the tail

Multiplying 2.262157 by the standard error gives a margin of about 2.146. Therefore, the interval runs from 9.854 to 14.146. If the question asks only for a 95% upper confidence bound, the multiplier changes to 1.833113. The upper bound then becomes about 13.739.

The difference matters most in small samples. For example, replacing 2.262 with 1.960 shrinks the two-sided margin by roughly 13%. As the degrees of freedom increase, the t cutoffs approach their normal counterparts. In a regression, use the residual degrees of freedom from the fitted model. A simple n − 1 rule applies to the one-sample mean example.

Source · SciPy t distribution

Chi-square distribution table for variance and counts

A sample of ten independent normal observations has sample variance 4. To estimate population variance, start with (n − 1)s² = 36. A two-sided 95% interval leaves 0.025 in each tail. At nine degrees of freedom, the lower and upper chi-square cutoffs are about 2.7004 and 19.0228.

Each cutoff leaves the stated area in its own tail. For a 95% variance interval use 0.025.
dfTail area αLower cutoffUpper cutoff
10.0250.0009825.023886
20.0250.0506367.377759
50.0250.83121212.832502
90.0252.70038919.022768
100.0253.24697320.483177
150.0256.26213827.488393
200.0259.59077734.169607
250.02513.1197240.646469
300.02516.79077246.979242
600.02540.48174883.297675
1200.02591.572642152.211403

Why the larger cutoff gives the smaller endpoint

First divide 36 by 19.0228 to obtain 1.8925. Next divide 36 by 2.7004 to obtain about 13.33. Thus, the interval for variance stretches much farther upward than downward from the estimate of 4. To report standard deviation in the original measurement units, take the square root of each endpoint. That gives about 1.38 to 3.65.

For a contingency table, the lookup answers a different question. A standard independence test with three rows and four columns uses (3 − 1)(4 − 1) = 6 degrees of freedom. At an upper-tail area of 0.05, its cutoff is about 12.592. Check the expected cell counts and sampling design before interpreting the large-sample approximation.

Source · SciPy chi-square distribution

F distribution table for joint restrictions and variance ratios

In a classical linear regression, an F test can ask whether several slope coefficients are jointly zero. Suppose a restricted model has residual sum of squares 160 and an unrestricted model has 120. The additional regressors use two degrees of freedom, and the unrestricted model retains 20 residual degrees of freedom. Consequently, the observed statistic is [(160 − 120) / 2] / [120 / 20] = 3.3333.

Keep numerator and denominator degrees of freedom in this order.
Numerator dfDenominator dfUpper area αUpper cutoff
1200.054.351244
2200.053.492828
3200.053.098391
4200.052.866081
5200.052.71089
6200.052.598978
8200.052.447064
10200.052.347878
12200.052.277581
20200.052.124155

Keep the numerator and denominator in order

At α = 0.05, the F cutoff for (2, 20) is about 3.4928. Since 3.3333 falls below that threshold, the test fails to reject the joint restriction. For this comparison, fit both models to exactly the same observations. Otherwise, a change in the estimation sample also changes the residual sums of squares.

One identity makes an excellent spreadsheet check. With one numerator degree of freedom, the upper 5% F cutoff equals the square of the two-sided 5% t cutoff at the same denominator degrees of freedom. For example, at 20 residual degrees of freedom, 2.085963 squared gives about 4.3512. Compare those two entries in the workbook to catch a reversed tail or a misplaced df.

Source · SciPy F distribution

Durbin–Watson statistic and its two critical bounds

Order regression residuals by time before calculating d. In the numerator, sum the squared changes between neighboring residuals. In the denominator, sum all squared residuals. For example, the sequence 1, 1, −1, −1 gives d = 4 / 4 = 1. Reordering the same values as 1, −1, 1, −1 gives d = 12 / 4 = 3. The sums of squares match, yet the timing changes the diagnostic.

One-sided 5% bounds for positive autocorrelation. Include an intercept in the regression and exclude it from k.
Observations nSlopes kLower bound dLUpper bound dU
1520.9451.543
2021.11.537
2521.2061.55
3021.2841.567
4021.3911.6
5021.4621.628
6021.5141.652
8021.5861.688
10021.6341.715

Read the inconclusive region

Suppose a regression includes an intercept, two slopes and 20 observations. For a one-sided 5% test of positive first-order autocorrelation, the bounds are 1.100 and 1.537. A statistic of 0.95 falls below the lower bound, so reject the no-autocorrelation null. By contrast, 1.30 lies between the bounds and leaves the test inconclusive. A value of 1.80 exceeds the upper bound, so this positive-direction test fails to reject.

For negative autocorrelation, apply the same one-sided rule to 4 − d. Treat a value equal to a printed bound as a boundary case because the source rounds the entries. A lagged dependent variable in the regression changes the validity of the classical bounds procedure. Also, the four-observation example above illustrates arithmetic only. Use the actual regression sample size for inference.

Source · Penn State critical bounds

Wilcoxon W table for paired differences

Here W means the smaller of the positive and negative rank sums in a two-sided signed-rank test. Start with independent pairs and compute one difference per pair using a consistent direction. Under the null, a continuous symmetric difference distribution centers on zero. Rank the absolute differences from smallest to largest, then restore each sign.

W is the smaller signed-rank sum. Exact sign enumeration assumes distinct nonzero absolute differences. None means no rejection is attainable.
Nonzero pairs nTwo-sided αReject at W ≤Attained size
40.05None0
50.05None0
60.0500.03125
70.0520.046875
80.0530.039062
90.0550.039062
100.0580.048828
110.05100.041992
120.05130.04248
130.05170.047852
140.05210.049438
150.05250.047913

Why a nominal 5% test can reject only 3.125% of the time

Consider six differences of +1, +2, +3, +4, +5 and +6. Their positive ranks sum to 21 and their negative ranks sum to zero. Therefore W = 0. Under the null, six independent signs produce 64 equally likely patterns. Only the all-positive and all-negative patterns have W = 0, giving a two-sided probability of 2 / 64 = 0.03125.

For five pairs, even complete agreement gives 2 / 32 = 0.0625. As a result, the 5% table shows “None” for that sample size. A zero cutoff would incorrectly allow rejection. If zero differences or ties in the absolute differences occur, use software that handles them explicitly. For independent samples, use a rank-sum procedure with its own reference distribution.

Source · SciPy signed-rank test

Kolmogorov–Smirnov critical values for a distribution check

The one-sample, two-sided KS statistic D measures the largest vertical gap between the empirical cumulative distribution and a fully specified continuous reference distribution. For example, an analyst could compare draws from a simulation with a Uniform(0,1) model fixed before examining those draws. The lookup uses the finite-sample distribution of D for the selected n.

Finite-sample one-sample, two-sided D for a fully specified continuous null distribution.
Sample size nTwo-sided αCritical D
50.050.563275
100.050.409246
150.050.337596
200.050.294075
250.050.264041
300.050.241703
400.050.210115
500.050.188406
750.050.15442
1000.050.134028
2000.050.095158

Check both sides of every step

Suppose the ordered observations are 0.10, 0.20, 0.60 and 0.90. Immediately after the second observation, the empirical curve reaches 2 / 4 = 0.50, while the uniform curve equals 0.20. The gap is 0.30. Checking the other observations and the left limits at each step gives no larger gap, so D = 0.30.

At n = 20, the 5% cutoff is approximately 0.2941. A statistic of 0.30 would exceed that cutoff for twenty observations. However, the four-observation example must use the much larger cutoff for n = 4. Likewise, if you estimate the mean and standard deviation of a normal reference from the tested data, the ordinary KS calibration no longer applies. Use a fitted-parameter procedure or a parametric bootstrap that repeats the fitting step.

Source · SciPy finite-sample KS distribution

ADF critical values for a unit-root test

The augmented Dickey–Fuller regression relates a series change to its lagged level, optional deterministic terms and lagged changes. Under the unit-root null, the coefficient on the lagged level in this regression equals zero. Although the statistic looks like a t ratio, its null distribution depends on the deterministic terms. More negative values provide evidence against the unit-root null.

Single-series unit-root test. Effective T counts observations in the fitted ADF regression. MacKinnon 2010 response-surface estimates.
Effective TRegressionLeft area αCritical tau
25Constant0.05-2.986489
25Constant + trend0.05-3.603468
50Constant0.05-2.92136
50Constant + trend0.05-3.502275
100Constant0.05-2.890906
100Constant + trend0.05-3.455343
250Constant0.05-2.873172
250Constant + trend0.05-3.428199
500Constant0.05-2.867338
500Constant + trend0.05-3.419307

How a trend changes the decision

Consider an ADF statistic of −3.10 with 100 usable regression observations. At 5%, the constant-only cutoff is about −2.8912. The statistic falls below it, so that specification rejects the unit-root null. With a constant and linear trend, the cutoff is about −3.4553. The same numerical statistic would now fail to reject. In an actual analysis, refitting with a trend will usually change the statistic as well.

Choose the deterministic terms from the economic question and the series behavior before comparing results. Then count the observations that actually entered the fitted regression. For example, a series of 104 complete consecutive levels with three lagged differences leaves 100 usable observations after differencing and lagging. These entries use MacKinnon’s single-series response surfaces. An Engle–Granger test on estimated residuals requires a different calibration.

Source · MacKinnon, 2010, Tables 2 and 3

Three checks before you report a result

Read the inequality aloud. For example, “at least four” includes four. Consequently, subtract the cumulative probability through three from one. In Excel, the Poisson example uses =1-POISSON.DIST(3,2,TRUE).

Check the units of the answer. A t cutoff of 2.262 measures standard errors. By contrast, a KS cutoff of 0.2941 measures a vertical difference between two cumulative probabilities. Neither number, on its own, gives the probability that the null hypothesis is true.

Keep precision until the decision. The printed tables round their entries, and the DW source publishes rounded bounds. Therefore, when a statistic sits very close to a boundary, record more digits or consult the original procedure. For discrete tests, also check whether the rule includes equality. Wilcoxon W at its cutoff can still fall inside the rejection region.

How to document a statistical table lookup

Give your reader enough detail to reproduce one cell. For example, write “The joint test gave F(2, 20) = 3.333. The 5% upper cutoff was 3.493, so we failed to reject the two restrictions.” For a paired test, add the definition of W and the treatment of ties. For a unit-root test, name the deterministic terms, lag count and effective sample size. Those details let another reader check the conclusion even when their software uses a different table layout.

For further practice, see 12 solved regression diagnostics exercises and the NIST distribution gallery.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *