My professor gave us this problem to solve using Excel for extra credit. I just want to make sure I have the answer correct.
A basketball player attempts 20 shots in a game. His success rate is 35% of his shots. What is P(x>11) using binomial distribution?
I got the answer as 0.19579 ... Is this correct?
A basketball player attempts 20 shots in a game. His success rate is 35% of his shots. What is P(x>11) using binomial distribution?
I got the answer as 0.19579 ... Is this correct?
-
P( x > 11) = 0.019579
In Excel I did this
= 1 - BINOM.DIST(11,20,0.35,TRUE)
This "BINOM.DIST(11,20,0.35,TRUE) " gives me P(X < 11)
I then use the complement rule
P(X > 11) = 1 - P(X < 11)
which is given by
= 1 - BINOM.DIST(11,20,0.35,TRUE)
So P(X > 11) = 0.019579
In Excel I did this
= 1 - BINOM.DIST(11,20,0.35,TRUE)
This "BINOM.DIST(11,20,0.35,TRUE) " gives me P(X < 11)
I then use the complement rule
P(X > 11) = 1 - P(X < 11)
which is given by
= 1 - BINOM.DIST(11,20,0.35,TRUE)
So P(X > 11) = 0.019579
-
You're welcome.
Report Abuse