Excel Function : ZTEST
Category
Compatibility
Description
Returns the one-tailed probability-value of a z-test
Microsoft Excel Reference Page
https://support.office.com/en-us/article/ZTEST-function-8f33be8a-6bd6-4ecc-8e3a-d9a4420c4a6a
Syntax and Description of the ZTEST Excel Function
The syntax for the ZTEST function in Microsoft Excel is: ZTEST(array, mean, standard_deviation) array is the range of cells that contains the data to test. mean is the mean of the population. standard_deviation is the standard deviation of the population.
About ZTEST Excel Function
ZTEST returns the one-tailed probability-value corresponding to a z-test. For example, if the z-test statistic is -1.96, and you want to know the probability that the population mean is less than the mean of the sample, use ZTEST, specifying a significance level of 0.05.