Jared L.

asked • 10/16/17

Need help with excel formula and answer.Thanks! My guess of the answer is 12.11% Am i right?

The Boy Scouts of America organization has determined that 20% of supermarket customers will purchase popcorn outside the store from cub scouts for its yearly fundraising efforts.

Assuming a binomial distribution, what is the probability that at least 4 of the next 10 customers will purchase popcorn?

Need the excel formula and how you got to it. Thanks I tried it and got .1211    Am i right? If not, please help haha

1 Expert Answer

By:

Kenneth S. answered • 10/17/17

Tutor
4.8 (62)

Expert Help in Algebra/Trig/(Pre)calculus to Guarantee Success in 2018

Jared L.

So the professor asked for the answer and the excel formula we used to get that answer....What would the excel formula be? BINOMIAL.DIST(?, 10, .20, false?)....I have no clue...i might have gotten the answer, but i dont know how to find that answer ONLY using an excel formula. Can you help?
Report

10/17/17

Kenneth S.

It appears from what you say that you are being TRAINED to write function calls, whereas I approached the problem based on understanding of the binomial probability distribution. It's based on expansion of (F+S)10 and there will be eleven terms, each of which has a coefficient (from Pascal's triangle) that expresses how many ways there are to have exactly r Sucesses, in ten trials, where probability of success is S and probability of failure is F, and S+F = 1. The exponents on S & F in each term total 10; the term.
 
Now, back to your training. Consult the manual, and notes, etc. to get precise definition of what the arguments (parameters) ought to be on your BINOMIAL.DIST command. 
Report

10/17/17

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.