DAT 565 Linear Relationship – Multiple Regression – Assignment Solution
 Download the dataset. The data set is information about the tax assessment value assigned to medical office buildings in a city. The following is a list of the variables in the database:
- Floor Area: square feet of floor space
- Offices: number of offices in the building
- Entrances: number of customer entrances
- Age: age of the building (years)
- Assessed Value: tax assessment value (thousands of      dollars)
- Do you observe a linear relationship between the 2 Â Â Â Â Â variables?
- Do you observe a linear relationship between the 2 Â Â Â Â Â variables?
- Do you observe a linear relationship between the 2 Â Â Â Â Â variables?
- Do you observe a linear relationship between the 2 Â Â Â Â Â variables?
- Is Floor Area a significant predictor of Assessment      Value?
- Do you observe a linear relationship between the 2 Â Â Â Â Â variables?
- Is Age a significant predictor of Assessment Value?
- Use Excels Analysis ToolPak to conduct a regression      analysis with Assessment Value as the dependent variable and Floor Area,      Offices, Entrances, and Age as independent variables.
- What is the overall fit R2? What is the adjusted R2?
- Which predictors are considered significant if we work      with α=0.05? Which predictors can be eliminated?
- What is the final model if we only use Floor Area and      Offices as predictors?
- Suppose our final model is: Assessed Value = 115.9 + Â Â Â Â Â 0.26 x Floor Area + 78.34 x Offices.
- What would be the assessed value of a medical office      building with a floor area of 3500 sq. ft., 2 offices, that was built 15      years ago?
- Is this assessed value consistent with what appears in      the database?