NORMAL DISTRIBUTION

Flashcards created from the lecture notes on normal distribution concepts and Excel functions related to statistics.

What is the standard formula for calculating the cumulative probability for a standard normal distribution in Excel?

=NORM.S.DIST(z, TRUE) where z is the z-value.

How do you calculate the cumulative probability that a value is greater than a specific z-score in Excel?

=1-NORM.S.DIST(z, TRUE) where z is the z-score.

What Excel function is used to find the probability between two z-scores in a standard normal distribution?

=NORM.S.DIST(z1, TRUE) - NORM.S.DIST(z2, TRUE) where z1 and z2 are the z-scores.

What is the formula used in Excel to calculate the cumulative probability for a non-standard normal distribution?

=NORM.DIST(x, mean, standarddev, TRUE) where x is the value, mean is the mean, and standarddev is the standard deviation.

How do you find the inverse cumulative probability at a specific probability level in a standard normal distribution using Excel?

=NORM.S.INV(probability) where probability is the area under the curve to the left of the z-score.

What does the Excel formula =NORM.INV(probability, mean, standard_dev) calculate?

It calculates the x-value in a normal distribution corresponding to the given probability, mean, and standard deviation.