NORMAL DISTRIBUTION

0.0(0)
studied byStudied by 1 person
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/5

flashcard set

Earn XP

Description and Tags

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

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

6 Terms

1
New cards

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.

2
New cards

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.

3
New cards

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.

4
New cards

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.

5
New cards

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.

6
New cards

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.