Construct a multiple regression model.

• Use Excel's Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea, Offices, Entrances, and Age as independent variables. What is the overall fit r^2? What is the adjusted r^2?
• 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 FloorArea and Offices as predictors?
• Suppose our final model is:
• AssessedValue = 115.9 + 0.26 x FloorArea + 78.34 x Offices
• What wouldbe 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?

AutoSave OFF MA F C... DAT565_v3_Wk5_Data_File Page Layout Formulas Data Review View Tell me Share Comments Home Insert Draw Calibri (Body) v 11 AA = ab Wrap Text General 4 $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Ideas Paste BIUV DVAv E Merge & Center v Formatting as Table Styles Filter Select H14 X V fx M N 0 P Q R S T U V W A B D G H 1 K L FloorArea (Sq.Ft.) Offices Entrances Age AssessedValue ($'000) 4790 2 8 1796 4720 2 12 1544 Un AWNI 594 2 2 2094 5720 2 34 1968 3660 2 38 1567 5000 2 31 1878 10 00 2990 19 949 2610 910 5650 2 1774 3570 1187 2930 1113 1280 UN - N - 671 488 1678 1620 710 1820 678 4530 1585 2570 842 4690 1539 W N W N W N A - N - N N W - N N N N - W N W N A N N A W A 1280 433 4100 1268 3530 1251 3660 1094 111 638 IN N - N W - N N N N - - N - 2670 999 1100 653 58 10 1914 2560 772 234 890 3690 1282 3580 1264 3610 1162 3960 1447 35 36 37 38 39 40 41 42 43 44 Regression Modeling Data + + 100%