Question
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:
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started