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 the below information (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 along with graphs etc.
I created the below table and graph on excel, please can you have a look at it for me and advise if I have made an error.
I am not sure if the standard deviation on the excel spreadsheet is correct because I get a different figure when I use the online t-test calculator (please advise).
I used an online t-test calculator and got the below as an answer, please advise whether this is correct or not.
I have attached image with the excel table, excel graph and online t-test calculator calculation.
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
Transcribed Image Text:Treatment 1 (X)
85
86
88
82
88
90
92
90
90
77
80
89
788789
79
83
92
le
One-tailed
Two-tailed
Diff (X-M)
Significance Level:
0.01
O.05
0.10
One-tailed or two-tailed hypothesis?:
-1.07
-0.07
1.93
-4.07
1.93
3.93
5.93
3.93
3.93
-9.07
-6.07
2.93
-7.07
-3.07
5.93
Mean Academic Term Average
(%)
M: 86.07
li
100,00
80,00
60,00
40,00
20,00
0,00
Sq. Diff(X-M²
Treatment 1
5²₁ =
Difference Scores Calculations
N₁:15
df₁ = N-1=15-1 = 14
M₁: 86.07
SS₁: 328.93
SS: 328.93
1.14
0.00
3.74
16.54
3.74
15.47
35.20
15.47
15.47
82.20
36.80
8.60
49.94
9.40
35.20
Treatment 2
= SS₁/(N-1) = 328.93/(15-1) = 23.5
T-value Calculation
le
N₂: 15
df₂= N-1 =15-1 = 14
M₂: 73.93
SS₂: 1130.93
²₂ = SS₂/(N-1) = 1130.93/(15-1) = 80.78
The t-value is 4.60186. The p-value is .000082. The result is significant at p<.05.
Note: If you wish to calculate the effect size, this calculator will do the job.
s²M₁ = ²/N₁ = 52.14/15 = 3.48
²M₂=²p/N₂ = 52.14/15 = 3.48
²= ((df₁/(df₁ + df₂))* 3²₁) + ((df₂/(df₂ + df₂))
* s²₂) = ((14/28) * 23.5) + ((14/28) * 80.78) =
52.14
Treatment 2 (X)
I
86
67
65
68
68
t = (M₁ - M₂)/√(5²M₁ + ²M₂2) = 12.13/√6.95 =
4.6
79
79
83
72
84
82
75
74
52
75
Sports Participation
No Sports Participation Term Avergae (%)
Difference in Academic Term Avergaes (%)
Sports Participation Term Averages (%)
le
86
67
65
89
89
Diff (X-M)
Sports Participation
79
79
83
92
123456789
Difference in Academic Term Averages (%) in
Relation to Sports Participation
06
12.07
-6.93
-8.93
-5.93
-5.93
5.07
5.07
9.07
-1.93
10.07
8.07
1.07
0.07
-21.93
1.07
M: 73.93
No Sports Participation
A
72
84
82
75
74
52
75,
Sq. Diff(X-M²
79
145.60
48.07
79.80
35.20
35.20
25.67
25.67
82.20
3.74
101.34
65.07
1.14
0.00
481.07
1.14
SS: 1130.93
No Sports Participation
Sports Participation
73,93333333
8,987822449
22 Standard deviation
21 Mean
23 T-test
10
11
12
13
14
15
16
17
18
19
20
24
86,06666667
4,84718868
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
