ZTEST function

ZTEST( population , μ0 , sigma )

ZTEST computes the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) - that is, the observed sample mean.

Related links:

Statistics Functions