Question

p =0.1

n= 10

a) P( X_>5) give Excel formula

b) P( X_>6) give Excel formula

c) P( X_>7) give Excel formula

d) P( X_>8) give Excel formula

Answer 1

Solution:

We are given

n = 10

p = 0.1

Part a

P(X≥5) = 1 – P(X≤4) = 1 - 0.998365 = 0.001635

[for P(X≤4), use binomial command =BINOMDIST(4,10,0.1,1)]

P(X≥5) = 0.001635

Part b

P(X≥6) = 1 – P(X≤5) = 1 - 0.999853 = 0.000147

[for P(X≤4), use binomial command =BINOMDIST(5,10,0.1,1)]

P(X≥5) = 0.000147

Part c

P(X≥7) = 1 – P(X≤6) = 1 - 0.999991= 0.00000912

[for P(X≤6), use binomial command =BINOMDIST(6,10,0.1,1)]

P(X≥7) = 0.00000912

Part d

P(X≥8) = 1 – P(X≤7) = 1 - 1= 0

[for P(X≤7), use binomial command =BINOMDIST(7,10,0.1,1)]

P(X≥7) = 0.0000