Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following table presents four variables that may be used to estimate Value of an Office Building. Floor space in square feet Number of
The following table presents four variables that may be used to estimate Value of an Office Building. Floor space in square feet Number of offices Number of entrances Age of the office bu 215 2 2 20 2 12 1.5 33 2 43 3 53 2 23 1.5 99 2 3 4 3 217 219 221 223 225 227 230 232 234 236 2 3 3 2 4 2 2 3 4 2 Based on the output of Excel's Regression Add-in, obtain the regression equation, and select the correct one. y^ = 276.55*Space +12642.75*Offices + 2679.91 Entrances - 229.97*Age y^=56181.69 +276.55*Space +12642.75*Offices +2679.91 Entrances - 229.97*Age 34 23 55 22 y = 56181.69 +276.55*Space + 12642.75*Offices +2679.91*Entrances + 229.97*Age y^ = 56181.69 +276.55 +12642.75 +2679.91-229.97 Question 9 (1 point) Listen y be used to estimate Value of an er of entrances Age of the office building in years Assessed value of the office building 2 142,000 2 144,000 1.5 151,000 2 150,000 3 139,000 2 169,000 1.5 126,000 2 142,000 3 163,000 4 169,000 149,000 20 12 33 43 53 23 99 34 23 55 22 3 obtain the regression equation, Oy^ = 276.55*Space +12642.75*Offices + 2679.91* Entrances - 229.97*Age y^ = 56181.69 + 276.55*Space +12642.75*Offices +2679.91* Entrances - 229.97*Age y^ = 56181.69 + 276.55*Space +12642.75*Offices +2679.91*Entrances + 229.97*Age y^ = 56181.69 +276.55 +12642.75 +2679.91 - 229.97
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Based on the given options the correct regression equation is ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started