The data set (Grades.xlsx) shows middle
term scores from an Introductory Statistics course.
a) Fit a model predicting the second middleterm score (middle
term2) from the first middleterm score (MiddleTerm1).
Predicted [ Select ]
["Middle Term2",
"MiddleTerm1"] = [
Select ] ["28.89564", "0.78350",
"12.35404", "0.70567"] +
[ Select ] ["28.89564", "12.35404",
"0.78350", "0.70567"] ×
[ Select ] ["MiddleTerm1",
"MiddleTerm2"]
b) Comment on the model you found, including a discussion of the
assumptions and conditions for regression. Is the coefficient for
the slope statistically significant?
1.Hypotheses:
H0: [
Select ] ["b1 = 0", "β1 ≠ 0",
"β1 = 0", "b1 ≠ 0"] (There
is [ Select ]
["a linear relationship", "no linear
relationship"] between mid term 1 and mid term 2
scores.)
HA: [
Select ] ["β1 = 0", "b1 = 0",
"b1 ≠ 0", "β1 ≠ 0"] (There
is [ Select ]
["a linear relationship", "no linear
relationship"] between mid term 1 and mid term 2
scores.)
t = [ Select ]
["8.7560", "1.6233", "4.5175"]
P-value = [ Select ]
["1.95125e-12", "0.1096",
"2.86764E-05"]
R2 = [ Select ]
["0.5529", "0.7436"]
Based on the sample and at 5% level of significance, there
is [ Select ]
["enough evidence", "no evidence"] to
conclude that [ Select
] ["there is no", "there is
a"] linear relationship between Middleterm 1 and
Middleterm 2 scores.
Middleterm 1 is a useful predictor of Middleterm
2.
c) Find a 95% CI for β1
95% CI=( [ Select ]
["0.8668", "0.5446", "0.9624",
"0.6046"] , [
Select ] ["0.6046", "0.8668", "0.9624",
"0.5446"] )
d) Find a 99% CI for β1
99% CI=( [ Select ]
["0.9198", "0.5457", "0.4915",
"0.6046"] , [
Select ] ["0.4915", "1.0213", "0.9198",
"0.6046"] )
18 Miguel בה רד 1 FirstNam: Midterm Midterm Homework 2 Thomas 83 60 51 3 Timothy 50 56 20 4 Timothy 82 76 61 5 Amandee 91 78 54 nem 6 Peter 91 78 66 7 Josef 62 43 56 8 Enrique 75 76 72 . - 9 Michael 96 98 83 ma 10 Justin 67 57 79 11 Shad 61 58 65 12 Wesley 54 58 66 M 13 Mark 72 61 79 14 Marshall 59 62 58 wa 15 Benjamin 76 62 72 16 Iris 63 62 67 17 Christina 75 62 72 54 63 74 19 John 76 64 72 20 lan 76 65 66 21 Michael 55 65 51 22 Sarah 78 65 77 23 Justin 81 66 66 US 24 Yvon 88 66 82 - 25 David 92 66 78 David 26 Mark 89 66 72 . - 27 Karen 96 68 72 Snac 28 Thomas 84 70 70 29 Christoph 95 75 77 30 Michael 93 78 72 31 Wayne 1 Wund 20 89 79 44 32 Brian 32 Brian 92 80 82 24 33 Patrick 93 81 71 34 Irena 93 81 82 35 Verena an 80 82 69 20 Mb or co 36 Nicholas 95 82 68 27 37 Julia 90 20 83 79 - 38 Jason 91 83 71 20 Catheri 20 39 Catherine 90 85 78 20 40 Samuel 94 85 76 41 Elizabeth 86 88 ON 84 42 83 86 78 12 Brian . 43 Brian 20 81 86 76 44 Adam nd 89 86 62 ca AE 2 45 Gregory 81 87 75 93 87 80 20 47 Israel 76 88 67 Me White 48 Whitney 87 89 85 Ag Nicole 49 Nicole 98 89 77 50 Flizah 50 Elizabeth 93 89 73 EM 51 Marc 81 89 62 52 Sara 99 90 77 53 David 52 David On 94 90 88 54 Brooke 92 90 86 55 Alexis 90 91 68 56 Jonathan 89 92 84 57 Annie 89 92 68 mis 58 Sonya 94 92 81 no 59 Jared 98 92 83 60 Joshua 95 93 87 61 Emily 91 95 83 62 Kathryn 95 95 87 63 Kristina 98 96 84 64 Valentin 97 96 80 65 Katharine 92 98 77 CC בה בה בה 12 Alexandra Ac Rebecca דה בד דה
18 Miguel בה רד 1 FirstNam: Midterm Midterm Homework 2 Thomas 83 60 51 3 Timothy 50 56 20 4 Timothy 82 76 61 5 Amandee 9
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
18 Miguel בה רד 1 FirstNam: Midterm Midterm Homework 2 Thomas 83 60 51 3 Timothy 50 56 20 4 Timothy 82 76 61 5 Amandee 9
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!