3. Answer to the following questions using the data set (home.xls). You can download this data set from Sogang cyber campus (Note: Y: price, X: SqFt, LotSize, Baths) (1) Report mean, median, and standard deviation of Y and Xs. (2) Obtain parameter estimates and ANOVA output tables. (3) Calculate 2 R and adjusted 2 R . (4) Obtain Correlation matrix among three X variables (5) Check multicollinearity using VIF (6) We want to make a variable selection using forward variable selection method based on AIC criteria. Report the AIC value for the finally selected model. (7) Make a prediction on the price if an apartment satisfies the following conditions: SqFt=2955, LotSize=20.2, Baths=2

Obs	Price	SqFt	LotSize	Baths
1	505.5	2192	16.4	2.5
2	784.1	3429	24.7	3.5
3	649	2842	17.7	3.5
4	689.8	2987	20.3	3.5
5	709.8	3029	22.2	3
6	590.2	2616	20.8	2.5
7	643.3	2978	17.3	3
8	789.7	3595	22.4	3.5
9	683	2838	27.4	3
10	544.3	2591	19.2	2
11	822.8	3633	26.9	4
12	637.7	2822	23.1	3
13	618.7	2994	20.4	3
14	619.3	2696	22.7	3.5
15	490.5	2134	13.4	2.5
16	675.1	3076	19.8	3
17	710.4	3259	20.8	3.5
18	674.7	3162	19.4	4
19	663.6	2885	23.2	3
20	606.6	2550	20.2	3
21	758.9	3380	19.6	4.5
22	723.7	3131	22.5	3.5
23	621.8	2754	19.2	2.5
24	622.4	2710	21.6	3
25	631.3	2616	20.8	2.5
26	574	2608	17.3	3.5
27	863.8	3572	29	4
28	652.7	2924	21.8	2.5
29	844.2	3614	25.5	3.5
30	629.9	2600	24.1	3.5