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.

Remarks

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

 A
1??

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