# Among coffee drinkers, men drink a mean of 3.2 sups per day with a standard deviation of 0.8 cups. Assume the number of coffee drinks per day follows normal distribution.  Please show in Excel how to put in formula for answers. Will need a break of how it is done in  Excel.  A. What proportion drink 2 cups per day or more?B. What proportion drink no more than 4 cups per day?

Question
45 views

Among coffee drinkers, men drink a mean of 3.2 sups per day with a standard deviation of 0.8 cups. Assume the number of coffee drinks per day follows normal distribution.  Please show in Excel how to put in formula for answers. Will need a break of how it is done in  Excel.

A. What proportion drink 2 cups per day or more?

B. What proportion drink no more than 4 cups per day?

check_circle

Step 1

Solution: It is given that:

Among coffee drinkers, men drink a mean of 3.2 sups per day with a standard deviation of 0.8 cups. Assume the number of coffee drinks per day follows normal distribution.

Therefore, we have:

Step 2

A. What proportion drink 2 cups per day or more?

Answer: It is required to find:

Step 3

The excel formula to find this pr...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

### Statistics 