Estimate the model parameters using the method of least squares (from Excel output) and state the estimated model equation.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 31PPS
icon
Related questions
icon
Concept explainers
Question

Estimate the model parameters using the method of least squares (from Excel output) and state the estimated model equation.

Question 1
SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R
Square
Standard
0.999666
0.999333
0.999307
Error
Observations
39.51247
54
ANOVA
Significance
F
Df
S
MS
F
Regression
Residual
2 1.19E+08 59656970 38211.39
1.03E-81
51
79622.99
1561.235
Total
53
1.19E+08
Standard
Upper
95%
Lower
95.0%
Upper
95.0%
Coefficients
Error
t Stat
P-value
Lower 95%
15.44438
Intercept
Reall income
Real Wealth
-9.71491
12.53213
-0.7752 0.441801
-34.8742 15.44438
-34.8742
0.726461
0.01399
51.92536
7.96E-46
0.698374 0.754548
0.698374 0.754548
0.036411
0.002589
14.06532
3.48E-19
0.031214 0.041608 0.031214 0.041608
Transcribed Image Text:Question 1 SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard 0.999666 0.999333 0.999307 Error Observations 39.51247 54 ANOVA Significance F Df S MS F Regression Residual 2 1.19E+08 59656970 38211.39 1.03E-81 51 79622.99 1561.235 Total 53 1.19E+08 Standard Upper 95% Lower 95.0% Upper 95.0% Coefficients Error t Stat P-value Lower 95% 15.44438 Intercept Reall income Real Wealth -9.71491 12.53213 -0.7752 0.441801 -34.8742 15.44438 -34.8742 0.726461 0.01399 51.92536 7.96E-46 0.698374 0.754548 0.698374 0.754548 0.036411 0.002589 14.06532 3.48E-19 0.031214 0.041608 0.031214 0.041608
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill