Question

Which of the following Excel functions can be used to determine a probability of a standard normal distribution?

A. NORM.S.DIST
B. VAR.S
C. BINOM.S.DIST
D. STDEV.S

Answer 1

The correct Excel function to determine the probability of a standard normal distribution is NORM.S.DIST.

Step-by-step explanation:

The correct Excel function to determine the probability of a standard normal distribution is NORM.S.DIST.

The NORM.S.DIST function can calculate the probability of a value being less than or equal to a given value in a standard normal distribution. It takes into account the mean and standard deviation of the distribution, allowing you to calculate probabilities for specific values.

For example, you can use the NORM.S.DIST function to find the probability of a value being less than or equal to 2 in a standard normal distribution with a mean of 0 and a standard deviation of 1. The probability can be calculated with the formula NORM.S.DIST(2,0,1).