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