Z.TEST function
Summary
Returns the one-tailed probability-value of a z-test
Syntax
Z.TEST(array,x,[sigma])
The Z.TEST function syntax has the following arguments:
• Array Required. The array or range of data against which to test x.
• x Required. The value to test.
• Sigma Optional. The population (known) standard deviation. If omitted, the sample standard deviation is used.
• Array Required. The array or range of data against which to test x.
• x Required. The value to test.
• Sigma Optional. The population (known) standard deviation. If omitted, the sample standard deviation is used.
Example
=Z.TEST(A2:A11,4)
=2 * MIN(Z.TEST(A2:A11,4), 1 - Z.TEST(A2:A11,4))
=Z.TEST(A2:A11,6)
=2 * MIN(Z.TEST(A2:A11,6), 1 - Z.TEST(A2:A11,6))
=2 * MIN(Z.TEST(A2:A11,4), 1 - Z.TEST(A2:A11,4))
=Z.TEST(A2:A11,6)
=2 * MIN(Z.TEST(A2:A11,6), 1 - Z.TEST(A2:A11,6))