Question: Use the data on Q1-6 worksheet in the Excel file to answer questions 1 - 6 .The data is for all 20 stores owned by
Use the data on Q1-6 worksheet in the Excel file to answer questions 1 - 6.The data is forall 20 storesowned by the Bango Bakery Company during the month of June. All numbers are average values. Note: store identifier is not a variable in this data set.





Dozens Sales of sold Other featured Profit from Store Number of Pastry each featured item each Featured Total Identifier employees type day items day Item Sales Profit A1 3 Fried 8 Chocolates 25 $250.00 $330.00 A2 11 Fried 11 Chocolates 19 $276.00 $408.00 A3 12 Rolls 10 Chocolates 24 $320.00 $440.00 A4 4 Fried 5 Tea 8 $648.00 $693.00 A5 11 Baked 14 Tea 30 $750.00 $918.00 A6 8 Rolls 9 Tea 23 $922.00 $1,012.00 A7 2 Fritters Chocolates 22 $354.00 $424.00 A8 12 Fried 9 Coffee 19 $514.00 $604.00 A9 4 Rolls 7 Coffee 17 $468.00 $531.00 Gluten A10 4 Free 10 Bacon 18 $244.00 $354.00 A11 12 Rolls 8 Coffee 19 $552.00 $624.00 Gluten A12 7 Free 10 Coffee 29 $545.00 $635.00 A13 10 Fritters 10 Coffee 21 $484.00 $574.00 A14 2 Fritters 8 Chocolates 19 $333.00 $397.00 A15 11 Baked 4 Chocolates 9 $308.00 $356.00 A16 11 Rolls 8 Coffee 16 $512.00 $600.00 A17 4 Fried 4 Tea 20 $640.00 $684.00 A18 10 Rolls 10 Coffee 27 $805.00 $905.00 A19 8 Fried 3 Chocolates 24 $416.00 $446.00 A20 8 Fritters 14 Coffee 27 $481.00 $649.00X Cars Sold 0 1 2 3 4 P(X) Cars Sold 0.05 0.05 0.5 0.3 0.1\fFlaws in Tile tile 1 2 5 B 4 4 6 5 1Subgroup Subgroup Day Subgroup Mean Range 1 6 8.17 4.11 2 6 3.8 4.5 6 2.77 3.82 4 6 2.86 4.14 5 6 3.85 4.55 6 6 4 4.87 6 3.57 3.85
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
