Use Excel's AnalysisToolPakto conducta regressionanalysis of Age and AssessmentValue Is Age a significantpredictorof AssessmentValue * DAT 565 Wk 5 - Apply: Regression Modeling Constructa multipleregressionmodel Use Excel's AnalysisToolPakto conducta regressionanalysis with AssessmentValueas the dependentvariable and FloorArea Offices, Entrances and Age as independentvariables What is the overall fit r^2? What is the adjustedr 2? Which predictorsare consideredsignificantif we work with a=0.057 Which predictorscan be eliminated What is the final model if we only use FloorAreaand Officesas predictors Supposeour final model is: AssessedValue= 115.9+ 0.26x FloorArea+ 78.34x Offices What wouldbethe assessedvalue of a medical office building with a floor area of 3500sq. ft., 2 offices that was built 15 years ago? Is this assessedvalue consistentwith what appearsin the database