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

Big Ideas Math A Bridge To Success Algebra 1: Student Edition 2015
1st Edition
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:HOUGHTON MIFFLIN HARCOURT
Chapter11: Data Analysis And Displays
Section11.3: Shapes Of Distributions
Problem 7Q
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
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
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL