Question: 3. Answer to the following questions using the data set (home.xls). You can download this data setfrom Sogang cyber campus(Note: Y: price, X: SqFt, LotSize,

3. Answer to the following questions using the data set (home.xls). You can download this data setfrom 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) Calculate2 Rand adjusted2 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 AICcriteria. 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

Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
