s participation. I am interested in the difference between a learners academic achievement and whether he/she takes part in sports or not. I received data from the school which I put into a table. It is the academic term average for those who do sports and those who do not. We are now required to carry out a t-test (which I have done) and possibly do a correlation analysis (if viable) along with graphs etc. The t-test I conducted with the data, rejected the null hypothesis, in otherwords there is a significant difference between the two groups. I tried to

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section: Chapter Questions
Problem 19SGR
icon
Related questions
Question
100%

Hi there,

I hope you’re well. We have a research report/proposal due for Statistics next month. We were told to gather data on anything related to schools, learners or teachers. I have chosen to gather data on academic achievement and sports participation. I am interested in the difference between a learners academic achievement and whether he/she takes part in sports or not.

I received data from the school which I put into a table. It is the academic term average for those who do sports and those who do not. We are now required to carry out a t-test (which I have done) and possibly do a correlation analysis (if viable) along with graphs etc.

  1. The t-test I conducted with the data, rejected the null hypothesis, in otherwords there is a significant difference between the two groups. I tried to do the correaltion analysis in excel with the data I was given along with a scatterplot, but it just doesn't look right. 

I have attached the image with the raw data, the correlation analysis and scatterplot. 

 

I would really love to do well in this course, but it is not my strongest subject.

I would really appreciate your assistance.

 

Thank you kindly,

Carmen Loureiro

 

234567
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
A
B
C
Difference in Academic Term Averages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Sports
No Sports
Participation Participation
Treatment x Treatment y
85
86
88
82
88
90
92
90
90
77
80
89
79
83
92
86
67
65
68
68
79
79
83
72
84
82
75
74
52
75
D
E
Coefficient (r): -0,00481
15
-0,01734
13
0,493214
N:
T statistic:
DF:
p value:
100
90
80
70
60
50
40
30
20
10
0
76
●
F
78
80
G
No Sports Participation Treatment y
82
●
H
84
86
88
y=-0,0089x + 74,701
90
K
92
94
L
Transcribed Image Text:234567 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 A B C Difference in Academic Term Averages 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Sports No Sports Participation Participation Treatment x Treatment y 85 86 88 82 88 90 92 90 90 77 80 89 79 83 92 86 67 65 68 68 79 79 83 72 84 82 75 74 52 75 D E Coefficient (r): -0,00481 15 -0,01734 13 0,493214 N: T statistic: DF: p value: 100 90 80 70 60 50 40 30 20 10 0 76 ● F 78 80 G No Sports Participation Treatment y 82 ● H 84 86 88 y=-0,0089x + 74,701 90 K 92 94 L
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Thank you for your assistance and clarification. 

1. Just to confirm, the population correlation does not differ significantly from zero - would that then mean there is no real difference between the groups in terms of academic achivement and sports participation? I need to state it in a non-statistical sentence.

2. Please could you provide a scatterplot for this data so I can make sure mine is correct.

Thank you so much, really appreciate your help!

 

Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill