Z.TEST()

Description

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

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 yet. Stay tuned!