Question: 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
Based on the given options the correct regression equation is ... View full answer
Get step-by-step solutions from verified subject matter experts
