Z.TEST |
| Z.TEST(array, x [,sigma]) |
Returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| array | The array or range of data against which to test x. |
| x | The value to test. |
| sigma | (Optional) The population (known) standard deviation. |
| REMARKS |
| * This is similar to the CHISQ.TEST, F.TEST and T.TEST functions. * This function was added in Excel 2010 to replace the ZTEST function. * 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