Z.TEST Function Explained
The Z.TEST Function in Microsoft Excel is used to calculate the one-tailed or two-tailed probability value of a normal distribution. It takes two arguments: an array of values 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 test specified.
Z.TEST Function Syntax
Z.TEST(array, x, sigma)
- array: The array or range of data to consider for the test.
- x: The hypothesized population mean.
- sigma: The population standard deviation. If omitted, the sample standard deviation is used.