The estimated regression equation relating university GPA to the student's SAT mathematics score and high-school GPA is developed. A portion of Excel output shows the following. ANOVA df Significance F S MS F Regression 1.7621 ? 0.0001 Residual ? ? Total 9 1.88 Coefficient Standard Error t Stat Intercept H_GPA SAT_math -1.4053 0.4848 0.0235 0.0087 ? 0.0049 0.0011 ? where H_GPA = high-school grade point average, SAT_math = SAT mathematics score. (a) (4 points) Complete the eight missing entries (indicated by ?) in the above table. (b) (3 points) At 5% significance level, is the model significant? (c) (3 points) At 5% significance level, is each independent variable significant? (d) (2 points) Did the estimated regression equation provide a good fit to the data? Explain in one or two sentences.

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
The estimated regression equation relating university GPA to the
student's SAT mathematics score and high-school GPA is developed. A
portion of Excel output shows the following.
ANOVA
df
MS
Significance F
Regression
1.7621
?
?
0.0001
Residual
?
Total
1.88
Coefficient
Standard Error
t Stat
Intercept
H_GPA
SAT_math
-1.4053
0.4848
0.0235
0.0087
0.0049
0.0011
where H_GPA = high-school grade point average, SAT_math = SAT
%3D
mathematics score.
(a) (4 points) Complete the eight missing entries (indicated by ?) in
the above table.
(b) (3 points) At 5% significance level, is the model significant?
(c) (3 points) At 5% significance level, is each independent variable
significant?
(d) (2 points) Did the estimated regression equation provide a good
fit to the data? Explain in one or two sentences.
Transcribed Image Text:The estimated regression equation relating university GPA to the student's SAT mathematics score and high-school GPA is developed. A portion of Excel output shows the following. ANOVA df MS Significance F Regression 1.7621 ? ? 0.0001 Residual ? Total 1.88 Coefficient Standard Error t Stat Intercept H_GPA SAT_math -1.4053 0.4848 0.0235 0.0087 0.0049 0.0011 where H_GPA = high-school grade point average, SAT_math = SAT %3D mathematics score. (a) (4 points) Complete the eight missing entries (indicated by ?) in the above table. (b) (3 points) At 5% significance level, is the model significant? (c) (3 points) At 5% significance level, is each independent variable significant? (d) (2 points) Did the estimated regression equation provide a good fit to the data? Explain in one or two sentences.
Expert Solution
steps

Step by step

Solved in 6 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