Needs to be done in 19 hours.
take-home problem
NAME: |
Answer (in the outlined cells) the questions below by relying on the appropriate |
Excel statistical functions. Note: The outlined cells are formatted to display 6 decimal places, |
and 6 decimal places are to be shown for each answer on the hard copy you submit. |
The amounts of ground coffee packaged in cans at a plant are approximately |
normally distributed with a mean of 760 grams and a standard deviation of 11 grams. |
(a) What is the probability of a can containing more than 800 grams of coffee? |
(b) What is the probability of a can containing between 750 and 770 grams of coffee? |
(c) What is the probability of a can containing less than 710 grams of coffee? |
(d) For what amount of coffee do only 5% of the cans contain that much or more coffee? |