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

ZTEST Function

The ZTEST function is one of the statistical functions. It is used to return 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.


ZTEST(array, x, [sigma])

The ZTEST 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 ZTEST function.


The figure below displays the result returned by the ZTEST function.

ZTEST 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