Share
Explore BrainMass

Using Excel to Solve Probability Problems

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 ע =12.05 ounces and ∂ = 0.03 ounce.
[Note: ע = mean and ∂ = 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?

Attachments

$2.19