Z.TEST(array, x [,sigma])

Returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values.

arrayThe array or range of data against which to test x.
xThe value to test.
sigma(Optional) The population (known) standard deviation.

* This function was added in Excel 2010 to replace the ZTEST function.
* This is similar to the CHISQ.TEST, F.TEST and T.TEST functions.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com


© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top