Question
Asked Feb 2, 2020
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

Expert Answer

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:

 

Statistics homework question answer, step 1, image 1
fullscreen
Step 2

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

Answer: It is required to find:

 

Statistics homework question answer, step 2, image 1
fullscreen
Step 3

The excel formula to find this pr...

Statistics homework question answer, step 3, image 1
fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

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

Math

Statistics

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Identify two advantages of nonparametric methods over parametric methods. When is a parametric proce...

A: The advantages of non-parametric methods over parametric methods are given below:The non-parametric ...

question_answer

Q: What is meant by saying that a variable has a chi-square distribution?

A: Chi-square distribution: If the distribution of the variable has a special type of right skewed curv...

question_answer

Q: State whether each of the following is true or false and explain your answer. a. The estimate of the...

A: a.The estimate of the mean of the response variable for a given set of predictor variables is same a...

question_answer

Q: Is the national crime rate really going down? Some sociologists say yes! They say that the reason fo...

A: Hey, since there are multiple subparts posted, we will answer first three question. If you want any ...

question_answer

Q: The first row of a stem-and-leaf chart appears as follows: 62 | 1 3 3 7 9. Assume whole number value...

A: Given Leaf plot 62 | 1 3 3 7 9The data are 621, 623, 623, 627, 629Range is 8. It is shown belowRange...

question_answer

Q: How do I Compute the Pearson product Moment Correlation coefficient for the following variables: Yea...

A: Correlation coefficient - r:The Karl Pearson’s product-moment correlation coefficient or simply, the...

question_answer

Q: Which interval is wider: (a) the 95% confidence interval for the conditional mean of the response va...

A: Confidence interval:

question_answer

Q: A hypothesis test, based on a paired sample, is to be performed to compare the means of two populati...

A: In this context, the sample of 15 paired differences contains outlier. However, the removal of outli...

question_answer

Q: A sociologist randomly selects single adults for different groups of​ three, and the random variable...

A: Click to see the answer