Z.TEST
Returns the one-tailed p-value of a z-test
Syntax
Z.TEST(array, x, [sigma])
Parameters
- 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(A1:A10, 4)