Answer:
45.88%
Step-by-step explanation:
We have in this case a binomial distribution when p = 0.25, since the probability is 25%
. The formula that we will use in excel is BINOM.DIST, separated by commas we must put the value of x, n, p and also if it is true or false. We know that n equals 32.
In this case we need to know when x = 7, 8 and 9 and add this, and thus we will obtain the probability:
P (X = 7) + P (X = 8) + P (X = 9)
Excel formulas: = BINOM.DIST (7,32,0.25, FALSE) + BINOM.DIST (8,32,0.25, FALSE) + BINOM.DIST (9,32,0.25, FALSE)
P = 0.1546 + 0.1610 + 0.1431
P = 0.4588
Probability that steve agrees with the company's claim 45.88%