Is Floor Area a significant predictor of Assessment Value?Do you observe a linear relationship between the 2 variables?

Regression Modeling

This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models.

The Excel file for this assignment contains a database with 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:

Use the data to construct a model that predicts the tax assessment value assigned to medical office buildings with specific characteristics.

Construct a scatter plot in Excel with Floor Area as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
Use Excel’s Analysis Tool Pak to conduct a regression analysis of Floor Area and Assessment Value. Is Floor Area a significant predictor of Assessment Value?
Construct a scatter plot in Excel with Age as the independent variable and Assessment Value as the dependent variable. Insert the bivariate linear regression equation and r^2 in your graph. Do you observe a linear relationship between the 2 variables?
Use Excel’s Analysis Tool Pak to conduct a regression analysis of Age and Assessment Value. Is Age a significant predictor of Assessment Value?