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
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?

Answer 1

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)