Paired marble mass difference detection: t-test in-class analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Light (g)
Heavy (g)
Paired difference
8:00 SectionLight (g)
Heavy (g)
Paired difference
2
4.65.40.8sample size n1212
3
55.70.7correct961.5
4
55.20.2incorrect262.666666667
5
5.35-0.3undecidable14.166666667
6
5.65.5-0.1sample mean5.05835.26670.2083
7
4.750.3sample standard deviation sx0.33150.27740.3059
8
4.95.10.2p-value0.0379=ttest(A2:A13,B2:B13,2,1)
9
4.95.10.2
p-value < chosen alpha of 0.05?
yes
10
5.25.30.1surprising?yes
11
5.25.50.3result?reject null hyp
12
4.74.80.1was a difference detected?yes
13
5.65.60
14
4.950.1
15
4.950.1
16
54.7-0.3
17
4.84.90.19:00 SectionLight (g)
Heavy (g)
Paired difference
18
5.35-0.3sample size n1616
19
4.950.1correct1217
20
5.25-0.2incorrect417
21
5.15.20.1undecidable0
22
5.14.6-0.5sample mean4.98135.09380.1125
23
5.15.80.7sample standard deviation sx0.16010.29990.3594
24
55.10.1p-value0.2297=TTEST(range1,range2,2,1)
25
4.950.1estimated effect size on sxL0.7027819285
=(meanHeavy-meanLight)/standardDeviationLight
26
4.85.30.5
27
4.950.1pooled standard deviation0.2404
=sqrt(((F18-1)*F23^2+(G18-1)*G23^2)/(F18+G18-2))
28
4.75.60.9effect size0.4680=(G22-F22)/F27
29
5.15.30.20.2 small effect size
30
0.5 medium effect size
31
0.8 large effect size
32
33
9:00 SectionLight (g)
Heavy (g)
Paired difference
34
sample size n2828
35
correct21
36
incorrect6
37
undecidable1
38
sample mean5.01435.16790.1536
39
sample standard deviation sx0.24600.29820.3350
40
p-value0.0222
41
estimated effect size on sxL0.6242065393
42
43
pooled standard deviation0.27340.2733657549
44
effect size0.5618
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Spring 2018
Fall2017
Spring2017
 
 
Main menu