Case 4 – House Price. A small data set contains information on House Price (Y) in dollars, as well as predictors: number of Cars
the garage can hold (X1), the Age of the house in years (X2), and the number of Rooms in the house (X3). Consider the regression output below and determine the missing values A through F. Dependent variable is: Price R squared = AAAA R squared (adjusted) = 57.3% s = BBBB with 22 - 4 = 18 degrees of freedom Source Sum of Squares df Mean Square F-ratio Regression 6892069096 DDDD 2297356365 CCCC Residual 3975520758 18 220862264 Variable Coefficient s.e. of Coeff t-ratio prob Constant -26737.5 21074 -1.27 0.2207 Cars 6185.10 6640 0.932 0.3639 Age -333.303 757.8 EEEE FFFF Rooms 11154.6 2524 4.42 0.0003 KEY:
(A) = 63.4%
(B) = 14861
(C) = 10.4
(D) = 3
(E) = –0.44
(F) = 0.66
The answer and procedures of the exercise are attached in the following archives.
Step-by-step explanation:
You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.