Please give detailed explanation Thanks again!

Question 1

A company sells the same product in four different packages at the same price. The sales of each package type for twelve months are listed in the following table. Is there any indication of differences in the mean sales of this brand of product across the various package types? Use a significance level of 0.05. (Please present your ANOVA Table generated by Excel explain how to make it in excel)

PackageType Sales PackageType Sales PackageType Sales Package Type Sales

1 5014 2 5044 3 4944 4 4848

1 4880 2 5095 3 5029 4 5165

1 4877 2 5106 3 4914 4 4934

1 4879 2 5053 3 5087 4 4929

1 4868 2 5047 3 4887 4 4925

1 5226 2 5049 3 4992 4 5085

1 4871 2 4946 3 4897 4 5053

1 4963 2 4897 3 4975 4 5070

1 5097 2 4955 3 5183 4 5131

1 5089 2 4895 3 4953 4 4723

1 4957 2 5117 3 4960 4 4853

1 4900 2 5061 3 4942 4 4963

Package Sales Package Sales Package Sales Package Sales type type type type 5014 2 5044 3 4944 4 4848 1 4880 2 5095 3 5029 4 5165 1 4877 2 5106 3 4914 4 4934 1 4879 2 5053 3 5087 4 4929 1 4868 2 5047 3 4887 4 4925 1 5226 2 5049 3 4992 4 5085 4871 2 4946 3 4897 4 5053 4963 2 4897 3 4975 4 5070 5097 2 4955 3 5183 4 5131 1 5089 2 4895 3 4953 4 4723 1 4957 2 5117 3 4960 4 4853 4900 2 5061 3 4942 4 4963SUMMARY OUTPUT Regression Statistics Multiple R 0.443696244 R Square x1 Adjusted R Square 0.193359224 Standard Error 3.996685058 Observations 231 ANOVA SS MS Regression 896.6418865 896.641886 Residual 229 x3 15.9734915 Total 230 4554.571429 Coefficients Standard Error t Stat Intercept 7.286531113 0.988867818 7.36855926 Cigarettes 0.189742532 0.02532533 x2Student Midterm Final Student Midterm Final Student Midterm Final 1 72 70 31 73 77 61 80 75 2 95 100 32 89 87 62 91 84 3 83 88 33 74 74 63 74 77 4 85 75 34 75 78 64 69 62 5 65 73 35 93 96 65 88 92 6 82 86 36 74 84 66 84 79 7 84 85 37 88 90 67 83 82 8 74 69 38 83 89 68 87 81 9 74 76 39 90 100 69 82 89 10 82 73 40 82 82 70 72 63 11 81 71 41 79 85 71 97 87 12 75 80 42 62 60 72 88 91 13 78 72 43 73 70 73 70 71 14 78 83 44 88 88 74 83 78 15 72 58 45 76 80 75 92 97 16 73 83 46 76 86 76 94 92 17 75 76 47 76 68 77 63 56 18 79 69 18 80 84 78 83 91 19 72 76 49 84 92 79 81 78 20 75 79 50 84 74 80 84 94 21 77 74 51 91 98 81 78 71 22 71 80 52 70 64 82 84 93 23 78 70 53 76 78 83 91 88 24 83 93 54 74 79 84 78 88 25 84 78 55 68 76 85 71 76 26 71 81 56 80 88 86 77 79 27 81 73 57 87 94 87 78 78 28 82 88 58 92 86 88 70 74 29 79 83 59 84 87 89 86 89 30 71 69 60 79 75 90 79 85