USA: +1(669)289-8683 
Sign in
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? |
