Details:Complete exercises 10.55, 10.57 (parts a and b only), 10.59 (part a only), 10.61 (part a only). You will need:• For 10.59, the “ERWaiting” file.• For 10.61, the “Coffee Sales” file.Exercises 10.59 and 10.61 require the use of the “One-Way ANOVA” function within the Data Analysis menu in Excel. Refer to Appendix E10 for instructions on using Excel for these exercises.Complete exercise 11.25Complete exercises 12.1, 12.4, 12.9, 12.17, 12.21, 12.43 (assume “Calories” is the “x” variable and “Fat” is the “y” variable). You will need:• For 12.4, the “Pet Food” file.• For 12.9, the “Rent” file.• For 12.17, the “Restaurants” file.• For 12.21, the “Rent” file.• For 12.43, the “Restaurants” file.Exercises 12.17, 12.21, and 12.43 require the use of the “Regression” function within the Data Analysis menu in Excel. Refer to Appendix E12 for instructions on using Excel for these exercises.For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output; this information is needed in order to receive full credit on these problems.
Among Groups:DfA = c – 1 = 4 – 1 = 3 SSA = 80 * 3 = 240 MSA = 80 Within Groups:DfW = n – c = 32 – 4 = 28Total:DfT = n – 1 = 31 (a) SSW = 560 F Stat = MSA/MSW = 80/20 = 4 MSW = 560/28 = 20 SST =…