AssessedValue: tax assessment value (thousands of dollars) 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 FloorArea as the independent variable and AssessmentValue 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?
Purpose This assignment provides an opportunity to develop, evaluate, and apply bivariate and multivariate linear regression models. Resources: Microsoft Excel®, DAT565_v3_Wk5_Data_File Instructions: The Excel…