Returns the one-tailed P-value of a z-test.

For a given hypothesized population mean, x, Z.TEST 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.

Z.TEST takes 2 required arguments and 1 optional argument:

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

#1)
The arguments for the Z.TEST function are:
Argument Required? Description
array Required The array or range of data against which to test x.
x Required The value to test.
sigma Optional The population (known) standard deviation. If omitted, the sample standard deviation is used.
comments powered by Disqus