E H L M 1 Hours spent watching TV,x Test scores, y The number of hours 12 students watch television during the weekend and 96 the scores of each student who took test the following monday is given. QUESTION B) 3 85 4 2 82 METHOD 1 (USE TABLE IN your formula booklet) 74 r critical a) Construct the scatter plot. b) At a = 0.01, can you conclude that there is a significant linear correlation between the number of hours students spent watching TV during the 6 95 abs r 7 5 68 METHOD 2 (USE THE P-VALUE APPROAH) 8 5 76 Test statistic weekend and their scores. 9 5 84 c) Find the equation of the regression line to predict the scores for each of the given number of hours students watch television during the weekend and interpret the coefficient. d) Estimate the scores when x=4 hours, x=8 hours e) Compute the coefficient of determination and interpret. 10 6 58 11 7 65 12 75 P-value 13 10 50 14 15 16 Method 3) Use the critical value approach critical value 17 10

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

Please show all steps USING EXCEL ONLY FORMULAS

A
В
D
E
F
G
H
K
L
M
N
1 Hours spent watching TV,x
Test scores, y
The number of hours 12 students watch television during the weekend and
96
the scores of each student who took a test the following monday is given.
QUESTION B)
3
1
85
4
METHOD 1 (USE TABLE IN your formula booklet)
r critical
2
82
74
6
95
a) Construct the scatter plot.
abs r
b) At a = 0.01, can you conclude that there is a significant linear correlation
between the number of hours students spent watching TV during the
7
5
68
METHOD 2 (USE THE P-VALUE APPROAH)
8
5
76
Test statistic
weekend and their scores.
9
5
84
c) Find the equation of the regression line to predict the scores for each of
10
6
58
the given number of hours students watch television during the weekend
11
7
65
and interpret the coefficient.
12
75
P-value
d) Estimate the scores when x=4 hours, x=8 hours
e) Compute the coefficient of determination and interpret.
13
10
50
14
15
16
Method 3) Use the critical value approach
17
critical value
18
19
decision
20
21
conclusion
Transcribed Image Text:A В D E F G H K L M N 1 Hours spent watching TV,x Test scores, y The number of hours 12 students watch television during the weekend and 96 the scores of each student who took a test the following monday is given. QUESTION B) 3 1 85 4 METHOD 1 (USE TABLE IN your formula booklet) r critical 2 82 74 6 95 a) Construct the scatter plot. abs r b) At a = 0.01, can you conclude that there is a significant linear correlation between the number of hours students spent watching TV during the 7 5 68 METHOD 2 (USE THE P-VALUE APPROAH) 8 5 76 Test statistic weekend and their scores. 9 5 84 c) Find the equation of the regression line to predict the scores for each of 10 6 58 the given number of hours students watch television during the weekend 11 7 65 and interpret the coefficient. 12 75 P-value d) Estimate the scores when x=4 hours, x=8 hours e) Compute the coefficient of determination and interpret. 13 10 50 14 15 16 Method 3) Use the critical value approach 17 critical value 18 19 decision 20 21 conclusion
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Exponents
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
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