ZTEST Function Explained
The ZTEST Function in Microsoft Excel is used to calculate the one-tailed or two-tailed probability value of a z-test. It takes two arguments: an array of data and the mean of the population. It returns the probability that the sample mean is greater than or less than the population mean, depending on the type of z-test specified.
ZTEST Function Syntax
ZTEST(array, x, sigma)
- array: The array or range of data to test against the null hypothesis.
- x: The mean to compare the data to.
- sigma: The standard deviation of the population, if known. If omitted, the sample standard deviation is used.