I have completed questions 1 - 7 but I'm needing help with questions 8 - 11.

Solving Problems with Statistical Analysis Tools Chapter 2 Case Problems Level 1 Analyzing Sales for Cremes lce Cream Judd Hemming is the eastern regional marketing manager for Cremes Ice Cream. Each quarter, he completes two separate analy an analysis comparing ice cream flavor sales volumes from all regional locations with the same quarter sales volumes from the previous year, and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store Sales by Flavor in Gallons The first analysis, sales by flavor, compares the total quantities sold in gallons. The data collected provides for cach flavor the number of pints, gallons, and 10 gallon tubs sold for all stores. Pints and gallons are sold directly to the public, whereas 10-gallon tubs are used for in-store sales of cones, cups, and specialty items such as sundaes and banana splits. To climinate any impact of pricing changes or special promotions, Judd uses the ice cream volumes in gallons to compare sales by flavor. Judd has asked for your help this quarter in completing this analysis. He created two workbook files: Creme.xlsx, which contains the current quarter's sales on a worksheet named Flavors, and HCreme.xlsx, which contains the corresponding historical quarterly data for the previous year on a workshect namcd HFlavors. For convenience, the flavors in both data sets are in identical order except for two new flavors introduced this year, which appear at the bottom of the current data set. Keep in mind the following conversions when analyzing this data: There are 8 pints per gallon. Each tub holds 10 gallons. Also, when calculating values for 10-gallon tubs, Judd has asked you to use the convention of rounding down the values to the nearest whole tub Sales by Store in Dollars The second analysis you need to complete is to summarize sales in dollars by store and compare the result with the previous year's sales. The Stores worksheet in the same workbook contains sales by store for the current quarter in dollars rounded to the nearest housand dollars. You need to calculate some basic statistics for store sales. In the same quarter of the previous year, these values were: Mean: $8,817 Median: $8,000 Mode: S5,5000 Standard Deviation: S2,920 147