output of a least square multiple linear regression for the scores in a test (variable Y) with Hours (X1, the number of hours spent reviewing) and Prep Exam (X2, the number of exams to take) as independent variables. SUMMARY OUTPUT Regression Statistics Multiple R RSquare Adjusted R Square Standard Error Observations 0.857 0.734 0.703 5.366 20 ANOVA of MS 1350.76 675.38 Significance F 23.46 Regression 2. 0.00 Residual 17 489.44 28.79 Total 19 1840.20 Coefficients Standord Error t Stat Pvalue 67.67 Lower 95% Upper 95% 61.73 Intercept hours 282 24.03 0.00 73.61 5.56 0.90 6.18 0.00 3.66 7.45 prep exams -0.60 0.91 0.66 0.52 -253 133 a. What is the value of r? What is the practical meaning of this value? b. What is the coefficient of Hours? Interpret this value. c. What is the coefficient of Prep Exam? Interpret this value.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
3. The following figure shows the Excel output of a least square multiple linear
regression for the scores in a test (variable Y) with Hours (X1, the number of
hours spent reviewing) and Prep Exam (X2, the number of exams to take) as
independent variables.
SUMMARY OUTPUT
Regression Statisties
Multiple R
R Square
Adjusted R Square
0.857
0.734
0.703
Standard Error
5.366
Observations
20
ANOVA
df
Significance F
23.46
MS
Regression
1350.76 675.38
0.00
Residual
17
489.44 28.79
Total
19
1840.20
Coefficients Standord Error tStat Pvalue
67.67
Lower 95N
Upper 95N
Intercept
2.82 24.03
0.00
61.73
73.61
hours
5.56
0.90
6,18
0.00
3.66
7.45
prep exams
-0.60
0.91
0.66
052
-2.53
133
a. What is the value of r? What is the practical meaning of this value?
b. What is the coefficient of Hours? Interpret this value.
c. What is the coefficient of Prep Exam? Interpret this value.
Transcribed Image Text:3. The following figure shows the Excel output of a least square multiple linear regression for the scores in a test (variable Y) with Hours (X1, the number of hours spent reviewing) and Prep Exam (X2, the number of exams to take) as independent variables. SUMMARY OUTPUT Regression Statisties Multiple R R Square Adjusted R Square 0.857 0.734 0.703 Standard Error 5.366 Observations 20 ANOVA df Significance F 23.46 MS Regression 1350.76 675.38 0.00 Residual 17 489.44 28.79 Total 19 1840.20 Coefficients Standord Error tStat Pvalue 67.67 Lower 95N Upper 95N Intercept 2.82 24.03 0.00 61.73 73.61 hours 5.56 0.90 6,18 0.00 3.66 7.45 prep exams -0.60 0.91 0.66 052 -2.53 133 a. What is the value of r? What is the practical meaning of this value? b. What is the coefficient of Hours? Interpret this value. c. What is the coefficient of Prep Exam? Interpret this value.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman