0% ont trouvé ce document utile (0 vote)
38 vues14 pages

Exercise 10

Ce document contient des statistiques sur deux groupes, les introvertis et les extravertis. Les données sont partitionnées de deux façons, en groupes massés et distribués, et sont analysées avec des tests statistiques comme l'ANOVA.

Transféré par

Chelsea
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
38 vues14 pages

Exercise 10

Ce document contient des statistiques sur deux groupes, les introvertis et les extravertis. Les données sont partitionnées de deux façons, en groupes massés et distribués, et sont analysées avec des tests statistiques comme l'ANOVA.

Transféré par

Chelsea
Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd

Introverts SST

Massed Deviations Sqrd Dev Distributed DeviationsSqrd Dev 78


78 6.06667 36.80448 88 -1.733333 3.004443 62
62 -9.93333 98.67104 89 -0.733333 0.537777 75
75 3.06667 9.404465 93 3.266667 10.67111 81
81 9.06667 82.2045 87 -2.733333 7.471109 65
65 -6.93333 48.07106 94 4.266667 18.20445 66
66 -5.93333 35.2044 89 -0.733333 0.537777 74
74 2.06667 4.271125 90 0.266667 0.071111 66
66 -5.93333 35.2044 88 -1.733333 3.004443 77
77 5.06667 25.67114 91 1.266667 1.604445 63
63 -8.93333 79.80438 87 -2.733333 7.471109 80
80 8.06667 65.07116 86 -3.733333 13.93778 65
65 -6.93333 48.07106 92 2.266667 5.137779 67
67 -4.93333 24.33774 94 4.266667 18.20445 79
79 7.06667 49.93782 88 -1.733333 3.004443 81
81 9.06667 82.2045 sd 90 0.266667 0.071111 sd 88
1079 sum 724.9333 26.92459 1346 sum 92.93333 9.640194 89
71.9333333 mean SSW 89.7333333 mean SSW 93
87
grp-grnd 71.9333333 grp-grnd 89.73333 94
5174.40444 77616.07 SSB 179.4667 2692 SSB 89
90
Extroverts 88
Massed Deviations Sqrd Dev Distributed Deviations Sqrd Dev 91
86 -4.13333 17.08442 72 0 0 87
88 -2.13333 4.551097 65 -7 49 86
95 4.86667 23.68448 78 6 36 92
92 1.86667 3.484457 84 12 144 94
89 -1.13333 1.284437 69 -3 9 88
95 4.86667 23.68448 66 -6 36 90
91 0.86667 0.751117 72 0 0 86
89 -1.13333 1.284437 69 -3 9 88
89 -1.13333 1.284437 74 2 4 95
88 -2.13333 4.551097 69 -3 9 92
87 -3.13333 9.817757 81 9 81 89
91 0.86667 0.751117 62 -10 100 95
88 -2.13333 4.551097 64 -8 64 91
90 -0.13333 0.017777 75 3 9 89
94 3.86667 14.95114 sd 80 8 64 sd 89
1352 sum 111.7333 10.5704 1080 sum 614 24.77902 88
90.1333333 mean SSW 72 mean SSW 87
91
grp-grnd 90.1333333 grp-grnd 72 88
8124.01778 121860.3 SSB 5184 77760 SSB 90
94
72
SST 6386.85 65
SSW 1543.6 78
SSB(overall)279928.333 84
69
66
72
69
74
69
81
62
64
75
80
sum 4857
grand mea 80.95

sd
DeviationsSqrd Dev Partitioning
-2.95 8.7025 Introverts Extroverts
-18.95 359.1025 78 86
-5.95 35.4025 62 88
0.05 0.0025 75 95
-15.95 254.4025 81 92
-14.95 223.5025 65 89
-6.95 48.3025 66 95
-14.95 223.5025 74 91
-3.95 15.6025 66 89
-17.95 322.2025 77 89
-0.95 0.9025 63 88
-15.95 254.4025 80 87
-13.95 194.6025 65 91
-1.95 3.8025 67 88
0.05 0.0025 79 90
7.05 49.7025 81 94
8.05 64.8025 88 72
12.05 145.2025 89 65
6.05 36.6025 93 78
13.05 170.3025 87 84
8.05 64.8025 94 69
9.05 81.9025 89 66
7.05 49.7025 90 72
10.05 101.0025 88 69
6.05 36.6025 91 74
5.05 25.5025 87 69
11.05 122.1025 86 81
13.05 170.3025 92 62
7.05 49.7025 94 64
9.05 81.9025 88 75
5.05 25.5025 90 80
7.05 49.7025 2425 2432
14.05 197.4025 80.8333333333333 81.066666666667
11.05 122.1025 -0.11666666666667 0.1166666666667
8.05 64.8025 0.013611111111113 0.0136111111111 SSbetA
14.05 197.4025 0.408333333333386 0.4083333333333 0.816666666667
10.05 101.0025
8.05 64.8025 SSbetAxB
8.05 64.8025
7.05 49.7025 279927.1
6.05 36.6025 ANOVA
10.05 101.0025 Source of Variation SS df MS
7.05 49.7025 Between A 0.8166666666657 1 0.8166666667
9.05 81.9025 Between B 0.4166666666652 1 0.4166666667
13.05 170.3025 Interaction 4842.0166666667 1 4842.0166667
-8.95 80.1025 Within 1543.6 56 27.564285714
-15.95 254.4025
-2.95 8.7025 Total 6386.85 59
3.05 9.3025
-11.95 142.8025
-14.95 223.5025
-8.95 80.1025
-11.95 142.8025
-6.95 48.3025
-11.95 142.8025
0.05 0.0025
-18.95 359.1025
-16.95 287.3025
-5.95 35.4025
-0.95 0.9025
6386.85 SST
79.91777 sd
Massed Distributed
78 88
62 89
75 93
81 87
65 94
66 89
74 90
66 88
77 91
63 87
80 86
65 92
67 94
79 88
81 90
86 72
88 65
95 78
92 84
89 69
95 66
91 72
89 69
89 74
88 69
87 81
91 62
88 64
90 75
94 80
2431 2426
81.03333333333 80.8666666666667
0.083333333333 -0.0833333333333
0.006944444444 0.00694444444445 SSbetB
0.208333333333 0.20833333333338 0.41666666666669

> SSB - SSbetA - SSbetB

SSbetAxB

F P-value F crit
0.029627710115 0.86395822129051 4.01297337765014
0.01511617863 0.90258857300762 4.01297337765014
175.6626932711 6.56E-19 4.01297337765014
IntrovertsMassed Distributed
78 88
62 89
75 93
81 87
65 94
66 89
74 90
66 88
77 91
63 87
80 86
65 92
67 94
79 88 Anova: Two-Factor With Replication
81 90
Extroverts 86 72 SUMMARY Massed Distributed
88 65
95 78 Count 15 15
92 84 Sum 1079 1346
89 69 Average 71.933333 89.733333
95 66 Variance 51.780952 6.6380952
91 72
89 69 Extroverts
89 74 Count 15 15
88 69 Sum 1352 1080
87 81 Average 90.133333 72
91 62 Variance 7.9809524 43.857143
88 64
90 75 Total
94 80 Count 30 30
Sum 2431 2426
Average 81.033333 80.866667
Variance 114.51609 105.70575

ANOVA
Source of Variation SS df
Sample 0.8166667 1
Columns 0.4166667 1
Interaction 4842.0167 1
Within 1543.6 56

Total 6386.85 59
Total

30
2425
80.833333 sd
110.14368 10.494935834

30
2432
81.066667 sd
110.06437 10.491156648

MS F P-value F crit
0.8166667 0.0296277 0.8639582213 4.0129734
0.4166667 0.0151162 0.902588573 4.0129734
4842.0167 175.66269 6.560443E-19 4.0129734
27.564286
Ages 22-24
explaining to others dev sqrd memorization dev sqrd
1.64 -0.16 0.0256 2.78 0.2125 0.04515625
2.17 0.37 0.1369 3.44 0.8725 0.76125625
1.28 -0.52 0.2704 2.67 0.1025 0.01050625
1.66 -0.14 0.0196 2.22 -0.3475 0.12075625
2.37 0.57 0.3249 3.07 0.5025 0.25250625
2.06 0.26 0.0676 2.36 -0.2075 0.04305625
1.23 -0.57 0.3249 3.56 0.9925 0.98505625
2.25 0.45 0.2025 2.33 -0.2375 0.05640625
2.01 0.21 0.0441 1.89 -0.6775 0.45900625
1.08 -0.72 0.5184 2.34 -0.2275 0.05175625
2.29 0.49 0.2401 2.18 -0.3875 0.15015625
1.56 -0.24 0.0576 1.97 -0.5975 0.35700625

21.6 30.81
1.8 2.2326 2.5675 3.292625
sd 1.4941887431 sd 1.81455917512
2.25652777777778 SSW 15.1443317809

ages 16-18
explaining to others dev sqrd memorization dev sqrd
2.13 0.135 0.018225 2.55 -0.06917 0.0047844889
2.56 0.565 0.319225 3.44 0.82083 0.6737618889
1.68 -0.315 0.099225 3.67 1.05083 1.1042436889
1.12 -0.875 0.765625 2.12 -0.49917 0.2491706889
2.27 0.275 0.075625 3.07 0.45083 0.2032476889
2.44 0.445 0.198025 2.46 -0.15917 0.0253350889
2.29 0.295 0.087025 3.16 0.54083 0.2924970889
2.11 0.115 0.013225 2.43 -0.18917 0.0357852889
2.44 0.445 0.198025 1.99 -0.62917 0.3958548889
2 0.005 2.5E-05 2.21 -0.40917 0.1674200889
1.56 -0.435 0.189225 2.34 -0.27917 0.0779358889
1.34 -0.655 0.429025 1.99 -0.62917 0.3958548889

23.94 31.43
1.995 2.3925 2.61916666667 3.6258916668
sd 1.54677082983 sd 1.90417742524
group mean grand mean SST, SSB, SSW
note taking dev sqrd var
2.56 -0.102417 0.010489
2.89 0.227583 0.051794 computation fDEV SQRD
2.77 0.107583 0.011574 1.64 -0.6165278 0.380106501 2.13
2.75 0.087583 0.007671 2.17 -0.0865278 0.007487056 2.56
3.13 0.467583 0.218634 1.28 -0.9765278 0.953606501 1.68
2.97 0.307583 0.094607 1.66 -0.5965278 0.35584539 1.12
2.21 -0.452417 0.204681 2.37 0.11347222 0.012875945 2.27
2.88 0.217583 0.047342 2.06 -0.1965278 0.038623168 2.44
2.31 -0.352417 0.124198 1.23 -1.0265278 1.053759279 2.29
3.02 0.357583 0.127866 2.25 -0.0065278 4.26119E-05 2.11
2.12 -0.542417 0.294216 2.01 -0.2465278 0.060775945 2.44
1.88 -0.782417 0.612176 1.08 -1.1765278 1.384217612 2
2.29 0.03347222 0.00112039 1.56
31.49 1.56 -0.6965278 0.485150946 1.34
2.62416666667 1.805248 2.78 0.52347222 0.274023167 2.55
sd 1.343595 3.44 1.18347222 1.4006065 3.44
2.67 0.41347222 0.170959278 3.67
2.22 -0.0365278 0.001334279 2.12
3.07 0.81347222 0.661737056 3.07
note taking dev sqrd 2.36 0.10347222 0.010706501 2.46
2.31 0.37667 0.14188 3.56 1.30347222 1.699039834 3.16
2.23 0.29667 0.088013 2.33 0.07347222 0.005398167 2.43
1.23 -0.70333 0.494673 1.89 -0.3665278 0.134342612 1.99
1.44 -0.49333 0.243374 2.34 0.08347222 0.006967612 2.21
1.99 0.05667 0.003211 2.18 -0.0765278 0.005856501 2.34
2.41 0.47667 0.227214 1.97 -0.2865278 0.082098168 1.99
2.19 0.25667 0.065879 2.56 0.30347222 0.09209539 2.31
2.23 0.29667 0.088013 2.89 0.63347222 0.401287056 2.23
2.22 0.28667 0.08218 2.77 0.51347222 0.263653723 1.23
1.4 -0.53333 0.284441 2.75 0.49347222 0.243514834 1.44
1.66 -0.27333 0.074709 3.13 0.87347222 0.762953723 1.99
1.89 -0.04333 0.001877 2.97 0.71347222 0.509042612 2.41
2.21 -0.0465278 0.002164834 2.19
23.2 2.88 0.62347222 0.388717612 2.23
1.93333333333 1.795467 2.31 0.05347222 0.002859279 2.22
sd 1.33995 3.02 0.76347222 0.582889834 1.4
2.12 -0.1365278 0.018639834 1.66
1.88 -0.3765278 0.141773168 1.89
12.59627292
SST 24.06243194

ANOVA
Source of Variation SS df MS F
Between A 0.39456806 1 0.39456806 1.72154948
Between B 5.82798611 2 2.91399306 12.714114
Interaction 2.71310278 2 1.35655139 5.91880237
Within 15.126775 66 0.22919356

Total 24.0624319 71
Partitioning
n=12 SSbetA
N= 72 22-24
DEV SQRD computation for ssb 1.64
-0.12652778 0.016009279 22-24 explainingmemorizatnote taking 2.17
0.303472222 0.09209539 group mean 1.8 2.2326 2.624167 1.28
-0.57652778 0.332384279 minus grand -0.456528 -0.023928 0.367639 1.66
-1.13652778 1.29169539 squared 0.208418 0.000573 0.135158 2.37
0.013472222 0.000181501 multiply by n 2.501011 0.00687 1.6219 2.06
0.183472222 0.033662056 total 4.129782 1.23
0.033472222 0.00112039 2.25
-0.14652778 0.02147039 16-18 explainingmemorizatnote taking 2.01
0.183472222 0.033662056 group mean 1.995 2.619167 1.933333 1.08
-0.25652778 0.065806501 minus grand -0.261528 0.362639 -0.323195 2.29
-0.69652778 0.485150946 squared 0.068397 0.131507 0.104455 1.56
-0.91652778 0.840023168 multiply by n 0.820761 1.578084 1.253458 2.78
0.293472222 0.086125945 total 3.652303 3.44
1.183472222 1.4006065 SSB 7.782085 2.67
1.413472222 1.997903722 2.22
-0.13652778 0.018639834 3.07
0.813472222 0.661737056 2.36
0.203472222 0.041400945 SUMMARY 3.56
0.903472222 0.816262056 SST 24.06243 2.33
0.173472222 0.030092612 SSB 7.782085 1.89
-0.26652778 0.071037056 SSW 15.14433 2.34
-0.04652778 0.002164834 2.18
0.083472222 0.006967612 1.97
-0.26652778 0.071037056 2.56
0.053472222 0.002859279 2.89
-0.02652778 0.000703723 2.77
-1.02652778 1.053759279 2.75
-0.81652778 0.666717612 3.13
-0.26652778 0.071037056 2.97
0.153472222 0.023553723 2.21
-0.06652778 0.004425945 2.88
-0.02652778 0.000703723 2.31
-0.03652778 0.001334279 3.02
-0.85652778 0.733639834 2.12
-0.59652778 0.35584539 1.88
-0.36652778 0.134342612 2.330555555556
11.46615903 0.074027777556
0.00548011185
0.197284026593
P-value F crit
0.19403896 3.98626948
2.1345 3.13591793
0.00432213 3.13591793
SSbetB
16-18 Explaining to other Memorization Note taking
2.13 1.64 2.78 2.56
2.56 2.17 3.44 2.89
1.68 1.28 2.67 2.77
1.12 1.66 2.22 2.75
2.27 2.37 3.07 3.13
2.44 2.06 2.36 2.97
2.29 1.23 3.56 2.21
2.11 2.25 2.33 2.88
2.44 2.01 1.89 2.31
2 1.08 2.34 3.02
1.56 2.29 2.18 2.12
1.34 1.56 1.97 1.88
2.55 2.13 2.55 2.31
3.44 2.56 3.44 2.23
3.67 1.68 3.67 1.23
2.12 1.12 2.12 1.44
3.07 2.27 3.07 1.99
2.46 2.44 2.46 2.41
3.16 2.29 3.16 2.19
2.43 2.11 2.43 2.23
1.99 2.44 1.99 2.22
2.21 2 2.21 1.4
2.34 1.56 2.34 1.66
1.99 1.34 1.99 1.89
2.31 1.8975 2.593333333333 2.27875
2.23 -0.359027778 0.336805555333 0.022222222
1.23 0.1289009453756 0.113437982103 0.000493827151 SSbetB
1.44 3.0936226890148 2.722511570481 0.011851851615 5.8279861111111
1.99
2.41
2.19 SSbetAxB
2.23 1.5595308333333
2.22
1.4
1.66
1.89
2.1825
-0.074027778
0.0054801119156 SSbetA
0.1972840289622 0.394568055556

Vous aimerez peut-être aussi