ZTEST
Returns the one-tailed probability-value of a z-test. Replaced by Z.TEST.
Syntax
ZTEST(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
=ZTEST(A1:A10, 4)