

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)
Get Answers For Free
Most questions answered within 1 hours.