Question: Data Student Midterm Final 1 70 69 2 97 99 3 84 87 4 85 77 5 66 73 6 83 86 7 82 85
Data
Student Midterm Final
1 70 69
2 97 99
3 84 87
4 85 77
5 66 73
6 83 86
7 82 85
8 72 67
9 74 76
10 82 74
11 81 70
12 77 81
13 76 74
14 79 83
15 70 67
16 73 85
17 76 74
18 77 70
19 71 78
20 76 81
21 77 72
22 72 80
23 78 68
24 84 95
25 83 77
26 73 83
27 81 75
28 83 88
29 80 82
30 72 71
31 72 78
32 90 85
The fileSupermarket Transactions.xlsxcontains over 14,000 transactions made by supermarket customers over a period of approximately two years. For this problem, consider this data set the population of transactions.
a.If you were interested in estimating the mean of Revenue for the population, whymightit make sense to use a stratified sample, stratified by product family, to estimate this mean?
In terms of revenue, it is possible that there isSelect
more
less
Item 1
variability within a product family andSelect
more
less
Item 2
variability across different product families. This is exactly when stratified sampling is a good idea.
b.Suppose you want to generate a stratified random sample, stratified by product family, and have the total sample size be 250. If you use proportional sample sizes, how many transactions should you sample from each of the three product families?
Product Family Sample Size
Drink - ?
Food - ?
Non-Consumable - ?
c.Using the sample sizes from partb, generate a corresponding stratified random sample. What are the individual sample means from the three product families? What are the sample standard deviations? (Round your answers to two decimal places.)
Product Family Mean Standard Deviation
Drink$$
Food$$
Non-Consumable$$
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help