Question: Explore the relationship between the selling prices (Y) and the appraised values (X) of the 148 homes in the file P02_11.xlsx by estimating a simple
Explore the relationship between the selling prices (Y) and the appraised values (X) of the 148 homes in the file P02_11.xlsx by estimating a simple linear regression model. Interpret the standard error of estimate se and R2 and the least squares line for these data.
a. Is there evidence of a linear relationship between the selling price and appraised value? If so, characterize the relationship. Is it positive or negative? Is it weak or strong?
b. For which of the three remaining variables, the size of the home, the number of bedrooms, and the number of bathrooms, is the relationship with the home’s selling price stronger? Justify your choice with additional simple linear regression models.
Step by Step Solution
3.37 Rating (163 Votes )
There are 3 Steps involved in it
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
415-M-S-L-R (1317).xlsx
300 KBs Excel File
