Math

StatisticsQ&A LibraryAmong 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

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?

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...

Tagged in

Find answers to questions asked by student like you

Show more Q&A

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 ...

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...

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...

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 ...

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...

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...

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

A: Confidence interval:

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...

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

A: Click to see the answer