Compute in Excel. Use the given dataset. *note: Gender takes on a value of 1 if the student is male, and 0 otherwise Estimate a linear regression model relating overall grade weighted average (OGWA) of student to their gender, available internet speed (mbps) and previous term’s grade weighted average (lgwa) a. Interpret the slope coefficients (discuss their values and statistical significance) b. Are the coefficients jointly statistically significant? Explain your answer. c. How much of the variability of the overall grade weighted average is explained by the variability of the model?
Compute in Excel. Use the given dataset. *note: Gender takes on a value of 1 if the student is male, and 0 otherwise Estimate a linear regression model relating overall grade weighted average (OGWA) of student to their gender, available internet speed (mbps) and previous term’s grade weighted average (lgwa) a. Interpret the slope coefficients (discuss their values and statistical significance) b. Are the coefficients jointly statistically significant? Explain your answer. c. How much of the variability of the overall grade weighted average is explained by the variability of the model?
College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter8: Sequences, Series, And Probability
Section8.CR: Chapter Review
Problem 37E: Find the positive geometric mean between 4 and 64.
Related questions
Question
Compute in Excel. Use the given dataset.
*note: Gender takes on a value of 1 if the student is male, and 0 otherwise
Estimate a linear regression model relating overall grade weighted average (OGWA) of student to their gender, available internet speed (mbps) and previous term’s grade weighted average (lgwa)
a. Interpret the slope coefficients (discuss their values and statistical significance)
b. Are the coefficients jointly statistically significant? Explain your answer.
c. How much of the variability of the overall grade weighted average is explained by the variability of the model?
![Obs
gender
mbps
Igwa
OGWA
1
1
10
3.4
2.6
2
1
20
3.575
3.148
3
1
100
3.46
3.36
4
21.36
3.25
2.748
5
16.52
3.25
2.966
6
94
3.083
2.449
7
39.17
3.3647
3.382
8
1
133.55
2.75
2.76
9
1
191
2.8
2.909
10
27.21
3.833
3.214
11
1
117.72
2.3
2.115
12
49.74
3.93
3.68
13
19.18
3.464
3.4
14
38.57
3.75
3.098
15
1
35.42
3.55
3.34
16
63.95
3.6
3.8
17
27.26
3.5
3.7
18
1
99.4
3.375
3.375
19
39.98
3.55
3.682
20
1
5
3.6
3.284](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fefceb151-f166-42ba-95d8-5692109f5a7e%2Fd63442c0-4afb-4246-be75-b6c679ff41eb%2F3soj7pi_processed.png&w=3840&q=75)
Transcribed Image Text:Obs
gender
mbps
Igwa
OGWA
1
1
10
3.4
2.6
2
1
20
3.575
3.148
3
1
100
3.46
3.36
4
21.36
3.25
2.748
5
16.52
3.25
2.966
6
94
3.083
2.449
7
39.17
3.3647
3.382
8
1
133.55
2.75
2.76
9
1
191
2.8
2.909
10
27.21
3.833
3.214
11
1
117.72
2.3
2.115
12
49.74
3.93
3.68
13
19.18
3.464
3.4
14
38.57
3.75
3.098
15
1
35.42
3.55
3.34
16
63.95
3.6
3.8
17
27.26
3.5
3.7
18
1
99.4
3.375
3.375
19
39.98
3.55
3.682
20
1
5
3.6
3.284
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
![College Algebra (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305652231/9781305652231_smallCoverImage.gif)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning