A professor wants to conduct a study in a statistics class to measure the effect of solving problems at home on the performance on the final exam. She collected data at random for 20 students from a class on the number of hours spent in a week doing problem sets at home (X) and their score on the final exam (Y), as shown in the following table. Answer questions (a) through (d) based on this data. X = # of hrs/week Y = score on the final 100 72 90 63 59 90 98 89 86 73 85 66 86 64 96 73 94 85 85 70 24 10 20 6 5 21 23 18 19 12 16 6 19 5 22 12 20 15 18 10 a. The regression slope is and the vertical intercept is b. The predicted final score of a student who studies for 12 hours every week is c. The coefficients of determination is and coefficient of non-determination is

College Algebra
7th Edition
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:James Stewart, Lothar Redlin, Saleem Watson
Chapter1: Equations And Graphs
Section: Chapter Questions
Problem 10T: Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s...
icon
Related questions
Topic Video
Question
100%

Could someone help me with the following questions on excel.

Thank you

A professor wants to conduct a study in a statistics class to measure the effect of solving problems at home on the performance on the
final exam. She collected data at random for 20 students from a class on the number of hours spent in a week doing problem sets at
home (X) and their score on the final exam (Y), as shown in the following table. Answer questions (a) through (d) based on this data.
X = # of hrs/week
24 10 20 6 5 21 23 18 19 12 16 6 19 5 22 12 20 15 18 10
= score on the final 100 72 90 63 59 90 98 89 86 73 85 66 86 64 96 73 94 85 85 70
Y
a. The regression slope is
and the vertical intercept is
b. The predicted final score of a student who studies for 12 hours every week is
c. The coefficients of determination is
and coefficient of non-determination is
d. Perform an F-test for the significance of the regression at 0.05 level of significance. Answer if you found the model to be
"significant" or "not significant" based on this test.
Transcribed Image Text:A professor wants to conduct a study in a statistics class to measure the effect of solving problems at home on the performance on the final exam. She collected data at random for 20 students from a class on the number of hours spent in a week doing problem sets at home (X) and their score on the final exam (Y), as shown in the following table. Answer questions (a) through (d) based on this data. X = # of hrs/week 24 10 20 6 5 21 23 18 19 12 16 6 19 5 22 12 20 15 18 10 = score on the final 100 72 90 63 59 90 98 89 86 73 85 66 86 64 96 73 94 85 85 70 Y a. The regression slope is and the vertical intercept is b. The predicted final score of a student who studies for 12 hours every week is c. The coefficients of determination is and coefficient of non-determination is d. Perform an F-test for the significance of the regression at 0.05 level of significance. Answer if you found the model to be "significant" or "not significant" based on this test.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Propositional Calculus
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
College Algebra
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Algebra and Trigonometry (MindTap Course List)
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:
9781305071742
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill