Question

For a Binomial Random Variable with n = 22 and p = .54, use Excel to calculate:

P(X = 8)

P(X <=15)

P(X > 13)

P(X ≥ 10)

P(9<=X<=21)

For a Normal Random Variable with μ = 22 and σ = 5.4, use Excel to calculate:

P(X < 18)

P(X > 26)

P(X > 10)

P(17 < X < 31)

You should attach an Excel file showing all of your work, including formulas.

Answer 1

1.a) P(X = 8) = BINOMDIST(8,22,0.54,FALSE) = 0.043913.

b) P(X <=15) = BINOMDIST(15,22,0.54,TRUE) = 0.941266.

c.) P(X > 13) = (1 - BINOMDIST(13,22,0.54,TRUE)) = 0.245612.

d.) P(X ≥ 10) = (1 - BINOMDIST(9,22,0.54,TRUE)) = 0.845638.

e.) P(9<=X<=21) = BINOMDIST(22,22,0.54,TRUE) - BINOMDIST(9,22,0.54,TRUE) = 0.845638.

2.a) P(X < 18) = NORMDIST(18,22,5.4,TRUE) = 0.229425.

b) P(X > 26) = 1 - NORMDIST(26,22,5.4,TRUE) = 0.229425.

c) P(X > 10) = 1 - NORMDIST(10,22,5.4,TRUE) = 0.986866.

d) P(17 < X < 31) = NORMDIST(31,22,5.4,TRUE) - NORMDIST(17,22,5.4,TRUE) = 0.774967.