Question

# Sales Price.Eggs Ad.Type Price.Cookies 18 4.77 0 4.74 20 4.67 0 4.81 23 4.75 0 4.36...

 Sales Price.Eggs Ad.Type Price.Cookies 18 4.77 0 4.74 20 4.67 0 4.81 23 4.75 0 4.36 23 4.74 0 4.29 23 4.63 0 4.17 23 4.56 0 4.66 24 4.59 0 4.73 25 4.75 0 4.11 26 4.75 1 4.21 26 4.49 0 4.25 26 4.41 1 4.62 26 4.32 0 4.53 27 4.68 0 4.44 28 4.66 1 4.19 28 4.42 1 4.37 29 4.71 0 4.29 29 4.66 1 4.57 30 4.46 1 4.21 30 4.36 1 4.77 31 4.47 0 4 31 4.43 0 4.31 33 4.4 1 4.34 34 4.61 1 4.05 35 4.09 1 4.73 38 3.73 0 4.07 39 3.89 1 4.75 41 4.35 1 4 44 3.84 1 4.15 44 3.81 1 4.34 46 3.79 1 4.15
 SUMMARY OUTPUT Regression Statistics Multiple R 0.941103 R Square 0.885675 Adjusted R Square 0.872483 Standard Error 2.610661 Observations 30 ANOVA df SS MS F Significance F Regression 3 1372.796 457.5986 67.14038 2.25E-12 Residual 26 177.2043 6.815549 Total 29 1550 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 137.3699 10.83371 12.67985 1.22E-12 115.1009 159.6389 115.1009 159.6389 Price.Eggs -16.1184 1.645593 -9.79491 3.26E-10 -19.501 -12.7359 -19.501 -12.7359 Ad.Type 4.147389 1.039658 3.989187 0.000481 2.010342 6.284436 2.010342 6.284436 Price.Cookies -8.71078 1.901333 -4.58141 0.000101 -12.619 -4.80254 -12.619 -4.80254

1.    [Regression Analysis] Use the “supermarket” dataset found on Blackboard to answer the following question. This spreadsheet has data on the number egg sales (Sales), the price of eggs (Price.Eggs), if there was an advertisement for eggs up in the dairy department (Ad.Type, 1 if the ad was up, 0 if no ad was present), and the ofcookies (Price.Cookies)

a.    What are the mean and standard deviation for the Sales, Egg Prices, and Cookie Prices?

 Sales Pr Eggs Pr Cookies 18 4.77 4.74 Mean for sales 30 20 4.67 4.81 Mean for Pr Eggs 4.426333333 23 4.75 4.36 Mean for Pr Cookies 4.373666667 23 4.74 4.29 23 4.63 4.17 SD for Sales 7.187952884 23 4.56 4.66 SD for Pr Eggs 0.316643683 24 4.59 4.73 SD for Pr Cookies 0.25150856 25 4.75 4.11 26 4.75 4.21 26 4.49 4.25 26 4.41 4.62 26 4.32 4.53 27 4.68 4.44 28 4.66 4.19 28 4.42 4.37 29 4.71 4.29 29 4.66 4.57 30 4.46 4.21 30 4.36 4.77 31 4.47 4 31 4.43 4.31 33 4.4 4.34 34 4.61 4.05 35 4.09 4.73 38 3.73 4.07 39 3.89 4.75 41 4.35 4 44 3.84 4.15 44 3.81 4.34 46 3.79 4.15

Mean = Sum of all Vallues/ Number of Observations

SD= Standard Deviation=(Sum of square of Differencce between value and its mean)/number of observations)^(1/2)

#### Earn Coins

Coins can be redeemed for fabulous gifts.