Buzz
Probability calculation is a common task when performing tests or predicting real-life data. There are scenarios where you need to compute the one-sided probability value of a z-test.
ZTEST Function in Excel
Using ZTEST Function in Excel - Illustrated Examples
Syntax: ZTEST(array, x, sigma)
Where:
- array: Mandatory - The array or range of data to be tested against x.
- x: Mandatory - The value to be tested.
- sigma: Optional - The population standard deviation (known). If omitted, the sample standard deviation will be used.
Consider the Example Below
- Input your real values into Excel corresponding to the parameters of the ZTEST function
- Enter the formula in cell C8 to calculate the one-sided probability value. We get the following result
So now you know how to use the ZTEST function in Excel. This function is used to calculate the one-sided probability value of the z-test, but you can also apply it to compute the two-sided probability value with the population mean base value μ0 using the formula above.
