Explore BrainMass

# Using Excel to Solve Probability Problems

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

I need help in using excel to solve the following problem:

Problem 6.25

FACTS:

Suppose that the number of ounces of soda put into a Pepsi can is normally distributed with &#1506; =12.05 ounces and &#8706; = 0.03 ounce.
[Note: &#1506; = mean and &#8706; = standard deviation]

PROBLEM: USE MS EXCEL TO SOLVE THE FOLLOWING:

(a) Legally a can must contain at least 12 ounces of soda. What fraction of cans will contain at least 12 ounces of soda?

(b) What fraction of cans will contain less than 11.9 ounces of soda?

(c) What fraction of cans will contain at between 12 and 12.08 ounces of soda?

(d) One percent of all cans will weigh more than what value?

(e) Ten percent of all cans will weigh less than what value?

(f) Pepsi controls the mean weight in a can by setting a timer. For what mean should the meter be set so that only 1 in 1000 cans will be under weight?