House Selling Price) he data below show the selling price square footage, bedroo
ID: 3258056 • Letter: H
Question
House Selling Price) he data below show the selling price square footage, bedrooms, and age of houses that have sold in a neighborhood in he last six months. 64,000 1,670 59,000 1,339 61,500 1,712 1,840 79,000 87,500 2,300 2,234 92,500 95,000 2,311 113,000 2,377 115,000 2,736 138,000 2,500 142,500 2,500 2,479 44,000 2,400 145,000 147,500 3,124 2,500 44,000 155,500 4,062 165,000 2,854 Develop seven regression models as below using the corresponding Excel data (Mode 1) Y selling price, X1 square footage (House Selling Price Model 1 Data) (Mode 2)Y selling price, X2 bedrooms (House Selling Price Model 2 Data) (Mode13 Y selling price, X3 E age (House Selling Price Model 3 Data) Model 4) Y selling price, X1 square footage, X2-bedrooms (House Selling Price Model 4 Data (Model 5) Y selling price, X square footage, X3 age (House Selling Price Model 5 Data) Model 6) Y -selling price, X2 bedrooms X3 age (House Selling Price Model 6 Data (Model70 Y selling price, X1 square footage, X2 bedrooms, X3 age (House Selling Price Model 7 Data House Selling Price) Models 1, 2, and 3 are simple regression models with one independent variable (a) The adjusted value of model 1 is Answer format: two decimal places (b) The adjusted r value of model 2 is Answer format: two decimal places (c) The adjusted 2 value of model 3 is nswer format: two decimal places) Write your answer(s) as 1.23. 4.56, 7.89 25 19 10Explanation / Answer
a) 0.761874379341138
b) 0.339711692450505
c) 0.171986764494317
Page 2
a)0.771575538045342
b) 0.751235879326695
c) 0.292598371663614
d)0.75463873717856
Results are obtained from excel file , using Data Analysis and then regression.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.