Data was collected on 100 houses recently sold in a city. It consisted of the sales price (in $), house size (in square feet), the number of…

Data was collected on 100 houses recently sold in a city. It consisted of the sales price (in $), house size (in square feet), the number of bedrooms, and the annual real estate tax (in $).
(The Excel file is attached)
1) Please investigate how the variables are related to one another. You can do this graphically by constructing scatter plots of all pair-wise combinations
2) Please fit a linear model to predict the impact of the most important variables on sales price. 
3) Please then check the if the selected variables have a significant impact of sales price or not (5% significance level)
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now