Returns the one-tailed P-value of a Z-test with standard distribution..
81% OFF online library of tutorials for mastering Google Sheets
Z.TEST()
Description
How To Use in Sheets
Z.TEST(data, value, [standard_deviation])
External Links
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.
0Better Sheets Tutorials
No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.