Which function computes the cumulative probability given a z value?

The function that computes the cumulative probability given a z value is the NORM.S.DIST function. This function is specifically designed to provide the cumulative distribution function (CDF) for the standard normal distribution, which has a mean of 0 and a standard deviation of 1. When you input a z value into this function, it calculates the probability that a value from the standard normal distribution is less than or equal to that z value.

Understanding cumulative probabilities is crucial in statistics, as it helps in determining the probability of a random variable falling within a certain range, which is a common requirement in hypothesis testing and confidence interval estimation. By using NORM.S.DIST, you can easily find the cumulative probability associated with any given standard z-score, which is a standard procedure in statistical analysis.

Other functions listed serve different purposes; for instance, NORM.S.INV is used to find the z value corresponding to a given cumulative probability. NORM.DIST can calculate the probability for a normal distribution with specified mean and standard deviation, but it is not limited to the standard normal distribution. Lastly, NORM.INV is a function used to find the z value for a specified cumulative probability as well, making it useful for different applications than what is required