Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Construct a multiple regression model. Use Excel's Analysis ToolPak to conduct a regression analysis with AssessmentValue as the dependent variable and FloorArea , Offices ,

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?

image text in transcribedimage text in transcribedimage text in transcribed
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%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Concepts With Applications

Authors: Charles P McKeague

1st Edition

1630983136, 9781630983130

More Books

Students also viewed these Mathematics questions

Question

What has been the evolution of human resource management?

Answered: 1 week ago