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

Returns the two-tailed p-value of a z-test.

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


* Added in Excel 2010.
* This function replaces the ZTEST function.
* For the Microsoft documentation refer to support.microsoft.com


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