0% found this document useful (0 votes)
15 views4 pages

Statistical Analysis of Untimed Scores

The document contains a table with numerical data organized in rows and columns. The table seems to show standardized test scores and estimates of mean and standard deviation for different groups across various years. It provides statistical values like means, standard deviations, and correction factors for many categories including universities, majors, ages, and years.

Uploaded by

Carlos Paiva
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
15 views4 pages

Statistical Analysis of Untimed Scores

The document contains a table with numerical data organized in rows and columns. The table seems to show standardized test scores and estimates of mean and standard deviation for different groups across various years. It provides statistical values like means, standard deviations, and correction factors for many categories including universities, majors, ages, and years.

Uploaded by

Carlos Paiva
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Note: Mean and SD estimated by solving for two

unknowns for two simulatenous equations.

E[μ, σ](17, 36) E[μ, σ](17, 36) Colloquy Society


Splushka est UNTIMED Splushka UNTIMED 1st-yr uni 40' 1st-yr uni (2) 40' Engineers 40' B.A 40' SAT EQUIV 40' 1965 UNTIMED BERKLEY UNTIMED Uni & Pro 40' Age 20 40' Age 30 40'
mean 17 mean 17 mean 21.69 mean 22.17 mean 25.57 mean 20.57 mean 23.44 mean 21 mean 27 mean 22.73 mean 9.3 mean 6.9 mean 20 ARGENTINA 19-20yo
sd 7.92 sd 7.92 sd 5.9 sd 5.6 sd 4.68 sd 6.03 sd 4.91 sd 4 sd 5.14 sd 5.28 sd 9 sd 10 sd
correction correction correction correction correction correction correction correction correction correction correction correction correction
1 69.7 1 85.0 1 47.4 1 43.3 1 21.3 1 51.3 1 31.4 1 25 1 24.1 1 38 1 86 1 91 1 #DIV/0! 1
2 71.6 2 86.0 2 49.9 2 46.0 2 24.5 2 53.8 2 34.5 2 29 2 27.0 2 41 2 88 2 93 2 2
3 73.5 3 87.0 3 52.5 3 48.7 3 27.7 3 56.3 3 37.6 3 33 3 30.0 3 44 3 90 3 94 3 3

4 75.4 4 88.0 4 55.0 4 51.3 4 30.9 4 58.8 4 40.6 4 36 4 32.9 4 47 4 91 4 96 4 4


5 77.3 5 89.0 5 57.6 5 54.0 5 34.1 5 61.3 5 43.7 5 40 5 35.8 5 50 5 93 5 97 5 5
6 79.2 6 90.0 6 60.1 6 56.7 6 37.3 6 63.8 6 46.7 6 44 6 38.7 6 52 6 95 6 99 6 6
7 81.1 7 90.0 7 62.7 7 59.4 7 40.5 7 66.2 7 49.8 7 48 7 41.6 7 55 7 96 7 100 7 7

8 82.9 8 91.0 8 65.2 8 62.0 8 43.7 8 68.7 8 52.8 8 51 8 44.6 8 58 8 98 8 102 8 8


9 84.8 9 92.0 9 67.7 9 64.7 9 46.9 9 71.2 9 55.9 9 55 9 47.5 9 61 9 100 9 103 9 9
10 86.7 10 93.0 10 70.3 10 67.4 10 50.1 10 73.7 10 58.9 10 59 10 50.4 10 64 10 101 10 105 10 10
11 88.6 11 94.0 11 72.8 11 70.1 11 53.3 11 76.2 11 62.0 11 63 11 53.3 11 67 11 103 11 106 11 11
12 90.5 12 95.0 12 75.4 12 72.8 12 56.5 12 78.7 12 65.1 12 66 12 56.2 12 70 12 105 12 108 12 12
13 92.4 13 96.0 13 77.9 13 75.4 13 59.7 13 81.2 13 68.1 13 70 13 59.1 13 72 13 106 13 109 13 13

14 94.3 14 97.0 14 80.4 14 78.1 14 62.9 14 83.7 14 71.2 14 74 14 62.1 14 75 14 108 14 111 14 14
15 96.2 15 98.0 15 83.0 15 80.8 15 66.1 15 86.1 15 74.2 15 78 15 65.0 15 78 15 110 15 112 15 15 90
16 98.1 16 99.0 16 85.5 16 83.5 16 69.3 16 88.6 16 77.3 16 81 16 67.9 16 81 16 111 16 114 16 16
17 100.0 17 100.0 17 88.1 17 86.2 17 72.5 17 91.1 17 80.3 17 85 17 70.8 17 84 17 113 17 115 17 17

18 101.9 18 102.0 18 90.6 18 88.8 18 75.7 18 93.6 18 83.4 18 89 18 73.7 18 87 18 115 18 117 18 18
19 103.8 19 104.0 19 93.2 19 91.5 19 78.9 19 96.1 19 86.4 19 93 19 76.7 19 89 19 116 19 118 19 19
20 105.7 20 105.0 20 95.7 20 94.2 20 82.1 20 98.6 20 89.5 20 96 20 79.6 20 92 20 118 20 120 20 20 100
21 107.6 21 106.0 21 98.2 21 96.9 21 85.4 21 101.1 21 92.5 21 100 21 82.5 21 95 21 120 21 121 21 21

22 109.5 22 107.0 22 100.8 22 99.5 22 88.6 22 103.6 22 95.6 22 104 22 85.4 22 98 22 121 22 123 22 22 110
23 111.4 23 109.0 23 103.3 23 102.2 23 91.8 23 106.0 23 98.7 23 108 23 88.3 23 101 23 123 23 124 23 23
24 113.3 24 111.0 24 105.9 24 104.9 24 95.0 24 108.5 24 101.7 24 111 24 91.2 24 104 24 125 24 126 24 24

25 115.2 25 113.0 25 108.4 25 107.6 25 98.2 25 111.0 25 104.8 25 115 25 94.2 25 106 25 126 25 127 25 25
26 117.1 26 115.0 26 111.0 26 110.3 26 101.4 26 113.5 26 107.8 26 119 26 97.1 26 109 26 128 26 129 26 26 119
27 118.9 27 117.0 27 113.5 27 112.9 27 104.6 27 116.0 27 110.9 27 123 27 100.0 27 112 27 130 27 130 27 27
28 120.8 28 119.0 28 116.0 28 115.6 28 107.8 28 118.5 28 113.9 28 126 28 102.9 28 115 28 131 28 132 28 28 125
29 122.7 29 121.0 29 118.6 29 118.3 29 111.0 29 121.0 29 117.0 29 130 29 105.8 29 118 29 133 29 133 29 29

30 124.6 30 123.0 30 121.1 30 121.0 30 114.2 30 123.5 30 120.0 30 134 30 108.8 30 121 30 135 30 135 30 30
31 126.5 31 124.0 31 123.7 31 123.7 31 117.4 31 125.9 31 123.1 31 138 31 111.7 31 123 31 136 31 136 31 31

32 128.4 32 127.0 32 126.2 32 126.3 32 120.6 32 128.4 32 126.2 32 141 32 114.6 32 126 32 138 32 138 32 32

33 130.3 33 131.0 33 128.8 33 129.0 33 123.8 33 130.9 33 129.2 33 145 33 117.5 33 129 33 140 33 139 33 33

34 132.2 34 132.0 34 131.3 34 131.7 34 127.0 34 133.4 34 132.3 34 149 34 120.4 34 132 34 141 34 141 34 34

35 134.1 35 133.0 35 133.8 35 134.4 35 130.2 35 135.9 35 135.3 35 153 35 123.3 35 135 35 143 35 142 35 35
36 136.0 36 136.0 36 136.4 36 137.0 36 133.4 36 138.4 36 138.4 36 156 36 126.3 36 138 36 145 36 144 36 36
Pearson's r 0.984 Note: May be fairly deflated. [Link] N = 4666 [Link] [Link]

Mean ceilings Median ceilings Mode ceilings Min/max ceilings Min Max
All 138.9 All 137.7 All groups 138 All 126.3 156.3
All (minus deflated) 140.2 All (minus deflated) 138.0 All (minus deflated) 133.4 156.3
Untimed 139.5 Untimed 136.0 Untimed 126.3 156.3
Untimed (minus deflated) 146.1 Untimed (minus deflated) 146.1 Untimed (minus deflated) 136.0 156.3
Timed (40-min) 138.7 Timed (40-min) 138.0 Timed (40-min) 133.4 144.5

BUENOS AIRES
13-14YO 40' 19-20YO 40'
mean 18 mean 20
actual reported sd 4.5 actual reported sd 5
data correction data correction
1 43.3 1 43
2 46.7 2 46
3 50.0 3 49
4 53.3 4 52
5 56.7 5 55
6 60.0 6 58
7 63.3 7 61
75 8 66.7 75 8 64
9 70.0 9 67
81 10 73.3 10 70
11 76.7 81 11 73
12 80.0 12 76
13 83.3 13 79
90 14 86.7 14 82
15 90.0 90 15 85
16 93.3 16 88
17 96.7 17 91 Percentile IQ 23-24 mean 20
100 18 100.0 18 94 5 75.3 9 sd
19 103.3 19 97 10 80.8 13 correction
20 106.7 100 20 100 25 89.9 16 1 #DIV/0!
21 110.0 21 103 50 100.0 21 2
110 22 113.3 110 22 106 75 110.1 25 3
23 116.7 23 109 90 119.2 28 4
24 120.0 24 112 95 124.7 29 5
119 25 123.3 25 115 99 134.9 33 6
125 26 126.7 119 26 118 99.8 143.2 7
27 130.0 27 121 1 52.8 8
28 133.3 125 28 124 34.95808725 2 55.4 9
3 58.0
137 29 136.7 29 127 4 60.6 10
30 140.0 137 30 130 5 63.2 11
31 143.3 31 133 6 65.8 12
32 146.7 32 136 7 68.4 13
33 150.0 33 139 Percentile IQ Raw scores 21-22 8 71.0 14
34 153.3 34 142 5 75.3 9 9 73.6 15
35 156.7 35 145 10 80.8 12 10 76.2 16
36 160.0 36 148 25 89.9 15 11 78.8 17
note:argentinian data does not distribute normally note:argentinian data does not distribute normally 50 100.0 20 12 81.4 18
for this age group, mean and SD are me playing for this age group, mean and SD are me playing 75 110.1 24 13 83.9 19
and comparing and comparing 90 119.2 27 14 86.5 20
95 124.7 28 15 89.1 21
99 134.9 32 16 91.7 22
17 94.3 23
18 96.9 24
19 99.5 25
20 102.1 26
21 104.7 27
22 107.3 28
23 109.9 29
24 112.5 30
25 115.1 31
26 117.6 32
27 120.2 33
28 122.8 34
29 125.4 35
30 128.0 36
31 130.6
32 133.2
33 135.8
34 138.4
35 141.0
36 143.6
Note: Mean and SD estimated by solving for two Note: Mean and SD estimated by solving for two Note: Mean and SD estimated by solving for two
unknowns for two simulatenous equations. unknowns for two simulatenous equations. unknowns for two simulatenous equations.

BUENOS AIRES E[μ, σ](8, 25) E[μ, σ](8, 29) COMBINED E[μ, σ](8, 28) E[μ, σ](8, 30) COMBINED E[μ, σ](11, 31) E[μ, σ](9, 34) COMBINED
Age 13-14 40' 40' 40' Age 19-20 40' 40' 40' Age 25-30 40' 40' 40'
mean 17.66 16.47 mean 18 16.87 mean 21 19.08
actual reported sd 5.80 5.08 actual reported sd 6 5.32 actual reported sd 7.89 6.05
data correction data correction data correction
1 56.9 54.3 56.9 1 57.5 55.3 57.5 1 62.0 55.2 55.2
2 59.5 57.3 59.5 2 60.0 58.1 60.0 2 63.9 57.6 57.6
3 62.1 60.2 62.1 3 62.5 60.9 62.5 3 65.8 60.1 60.1
4 64.6 63.2 64.6 4 65.0 63.7 65.0 4 67.7 62.6 62.6
5 67.2 66.1 67.2 5 67.5 66.5 67.5 5 69.6 65.1 65.1
6 69.8 69.1 69.8 6 70.0 69.4 70.0 6 71.5 67.6 67.6
7 72.4 72.0 72.4 7 72.5 72.2 72.5 7 73.4 70.0 70.0
75 8 75.0 75.0 75.0 75 8 75.0 75.0 75.0 8 75.3 72.5 72.5
9 77.6 78.0 77.6 9 77.5 77.8 77.5 75 9 77.2 75.0 75.0
81 10 80.2 80.9 80.2 10 80.0 80.6 80.0 10 79.1 77.5 77.5
11 82.8 83.9 82.8 81 11 82.5 83.5 82.5 81 11 81.0 80.0 81.0
12 85.4 86.8 85.4 12 85.0 86.3 85.0 12 82.9 82.4 82.9
13 87.9 89.8 87.9 13 87.5 89.1 87.5 13 84.8 84.9 84.8
90 14 90.5 92.7 90.5 14 90.0 91.9 90.0 14 86.7 87.4 86.7
15 93.1 95.7 93.1 90 15 92.5 94.7 92.5 15 88.6 89.9 88.6
16 95.7 98.6 95.7 16 95.0 97.5 95.0 16 90.5 92.4 90.5
17 98.3 101.6 98.3 17 97.5 100.4 97.5 17 92.4 94.8 92.4
100 18 100.9 104.5 100.9 18 100.0 103.2 100.0 90 18 94.3 97.3 94.3
19 103.5 107.5 103.5 19 102.5 106.0 102.5 19 96.2 99.8 96.2
20 106.1 110.4 106.1 100 20 105.0 108.8 105.0 20 98.1 102.3 98.1
21 108.6 113.4 108.6 21 107.5 111.6 107.5 100 21 100.0 104.8 100.0
110 22 111.2 116.3 111.2 110 22 110.0 114.5 110.0 22 101.9 107.2 101.9
23 113.8 119.3 113.8 23 112.5 117.3 112.5 23 103.8 109.7 103.8
24 116.4 122.2 116.4 24 115.0 120.1 115.0 24 105.7 112.2 105.7
119 25 119.0 125.2 119.0 Average(C, D) 25 117.5 122.9 117.5 25 107.6 114.7 107.6
125 26 121.6 128.1 128.1 124.9 119 26 120.0 125.7 120.0 110 26 109.5 117.2 109.5
27 124.2 131.1 131.1 127.6 27 122.5 128.5 122.5 27 111.4 119.6 111.4
28 126.8 134.0 134.0 130.4 125 28 125.0 131.4 125.0 Average(I, J) 28 113.3 122.1 113.3 Average(I, J)
137 29 129.4 137.0 137.0 133.2 29 127.5 134.2 134.2 130.8 29 115.2 124.6 115.2 119.9
30 131.9 140.0 140.0 135.9 137 30 130.0 137.0 137.0 133.5 30 117.1 127.1 117.1 122.1
31 134.5 142.9 142.9 138.7 31 132.5 139.8 139.8 136.2 119 31 119.0 129.6 119.0 124.3
32 137.1 145.9 145.9 141.5 32 135.0 142.6 142.6 138.8 125 32 120.9 132.0 120.9 126.5
33 139.7 148.8 148.8 144.3 33 137.5 145.5 145.5 141.5 33 122.8 134.5 128.7 128.7
34 142.3 151.8 151.8 147.0 34 140.0 148.3 148.3 144.1 137 34 124.7 137.0 137.0 130.9
35 144.9 154.7 154.7 149.8 35 142.5 151.1 151.1 146.8 35 126.6 139.5 139.5 133.0
36 147.5 157.7 157.7 152.6 36 145.0 153.9 153.9 149.5 36 128.5 142.0 142.0 135.2

Pearson's r 0.9938 0.9937 0.999 0.998 Pearson's r 0.990 0.990 0.997 0.995 Pearson's r 0.986 0.985 0.995 0.988
Note: N = 8 Note: N = 8 Note: N = 8

Note: Green is best fit - based on combined data of two sets of estimated means and Note: Green is best fit - based on combined data of two sets of estimated means and Note: Green is best fit - based on combined data of two sets of estimated means and
SDs. Blue exemplifies potential accuracy by averaging the two estimates. SDs. Blue exemplifies potential accuracy by averaging the two estimates. SDs. Blue exemplifies potential accuracy by averaging the two estimates.

TODO: Go through and manually change all 8 cells to be equal to "actual reported data" later for all age groups.
BUENOS AIRES
Age 13-14 40' Age 15-16 40' Age 17-18 40'
mean 18.00 mean 19.00 mean 21.00
actual reported sd 4.87 actual reported sd 4.47 actual reported sd 4.47
data correction data correction data correction
1 47.7 1 39.6 1 32.9
2 50.7 2 43.0 2 36.3
3 53.8 3 46.3 3 39.6
4 56.9 4 49.7 4 43.0
5 60.0 5 53.0 5 46.3
6 63.1 6 56.4 6 49.7
7 66.1 Bias Zσ = X - μ Z σ = Zσ / Z IQ 7 59.8 Bias Zσ = X - μ Z σ = Zσ / Z IQ 7 53.0 Zσ = X - μ Z σ = Zσ / Z IQ
75.3 8 69.2 6.11 -10 -1.64 6.08 75 75.3 8 63.1 12.22 -11.00 -1.64 6.69 75 8 56.4 Bias -12.00 -1.64 7.30 75
9 72.3 -8 -1.28 6.24 81 9 66.5 -9.00 -1.28 7.02 81 75.3 9 59.8 15.58 -8.00 -1.28 6.24 81
80.8 10 75.4 5.40 -4 -0.67 5.93 90 80.8 10 69.8 10.96 -4.00 -0.67 5.93 90 10 63.1 -4.00 -0.67 5.93 90
11 78.5 0 0.00 0.00 100 11 73.2 0.00 0.00 0.00 100 11 66.5 0.00 0.00 0.00 100
12 81.5 4 0.67 5.93 110 12 76.5 5.00 0.67 7.41 110 12 69.8 4.00 0.67 5.93 110
13 84.6 7 1.28 5.46 119 13 79.9 7.00 1.28 5.46 119 80.8 13 73.2 7.61 8.00 1.28 6.24 119
89.9 14 87.7 2.20 8 1.64 4.86 125 14 83.2 9.00 1.64 5.47 125 14 76.5 9.00 1.64 5.47 125
15 90.8 11 2.46 4.47 137 89.9 15 86.6 3.30 11.00 2.46 4.47 137 15 79.9 11.00 2.46 4.47 137
16 93.8 X2 - X1 Z2 - Z1 σ = X' / Z' 16 89.9 X2 - X1 Z2 - Z1 σ = X' / Z' 16 83.2 X2 - X1 Z2 - Z1 σ = X' / Z'
17 96.9 2 0.36 5.51 17 93.3 2.00 0.36 5.51 89.9 17 86.6 3.30 4.00 0.36 11.01
100.0 18 100.0 0.00 4 0.67 5.93 18 96.6 4.00 0.67 5.93 18 89.9 4.00 0.67 5.93
19 103.1 3 0.61 4.94 100.0 19 100.0 0.00 2.00 0.61 3.29 19 93.3 4.00 0.61 6.59
20 106.2 3 0.81 3.68 20 103.4 2.00 0.81 2.45 20 96.6 2.00 0.81 2.45
21 109.2 21 106.7 100.0 21 100.0 0.00
110.1 22 112.3 2.20 22 110.1 22 103.4
23 115.4 23 113.4 23 106.7
24 118.5 110.1 24 116.8 6.65 24 110.1
119.2 25 121.5 2.33 4.87 25 120.1 5.31 110.1 25 113.4 -3.30 5.20
124.7 26 124.6 0.05 119.2 26 123.5 4.26 26 116.8
27 127.7 27 126.8 27 120.1
28 130.8 124.7 28 130.2 5.51 28 123.5
136.9 29 133.9 3.03 29 133.5 119.2 29 126.8 -7.61
30 136.9 136.9 30 136.9 0.00 124.7 30 130.2 -5.51
31 140.0 31 140.2 31 133.5
32 143.1 32 143.6 136.9 32 136.9 0.00
33 146.2 33 147.0 33 140.2
34 149.3 34 150.3 34 143.6
35 152.3 35 153.7 35 147.0
36 155.4 36 157.0 36 150.3
1.0000
Pearson's r 0.994 0.9972 Pearson's r 0.988 Pearson's r 0.987
Note: N = 8 Bias(C, D)
6.67
6.54
6.41
6.29
6.16
6.04
5.91
5.78
5.66 Age 23-24 40' Age 21-22 40'
5.53 mean 20.00 mean 20.00
5.41 actual reported sd #REF! actual reported sd 4.88
5.28 data correction data correction Forecast
5.15 1 41.6 1 41.6 52.8
5.03 2 44.7 2 44.7 55.4
4.90 3 47.7 3 47.7 58.0
4.78 4 50.8 4 50.8 60.6
4.65 5 53.9 5 53.9 63.2
4.52 6 57.0 6 57.0 65.8
4.40 7 60.0 Zσ = X - μ Z σ = Zσ / Z IQ 7 60.0 68.4 Zσ = X - μ Z σ = Zσ / Z IQ
4.27 8 63.1 Bias -10.00 #REF! #REF! #REF! 8 63.1 71.0 Bias 1 Bias 2 -10.00 -1.64 6.08 75
4.15 #REF! 9 66.2 #REF! -8.00 -5.87 1.36 12 75.3 9 66.2 73.6 9.15 1.75 -8.00 -5.87 1.36 12
4.02 10 69.3 -5.00 #REF! #REF! #REF! 10 69.3 76.2 -5.00 -0.67 7.41 90
3.89 11 72.3 0.00 #REF! 0.00 #REF! 11 72.3 78.8 0.00 0.00 0.00 100
3.77 #REF! 12 75.4 #REF! 4.00 #REF! #REF! #REF! 80.8 12 75.4 81.4 5.37 -0.57 4.00 0.67 5.93 110
3.64 13 78.5 7.00 #REF! #REF! #REF! 13 78.5 83.9 7.00 1.28 5.46 119
3.52 14 81.6 8.00 #REF! #REF! #REF! 14 81.6 86.5 8.00 1.64 4.86 125
3.39 #REF! 15 84.6 #REF! 12.00 #REF! #REF! #REF! 89.9 15 84.6 89.1 5.26 0.75 12.00 2.46 4.88 137
3.26 16 87.7 X2 - X1 Z2 - Z1 σ = X' / Z' 16 87.7 91.7 X2 - X1 Z2 - Z1 σ = X' / Z'
3.14 17 90.8 2.00 #REF! #REF! 17 90.8 94.3 2.00 -4.22 -0.47
3.01 18 93.9 5.00 #REF! #REF! 18 93.9 96.9 5.00 0.67 7.41
2.88 19 96.9 3.00 #REF! #REF! 19 96.9 99.5 3.00 0.61 4.94
2.76 #REF! 20 100.0 #REF! 4.00 #REF! #REF! 100.0 20 100.0 102.1 0.00 -2.09 4.00 0.81 4.91
2.63 21 103.1 21 103.1 104.7
2.51 22 106.1 22 106.1 107.3
2.38 23 109.2 23 109.2 109.9
2.25 #REF! 24 112.3 #REF! 110.1 24 112.3 112.5 -2.18 -2.35
25 115.4 #REF! 25 115.4 115.1 4.50
26 118.4 26 118.4 117.6
#REF! 27 121.5 #REF! 119.2 27 121.5 120.2 -2.30 -1.02
#REF! 28 124.6 #REF! 124.7 28 124.6 122.8 0.08 1.84
29 127.7 29 127.7 125.4
30 130.7 30 130.7 128.0
31 133.8 31 133.8 130.6
#REF! 32 136.9 #REF! 136.9 32 136.9 133.2 0.00 3.69
33 140.0 33 140.0 135.8
34 143.0 34 143.0 138.4
35 146.1 35 146.1 141.0
36 149.2 36 149.2 143.6

Pearson's r #REF! Pearson's r 0.995 0.995

Mean ceiling 152.2

You might also like