Using Excel to Solve Probability Problems
Not what you're looking for?
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?
Purchase this Solution
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.