151k views
3 votes
Go into detail on how to solve. Use excel instead of using a

table.
Let X have a binomial distribution with parameters n=25 and p=4 Calculate P(9

User Amunds
by
8.1k points

1 Answer

1 vote

Final answer:

To find P(x ≤ 12) for a binomial distribution in Excel, use the formula =BINOM.DIST(12, 25, 0.4, TRUE) in a cell and press Enter.

Step-by-step explanation:

To calculate the probability P(x ≤ 12) for a binomial distribution with parameters n = 25 and p = 4 (which seems like a typo, as p should be a probability between 0 and 1), we can use Excel instead of looking up values in a binomial table. Assume the correct value of p is a probability such as 0.4.

Here are the steps to perform the calculation in Excel:

If you wanted to calculate the cumulative probability for a different number of successes, you would replace the '12' in the formula with the desired number of successes.

User Aleksey Cherenkov
by
7.3k points