Using the attached Excel spreadsheet, run a linear regression to test for an effect of Market Value on Housing Sales Prices. What is the R-squared and what does this mean?
Is the model significant?
Are the Normality and Linearity assumptions assumed?
How can you tell for each of these?
What could be another set of independent variables, if any, that could be added to better predict this relationship?
Attachment:- Market_value_2010.xlsx