2) A researcher wanted to study the coffee drinking habits of women ages 25 to 40. She took a sample of 6 women and asked them how many ounces of coffee they had that day. She got the following responses: 12, 8, 14, 12, 0, 20
What is the sample mean, median and mode for number of ounces of coffee? (4 points)
What is the sample variance and sample standard deviation for the data? (4 points)
(first part) find the 75th percentile of the following data (3 points): 100, 117, 95, 108, 124, 80, 93, 107 ?
after arranging in ascending order 80,93,95,100,107,108,117,124,
there are 8 observations and 75th percentile will be next to 8*75/100=6th observations, i.e. 117
(second part)
the population she is working with: coffee drinking habits of women ages 25 to 40.
What is the sample mean, median and mode for number of ounces of coffee? (4 points)
sample mean=(12+8+14+12+0+20)/6=11
sample median=middle observations=(average of 3rd and 4th observations)=(12+12)/2=12
mode=12(most-common or most-frequently occurring value in a series of data)
What is the sample variance and sample standard deviation for the data? (4 points)
sample variance=sum(x-mean)2/(n-1)=222/(6-1)=44.4
sample standard deviation=sqrt(sample variance)=sqrt(44.4)=6.66
| sn | x | x-mean | (x-mean)2 |
| 1 | 0 | -11 | 121 |
| 2 | 8 | -3 | 9 |
| 3 | 12 | 1 | 1 |
| 4 | 12 | 1 | 1 |
| 5 | 14 | 3 | 9 |
| 6 | 20 | 9 | 81 |
| sum= | 66 | 0 | 222 |
Find the 75th percentile of the following data (3 points): 100, 117, 95, 108, 124, 80,...
Find the 25th, 50th, and 75th percentile from the following list of 25 data 1 3 4 5 10 12 14 30 36 39 41 44 46 55 59 61 64 74 77 83 87 92 93 95 97 25th percentile = 50th percentile = 75th percentile =
Here is a data set (n = 117) that has been sorted. 56.8 69.8 71.2 73.7 75.5 77. 4 78.7 80.3 81. 8 84. 5 87 88.6 92.4 59.9 70.4 72.2 74 75.6 77.5 78.7 80.5 8 2 85 87.1 88.6 92.7 61.2 70.4 72.3 74.1 75.9 77.7 78.7 80.8 82.2 85.3 87.6 88.9 92.8 62.2 68.4 70.5 70.6 72.4 72.5 74.2 74.3 76.1 76.2 77.8 77. 8 78.9 79.1 | 81 | 81.1 82.2 82.2 86.1 86.5 87.8 87.9...
Can you please provide the formula for the worksheet also.
CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....