How to Find the P-Value in a Z-Test

How to Find the P-Value in a Z-Test
••• suman bhaumik/iStock/GettyImages

A ​z​-test is a test of the ​standard normal distribution​, a bell-shaped curve with a mean of 0 and a standard deviation of 1. These tests arise in many statistical procedures. A ​P​-value is a measure of the statistical significance of a statistical result. Statistical significance addresses the question: "If, in the entire population from which this sample was drawn, the parameter estimate was 0, how likely are results as extreme as this or more extreme?" That is, it provides a basis to determine whether an observation of a sample is merely the result of random chance (that is, to accept the null hypothesis) or whether a study intervention has in fact produced a genuine effect (that is, to reject the null hypothesis).

Although you can calculate the ​P​-value of a ​z​-score by hand, the formula is extremely complex. Luckily, you can use a spreadsheet application to carry out your calculations instead.

Step 1: Enter the Z-Score Into Your Program

Open the spreadsheet program and enter the ​z​-score from the ​z​-test in cell A1. For example, suppose you compare the heights of men to the height of women in a sample of college students. If you do the test by subtracting women's heights from men's heights, you might have a ​z​-score of 2.5. If, on the other hand, you subtract men's heights from women's heights, you might have a ​z​-score of −2.5. These are, for analytical purposes, equivalent.

Step 2: Set the Level of Significance

Decide if you want the ​P​-value to be higher than this ​z​-score or lower than this ​z​-score. The higher the absolute values of these numbers, the more likely your results are statistically significant. If your ​z​-score is negative, you almost certainly want a more negative ​P​-value;if it is positive, you almost certainly want a more positive ​P​-value.

Step 3: Calculate the P-value

In cell B1, enter =NORM.S.DIST(A1, FALSE) if you want the ​P​-value of this score or lower; enter =NORM.S.DIST(A1, TRUE) if you want the ​P​-value of this score or higher.

For example, if you subtracted the women's heights from the men's and got ​z​ = 2.5, enter =NORM.S.DIST(A1, FALSE); you should get 0.0175. This means that if the average height of all college men were the same as the average height of all college women, the chance of getting this high a ​z​-score in a sample is only 0.0175, or 1.75 percent.


  • You can also calculate these in R, SAS, SPSS or on some scientific calculators.

Related Articles

How to Calculate a P-Value
How to Interpret a Student's T-Test Results
How to Interpret Chi-Squared
How to Calculate Statistical Significance
How to Interpret an Independent T Test in SPSS
How to Calculate Stanine Scores
How to Calculate a T-Score
How to Chi-Square Test
Advantages & Disadvantages of Finding Variance
How to Calculate Statistical Difference
How to Grade Using a Square Root Curve
How to Calculate Statistical Sample Sizes
How to Calculate Measurement Errors
How to Calculate Correlation Coefficient Between Two...
How to Calculate a Confidence Interval
How to Calculate CV Values
How to Interpolate Numbers
What Is the Meaning of Sample Size?
How to Calculate the T Test Value
How to Report Z-Score Results