NORMAL DISTRIBUTION EXCEL - NORMAL DISTRIBUTION...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
NORMAL DISTRIBUTION Characteristics Bell shaped curve X-scale: mean = μ and standard deviation = σ (The normal distribution) Z-scale: mean = 0, standard deviation = 1 (The standard normal distribution) EXCEL NORMDIST(k, μ , σ ,FALSE) = The density at X = k for a normal distribution with mean = μ and standard deviation = σ (Not a probability) NORMDIST(k, μ , σ ,TRUE) = P(X k) for a normal distribution with mean = μ and standard deviation = σ NORMSDIST(k) = P(Z k) for the standard normal distribution NORMINV(p, μ , σ ) = x value that puts probability p to the left of x from a normal distribution with mean μ and standard deviation σ NORMSINV(p) = z value that puts probability p to the left of z from a standard normal distribution Examples Example 1 NORMDIST(k, μ , σ ,FALSE) for a Normal Distribution with μ = 60 and σ = 8 60 σ = 8 74 =NORMDIST(74,60,8,FALSE ) gives the height of this line
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

NORMAL DISTRIBUTION EXCEL - NORMAL DISTRIBUTION...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online