Instructions.Use the data to construct a model that predicts the assessed value assigned to medical office buildings with specific characteristics.Write your responses on the Excel file to show your calculations. No Word document.

E. Multiple Regression Analysis 1. Use Excel's Data Analysis Regression 2. Use columns Assessed Value (Y) and Floor Area, Offices, Entrances, Age (X) 3. Regression: Input Y Range Assessed Value; Input X Range Floor Area, Offices, Entrances, Age What is the R2? What is the Adjusted R2? Explain the purpose for having an adjusted R2? (LO 13-2).

F. Predictors with = 0.05 Which predictors do you consider significant? Which predictors would you be comfortable eliminating?

G. Multiple Regression Analysis 1. Use Excel's Data Analysis Regression 2. Use columns Assessed Value (Y) and Floor Area, Offices (X) 3. Regression: Input Y Range Assessed Value; Input X Range Floor Area, Offices What is the model if we use Floor Area and Offices as predictors?

H. Predict Assessed Value ($'000) Suppose the final model is: Assessed Value ($'000) = 169.3 + 0.30 * Floor Area What would be the assessed value of a medical office building with a floor area of 3500 sqft, two offices, and built 15 years ago? Is this assessed value consistent with actual values in the database?

\f