# Question: Recall from Chapter 2 that the file Supermarket Transactions xlsx contains

Recall from Chapter 2 that the file Supermarket Transactions.xlsx contains 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 interesting in estimating the mean of Revenue for the population, why might it make sense to use a stratified sample, stratified by product family, to estimate this mean?

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?

c. Calculate the population standard deviations for each of the three product families. Given these and the discussion in the book, do you think the optimal sample sizes would be much different from the proportional sample sizes?

d. Using the sample sizes from part b, generate a corresponding stratified random sample. What are the individual sample means from the three product families? What are the sample standard deviations?

a. If you were interesting in estimating the mean of Revenue for the population, why might it make sense to use a stratified sample, stratified by product family, to estimate this mean?

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?

c. Calculate the population standard deviations for each of the three product families. Given these and the discussion in the book, do you think the optimal sample sizes would be much different from the proportional sample sizes?

d. Using the sample sizes from part b, generate a corresponding stratified random sample. What are the individual sample means from the three product families? What are the sample standard deviations?

## Answer to relevant Questions

This problem illustrates an interesting variation of simple random sampling.a. Open a blank spreadsheet and use the RAND() function to create a column of 1000 random numbers. Don’t freeze them. This is actually a simple ...The file P02_35.xlsx contains data from a survey of 500 randomly selected households. For this problem, consider this data set a simple random sample from all possible households, where the number of households in the ...Calculate the following quantities using Excel. a. P(-2.00 ≤ t10 ≤ 1.00), where t10 has a t distribution with 10 degrees of freedom.b. P(-2.00 ≤ t100 ≤ 1.00), where t100 has a t distribution with 100 degrees of ...A light bulb manufacturer wants to estimate the total number of defective bulbs contained in all of the boxes shipped by the company during the past week. Production personnel at this company have recorded the number of ...Senior management of a large consulting firm is concerned about a growing decline in the organization’s weekly number of billable hours. Ideally, the organization expects each professional employee to spend at least 40 ...Post your question