Formulas > =Z.TEST()

How To Use Z.TEST() Function in Google Sheets


Returns the one-tailed P-value of a Z-test with standard distribution.

Common questions about the Z.TEST formula include:
1. What is the Z.TEST formula?
2. How is the Z.TEST formula used?
3. What does the Z.TEST formula tell us?

The Z.TEST formula can be used appropriately to calculate the statistical significance in comparing two datasets by determining if the difference between the two is simply due to chance.

The Z.TEST formula can be commonly mistyped as ""Z test,"" ""Z-test,"" or ""Z.test.""

Common ways the Z.TEST formula is used inappropriately include using it as a general hypothesis test, or using it to compare means without first checking that the datasets are normally distributed.

Common pitfalls when using the Z.TEST formula include not considering the effect of outliers in the dataset, or forgetting to adjust the degrees of freedom when comparing two datasets of different sizes.

Common mistakes when using the Z.TEST Formula include using the wrong value of z, using the wrong standard deviation, or not considering the effect of outliers.

Common misconceptions people might have with the Z.TEST Formula include believing it is the same as a t-test or correlational analysis, believing it is related to ANOVA, mistaking a one-tailed test for a two-tailed test, or assuming it can compare means of more than two datasets.

Also see ZTEST()

How To Actually Use Z.TEST() in Sheets

Z.TEST(data, value, [standard_deviation])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the Z.TEST() formula:

Hypothesis Tests for One Mean with Google Sheets

In this video, a One Mean Z Test is performed with the help of Google Sheets. The hypotheses, P-value, and conclusion are explained in the context of the example. A small P-value is obtained so a conclusion is reached to reject the null hypothesis.

Generate a Z.TEST() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.