| | | | | | | | | Name: |
| >> Neither give nor receive assistance on this problem. |
| >> A "File/Print" hard copy of this sheet is due at the beginning of class on Friday, July 11. |
| Answer (in the highlighted cells) the questions below by relying on the appropriate |
| Excel statistical functions. |
| Note: The highlighted cells are formatted to display 6 decimal places, and |
| 6 decimal places are to show for each answer. |
| The amounts of ground coffee packaged in cans at a plant are approximately |
| normally distributed with a mean of 750 grams and a standard deviation of 12 grams. |
| (a) What is the probability of a can containing more than 775 grams of coffee? |
| (b) What is the probability of a can containing between 760 and 770 grams of coffee? |
| (c) What is the probability of a can containing less than 730 grams of coffee? |
| (d) For what amount of coffee do only 5% of the cans contain that much or more coffee? |
tv
business_stats.xlsx
