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


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