Question

Hi I need help with these questions on Excel for linear regression!

Gulf Home Data
	Price	Size	Number of	Niceness	Pool?
Home	($1000s)	(Square Feet)	Bathrooms	Rating	yes=1; no=0			This information is taken from 80 homes recently sold
1	260.9	2666	2.5	7	0			along the Gulf of Mexico coast. You are to analyze
2	337.3	3418	3.5	6	1			the data to discover which of the variables have a
3	268.4	2945	2.0	5	1			statistically significant influence on the sales price.
4	242.2	2942	2.5	3	1			Then prepare a brief report on your findings and
5	255.2	2798	3.0	3	1			suggest what a home owner in this market might
6	205.7	2210	2.5	2	0			do to improve the selling price of his/her home.
7	249.5	2209	2.0	7	0		Variables
8	193.6	2465	2.5	1	0		Home =	The observation of interest. (There are 80 of them.)
9	242.7	2955	2.0	4	1		Price =	Home price in thousands of dollars (dependent variable
10	244.5	2722	2.5	5	0		Size =	Home size, in square feet.
11	184.2	2590	2.5	1	0		Number of bathrooms = sort of self explanatory.
12	325.7	3138	3.5	7	1		Niceness Rating = Some third party assessment of the home.
13	266.1	2713	2.0	7	0		Pool? = a dummy variable = 1 if the home has a pool, 0 otherwise.
14	166.0	2284	2.5	2	0
15	330.7	3140	3.5	6	1			A. Write out the equation for the model you develop.
16	289.1	3205	2.5	3	1			B. Interpret the equation as a model and the meaning
17	268.8	2721	2.5	6	1				of the information for each variable in your
18	276.7	3245	2.5	2	1				"best" model.
19	222.4	2464	3.0	3	1			C. Interpret the confidence intervals for each of your
20	241.5	2993	2.5	1	0				statistically significant variables.
21	307.9	2647	3.5	6	1			D. Prepare a scatter plot for the residuals and
22	223.5	2670	2.5	4	0				comment on the information it
23	231.1	2895	2.5	3	0				suggests (or does not suggest).
24	216.5	2643	2.5	3	0
25	205.5	2915	2.0	1	0
26	258.3	2800	3.5	2	1
27	227.6	2557	2.5	3	1
28	255.4	2805	2.0	3	1
29	235.7	2878	2.5	4	0
30	285.1	2795	3.0	7	1
31	284.8	2748	2.5	7	1
32	193.7	2256	2.5	2	0
33	247.5	2659	2.5	2	1
34	274.8	3241	3.5	4	1
35	264.4	3166	3.0	3	1
36	204.1	2466	2.0	4	0
37	273.9	2945	2.5	5	1
38	238.5	2727	3.0	1	1
39	274.4	3141	4.0	4	1
40	259.6	2552	2.0	7	1
41	285.6	2761	3.0	6	1
42	216.1	2880	2.5	2	0
43	261.3	3426	3.0	1	1
44	236.4	2895	2.5	2	1
45	267.5	2726	3.0	7	0
46	220.2	2930	2.5	2	0
47	300.1	3013	2.5	6	1
48	260.0	2675	2.0	6	0
49	277.5	2874	3.5	6	1
50	274.9	2765	2.5	4	1
51	259.8	3020	3.5	2	1
52	235.0	2887	2.5	1	1
53	191.4	2032	2.0	3	0
54	228.5	2698	2.5	4	0
55	266.6	2847	3.0	2	1
56	233.0	2639	3.0	3	0
57	343.4	3431	4.0	5	1
58	334.0	3485	3.5	5	1
59	289.7	2991	2.5	6	1
60	228.4	2482	2.5	2	0
61	233.4	2712	2.5	1	1
62	275.7	3103	2.5	2	1
63	290.8	3124	2.5	3	1
64	230.8	2906	2.5	2	0
65	310.1	3398	4.0	4	1
66	247.9	3028	3.0	4	0
67	249.9	2761	2.0	5	0
68	220.5	2842	3.0	3	0
69	226.2	2666	2.5	6	0
70	313.7	2744	2.5	7	1
71	210.1	2508	2.5	4	0
72	244.9	2480	2.5	5	0
73	235.8	2986	2.5	4	0
74	263.2	2753	2.5	7	0
75	280.2	2522	2.5	6	1
76	290.8	2808	2.5	7	1
77	235.4	2616	2.5	3	0
78	190.3	2603	2.5	2	0
79	234.4	2804	2.5	4	0
80	238.7	2851	2.5	5	0

Answer 1

A. The regression model is

Price = b₀ +b₁ Size +b₂ No. of bathroom +b₃ Niceness rating +b₄ Pool +e

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.935127
R Square	0.874462
Adjusted R Square	0.867767
Standard Error	13.53205
Observations	80
ANOVA
	df	SS	MS	F	Significance F
Regression	4	95665.24	23916.31	130.6071	5.41E-33
Residual	75	13733.73	183.1164
Total	79	109399
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	24.97604	16.62666	1.502168	0.137253	-8.14597	58.09805
Size	0.052636	0.006594	7.981785	1.29E-11	0.039499	0.065773
No. of bathroom	10.04302	3.72871	2.693431	0.008721	2.615051	17.47099
Niceness rating	10.04203	0.791494	12.68744	2.38E-20	8.465295	11.61877
Pool	25.86232	3.574712	7.234799	3.36E-10	18.74113	32.98351

B. The estimated model is

Price = 24.976 + 0.0526 Size +10.04 No. of bathroom + 10.04 Niceness rating + 25.86 Pool

From the results, observed that all variable having a significant relationship in the sales price.

C. the confidence intervals for each variable is not correclty defined the interval.

D.