4. A real estate company is looking for house criteria that are often considered by families to buy a house. There are some house criteria which are frequently mentioned by the families before they buy a house: selling price, room size, no of bedroom, no of bathroom and garage size. After processing the data by using a regression, they found the following output: SUMMARY OUTPUT Regression Statistics Multiple R 0.987932065 R Square 0.976009764 Adjusted R Squ: 0.944022783 Standard Error 25.5011827 Observations ANOVA gnificance F 30.51271898 0.009156 df SS MS Regression 79370.94404 19842.73601 Residual 3 1950.930957 650.3103189 Total 81321.875 Coefficients Standard Error t Stat Pvalue Lower 95NU Intercept -50.57050093 35.80952196 -1.412208211 0.252746791 -164.532 x1(Room size) X2(# of bedroor X3 (H of bathroc -19.99072356 X4 (Garage size) 4.160482375 1.778955738 0.493559165 3.604341411 0.036649668 0.20823 49.50437318 22.31596872 2.218338527 0.113218219 -21.515 18.37997667 -1.08763596 0.35632827 -78.484 23.39990723 0.177799097 0.870208514 -78.6294 Questions: A. What is the interpretation of determination coefficient (R) and adjusted coefficient determination (R')? B. - By looking at p-value of each independent variables, which independent variable(s) is'are significant (Xi)?. What independent variables should be eliminated to get a better model? - What changes do you expect to happen to determination coefficient after the elimination? Explain the answer. C. By looking at the significant level of F test, are you still able to use the overall equation? Why? Please explain.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.3: Measures Of Spread
Problem 1GP
icon
Related questions
icon
Concept explainers
Question
Please answer... I'm needed only 1 hours time to dd .... Thank u
4. A real estate company is looking for house criteria that are often considered by families
to buy a house. There are some house criteria which are frequently mentioned by the
families before they buy a house: selling price, room size, no of bedroom, no of bathroom
and garage size. After processing the data by using a regression, they found the following
output:
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Squa 0.944022783
0.987932065
0.976009764
Standard Error
25.5011827
Observations
ANOVA
df
SS
MS
gnificance F
Regression
79370.94404
19842.73601
30.51271898 0.009156
Residual
3
1950.930957
650.3103189
Total
81321.875
Standard Error
t Stat
Coefficients
-50.57050093
P.value
Lower 95NU
35.80952196
-1.412208211
0.252746791 -164.532
Intercept
x1(Room size)
X2( of bedroor 49.50437318
X3 (H of bathroc -19.99072356
X4 (Garage size) 4.160482375
1.778955738
0.493559165
3.604341411
0.036649668
0.20823
22.31596872
2.218338527
0.113218219
-21.515
-1.08763596
-0.177799097
18.37997667
0.35632827
-78.484
23.39990723
0.870208514 -78.6294
Questions:
A. What is the interpretation of determination coefficient (R) and adjusted coefficient
determination (R')?
B. - By looking at p-value of each independent variables, which independent variable(s)
is/are significant (Xi)?. What independent variables should be eliminated to get a
better model?
- What changes do you expect to happen to determination coefficient after the
elimination? Explain the answer.
C. By looking at the significant level of F test, are you still able to use the overall equation?
Why? Please explain.
Transcribed Image Text:4. A real estate company is looking for house criteria that are often considered by families to buy a house. There are some house criteria which are frequently mentioned by the families before they buy a house: selling price, room size, no of bedroom, no of bathroom and garage size. After processing the data by using a regression, they found the following output: SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Squa 0.944022783 0.987932065 0.976009764 Standard Error 25.5011827 Observations ANOVA df SS MS gnificance F Regression 79370.94404 19842.73601 30.51271898 0.009156 Residual 3 1950.930957 650.3103189 Total 81321.875 Standard Error t Stat Coefficients -50.57050093 P.value Lower 95NU 35.80952196 -1.412208211 0.252746791 -164.532 Intercept x1(Room size) X2( of bedroor 49.50437318 X3 (H of bathroc -19.99072356 X4 (Garage size) 4.160482375 1.778955738 0.493559165 3.604341411 0.036649668 0.20823 22.31596872 2.218338527 0.113218219 -21.515 -1.08763596 -0.177799097 18.37997667 0.35632827 -78.484 23.39990723 0.870208514 -78.6294 Questions: A. What is the interpretation of determination coefficient (R) and adjusted coefficient determination (R')? B. - By looking at p-value of each independent variables, which independent variable(s) is/are significant (Xi)?. What independent variables should be eliminated to get a better model? - What changes do you expect to happen to determination coefficient after the elimination? Explain the answer. C. By looking at the significant level of F test, are you still able to use the overall equation? Why? Please explain.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Points, Lines and Planes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning