ZTEST(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

* Z.TEST was added in Excel 2010 to replace this function.
* If array is empty, then #N/A is returned.
* The z-test generates a standard score for x with respect to the data set, array, and returns the two-tailed probability for the normal distribution. You can use this function to assess the likelihood that a particular observation is drawn from a particular population.
* For the Microsoft documentation refer to support.office.com

 A
1=ZTEST({3,6,7,8,6,5,4,2,1,9},4) = 0.091
2=ZTEST({2,4,6,8,10},3) = 0.017


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