Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Number Theory

Authors: Gove Effinger, Gary L Mullen

1st Edition

1000427129, 9781000427127

More Books

Students also viewed these Mathematics questions

Question

Explain the process of Human Resource Planning.

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago