The admissions officer for Clearwater College developed the following estimated regression equation relating the final college GPA to the student's SAT mathematics score and high-school GPA. ŷ = -1.41 + 0.0235x1 + 0.00486x2 where T1 = high-school grade point average 22 = SAT mathemathics score y = final college grade point average Round test statistic values to 2 decimal places and all other values to 4 decimal places. Do not round your intermediate calculations. a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. SUMMARY OUTPUT Regression Statistics Multiple R R Square .9681 .9373 Adjusted R Square ,9194 Standard Error .1296 Observations 10 ANOVA df MS F Significance F Regression Residual Total 2 1.76209 .8810 52.31 .0001 .1179 .0168 9 1.88 Coefficients Standard Error t Stat P-value Intercept -1.4053 0.4848 -2.90 X1 0.023467 0.0086666 2.71 K2 0.00486 0.001077 4.51 b. Using a = 0.05, test for overall significance. - Select your answer -

Functions and Change: A Modeling Approach to College Algebra (MindTap Course List)
6th Edition
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Bruce Crauder, Benny Evans, Alan Noell
Chapter3: Straight Lines And Linear Functions
Section3.4: Linear Regression
Problem 12SBE: Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4
icon
Related questions
icon
Concept explainers
Topic Video
Question
100%

How do I find the p-value to each corresponding test statistic to complete the ANOVA table? I also need help with parts b-d. 

The admissions officer for Clearwater College developed the following estimated regression equation relating the final college GPA to the student's SAT mathematics score and high-school
GPA.
ŷ = -1.41 + 0.0235x1 + 0.00486x2
%3D
where
X1 = high-school grade point average
X2 = SAT mathemathics score
y = final college grade point average
Round test statistic values to 2 decimal places and all other values to 4 decimal places. Do not round your intermediate calculations.
a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers.
SUMMARY OUTPUT
Regression Statistics
Multiple R
.9681
R Square
.9373
Adjusted R Square
.9194
Standard Error
.1296
Observations
10
ANOVA
df
SS
MS
F
Significance F
Regression
2
1.76209
.8810
52.31
.0001
Residual
7
.1179
.0168
Total
9.
1.88
Coefficients
Standard Error
t Stat
P-value
Intercept
-1.4053
0.4848
-2.90
X1
0.023467
0.0086666
2.71
X2
0.00486
0.001077
4.51
b. Using a =
0.05, test for overall significance.
- Select your answer -
Transcribed Image Text:The admissions officer for Clearwater College developed the following estimated regression equation relating the final college GPA to the student's SAT mathematics score and high-school GPA. ŷ = -1.41 + 0.0235x1 + 0.00486x2 %3D where X1 = high-school grade point average X2 = SAT mathemathics score y = final college grade point average Round test statistic values to 2 decimal places and all other values to 4 decimal places. Do not round your intermediate calculations. a. Complete the missing entries in this Excel Regression tool output. Enter negative values as negative numbers. SUMMARY OUTPUT Regression Statistics Multiple R .9681 R Square .9373 Adjusted R Square .9194 Standard Error .1296 Observations 10 ANOVA df SS MS F Significance F Regression 2 1.76209 .8810 52.31 .0001 Residual 7 .1179 .0168 Total 9. 1.88 Coefficients Standard Error t Stat P-value Intercept -1.4053 0.4848 -2.90 X1 0.023467 0.0086666 2.71 X2 0.00486 0.001077 4.51 b. Using a = 0.05, test for overall significance. - Select your answer -
c. Did the estimated regression equation provide a good fit to the data? Explain.
because the Ra value is
- Select your answer - ♥
- Select your answer - v than 0.50,
d. Use the t test and a =
0.05 to test Họ : B1
0 and Ho : B2 = 0. Use t table.
For B1, the p-value is
- Select your answer -
- Select your answer -
Но : В — 0.
so
For B2, the p-value is
Select your answer
- Select your answer - V Họ : B2 = 0.
so
Transcribed Image Text:c. Did the estimated regression equation provide a good fit to the data? Explain. because the Ra value is - Select your answer - ♥ - Select your answer - v than 0.50, d. Use the t test and a = 0.05 to test Họ : B1 0 and Ho : B2 = 0. Use t table. For B1, the p-value is - Select your answer - - Select your answer - Но : В — 0. so For B2, the p-value is Select your answer - Select your answer - V Họ : B2 = 0. so
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Sample space, Events, and Basic Rules of Probability
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
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
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill