Explore BrainMass
Share

Explore BrainMass

    Using Excel to Solve Probability Problems

    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 ע =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?

    © BrainMass Inc. brainmass.com October 9, 2019, 10:13 pm ad1c9bdddf
    https://brainmass.com/statistics/probability/using-excel-to-solve-probability-problems-212631

    Attachments

    $2.19