Articles with the tag:
Articles with the tag:
Try in the cloud

Z.TEST Function

The Z.TEST function is one of the statistical functions. It is used to return 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(array, x, [sigma])

The Z.TEST function has the following arguments:

Argument Description
array The range of numeric values against which to test x.
x The value to test.
sigma A population standard deviation. This is an optional argument. If it is omitted, the sample standard deviation is used.


How to apply the Z.TEST function.


The figure below displays the result returned by the Z.TEST function.

Z.TEST Function

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action