Spreadsheet: 826169d1681835725-vlookup-n-a-error-wth
Sheet: Normative Data

CTMT2 Composite | Inhibitory | Control |  |  | ABS Formula |  |  | ABS Value
 | 0.05 | 0.01
Set-Shifting Index | 11 | 15
Normative Frequency
Amount of Difference | ICI-SSI
>31 | 0
31 | 0.1
30 | 0.1
29 | 0.2
28 | 0.3
27 | 0.4
26 | 0.5
25 | 0.7
24 | 0.9
23 | 1.2
22 | 1.4
21 | 1.6
20 | 1.9
19 | 2.2
18 | 2.9
17 | 4.1
16 | 5.7
15 | 7.6
14 | 8.8
13 | 11.1
12 | 13.9
11 | 17.6
10 | 22.4
9 | 27.2
8 | 32.6
7 | 38.3
6 | 45.7
5 | 53.8
4 | 62.7
3 | 71.1 |  |  |  |  |  |  | amount of difference column should match the ABS Value column (as long as that value exists in the lookup table).
2 | 82.6 |  |  |  |  |  |  | floating point error column should be between -1E-13 and +1E-13. Anything larger probably indicates an error in the lookup strategy.
1 | 94.2
0 | 100
Mean | 6.1
SD | 5.1 |  |  |  |  |  |  |  |  |  | amount
Median | 5 |  |  |  |  |  |  |  | floating | match | of
 |  |  |  |  |  |  |  |  | point | function | difference
 |  |  |  |  |  |  |  |  | error | row | from
Trail Differences | 0.05 | 0.01 |  |  | ABS Formula |  |  | ABS Value | test | number | table
Trail 1 | 12.1 | 14.5
Trail 2 | 11.4 | 13.7
Trail 3 | 8.5 | 10.2
Trail 4 | 9 | 10.8
Trail 5 | 9.1 | 10.9
[NAME] (Normative Frequency) of Ipsative Trail Discrepancies Across All Ages
Amount of Difference | Trail 1 | Trail 2 | Trail 3 | Trail 4 | Trail 5 |  |  |  |  | [NAME] are mostly every 0.2, but some entries are missing
32.8 | 0 | 0 | 0 | 0 | 0.1 |  |  |  |  | mostly between 18 and 33
26.2 | 0 | 0 | 0 | 0.1 | 0.1
23.8 | 0.1 | 0 | 0 | 0.1 | 0.1
23.6 | 0.1 | 0 | 0 | 0.1 | 0.1
23.2 | 0.1 | 0 | 0 | 0.1 | 0.2
21.8 | 0.1 | 0 | 0 | 0.1 | 0.2
21.6 | 0.1 | 0 | 0 | 0.1 | 0.2
21.4 | 0.1 | 0 | 0 | 0.2 | 0.2
21 | 0.1 | 0 | 0.1 | 0.2 | 0.3
20.6 | 0.1 | 0 | 0.1 | 0.2 | 0.4
20.4 | 0.2 | 0 | 0.1 | 0.3 | 0.4
20.2 | 0.2 | 0 | 0.1 | 0.3 | 0.4
20 | 0.2 | 0 | 0.1 | 0.3 | 0.4
19.8 | 0.2 | 0 | 0.1 | 0.4 | 0.5
19.2 | 0.2 | 0 | 0.1 | 0.5 | 0.5
19 | 0.2 | 0 | 0.1 | 0.5 | 0.6
18.8 | 0.2 | 0 | 0.1 | 0.5 | 0.7
18.6 | 0.2 | 0 | 0.1 | 0.5 | 0.7
18.2 | 0.2 | 0 | 0.1 | 0.6 | 0.7
18 | 0.4 | 0 | 0.1 | 0.6 | 0.8
17.8 | 0.4 | 0 | 0.1 | 0.7 | 0.8
17.6 | 0.4 | 0 | 0.2 | 0.7 | 0.8
17.4 | 0.4 | 0 | 0.2 | 0.7 | 0.9
17.2 | 0.5 | 0.1 | 0.2 | 0.7 | 1
17 | 0.5 | 0.1 | 0.2 | 0.8 | 1.1
16.8 | 0.5 | 0.1 | 0.2 | 0.9 | 1.2
16.6 | 0.6 | 0.1 | 0.3 | 1 | 1.3
16.4 | 0.8 | 0.1 | 0.3 | 1.2 | 1.4
16.2 | 0.9 | 0.2 | 0.3 | 1.4 | 1.4
16 | 1.3 | 0.3 | 0.4 | 1.4 | 1.5
15.8 | 1.5 | 0.3 | 0.5 | 1.4 | 1.6
15.6 | 1.6 | 0.4 | 0.7 | 1.5 | 1.9
15.4 | 1.6 | 0.4 | 0.7 | 1.5 | 1.9
15.2 | 1.7 | 0.5 | 0.9 | 1.6 | 2
15 | 1.7 | 0.5 | 1 | 1.6 | 2.3
14.8 | 1.8 | 0.6 | 1.3 | 1.7 | 2.4
14.6 | 2 | 0.6 | 1.5 | 1.8 | 2.4
14.4 | 2.1 | 0.9 | 1.6 | 1.9 | 2.5
14.2 | 2.2 | 0.9 | 1.7 | 2 | 2.7
14 | 2.2 | 1 | 1.9 | 2.1 | 2.9
13.8 | 2.4 | 1.2 | 1.9 | 2.2 | 3.2
13.6 | 2.4 | 1.3 | 2 | 2.3 | 3.6
13.4 | 2.6 | 1.4 | 2.1 | 2.8 | 3.9
13.2 | 2.6 | 1.5 | 2.3 | 3.3 | 4.4
13 | 2.9 | 1.5 | 2.4 | 3.6 | 4.6
12.8 | 2.9 | 1.7 | 2.5 | 3.9 | 5.2
12.6 | 2.9 | 1.8 | 2.8 | 4.3 | 5.5
12.4 | 3 | 2.2 | 2.8 | 4.5 | 5.9
12.2 | 3.5 | 2.4 | 3.3 | 5.1 | 6.2
12 | 3.6 | 2.6 | 3.4 | 5.6 | 6.5
11.8 | 4 | 2.8 | 3.7 | 5.8 | 6.8
11.6 | 4.3 | 2.9 | 4.1 | 6 | 6.9
11.4 | 4.8 | 2.9 | 4.7 | 6.5 | 7.3
11.2 | 5 | 3.4 | 5.1 | 6.9 | 7.7
11 | 5.3 | 3.6 | 5.6 | 7.3 | 8.2
10.8 | 5.7 | 4.8 | 6 | 7.9 | 8.9
10.6 | 6.1 | 4.2 | 6.4 | 8.7 | 9.3
10.4 | 6.4 | 4.7 | 6.7 | 9 | 9.8
10.2 | 6.8 | 5.2 | 7.2 | 9.9 | 10.2
10 | 7.4 | 5.6 | 7.6 | 11 | 10.7
9.8 | 8 | 5.9 | 7.9 | 11.7 | 11
9.6 | 8.3 | 6.4 | 8.6 | 12.5 | 11.3
9.4 | 8.7 | 7.1 | 8.9 | 13 | 12
9.2 | 9.2 | 7.6 | 9.5 | 13.7 | 12.9
9 | 10.1 | 7.9 | 10.1 | 14.8 | 13.7
8.8 | 10.5 | 8.4 | 11 | 15.9 | 14.7
8.6 | 10.8 | 8.8 | 11.8 | 16.7 | 15.7
8.4 | 11.3 | 9.7 | 12.6 | 17.4 | 16.7
8.2 | 11.9 | 11 | 13 | 18.5 | 17.6
8 | 13.8 | 11.7 | 13.8 | 19.3 | 18.4
7.8 | 15.2 | 12.6 | 14.4 | 20.5 | 19.2
7.6 | 16 | 13.6 | 15.6 | 21.4 | 20
7.4 | 17.5 | 14.7 | 16.5 | 22.4 | 20.9
7.2 | 18.5 | 15.6 | 17.5 | 23.6 | 22.4
7 | 19.4 | 17.5 | 19 | 24.9 | 23.8
6.8 | 20.7 | 18.7 | 20.2 | 25.6 | 25.1
6.6 | 22 | 19.6 | 21.2 | 27.2 | 26.7
6.4 | 23 | 20.6 | 22.9 | 28.6 | 27.6
6.2 | 24.4 | 21.8 | 24.2 | 29.9 | 29.1
6 | 26.4 | 23.4 | 26.1 | 31.9 | 30.7
5.8 | 28.1 | 24.8 | 28.1 | 33.3 | 32
5.6 | 29.8 | 26.1 | 29.5 | 34.7 | 33.5
5.4 | 31.4 | 27.9 | 30.8 | 36.6 | 35.2
5.2 | 33.1 | 29.7 | 31.9 | 37.8 | 36.8
5 | 34.9 | 31.5 | 33.8 | 39.3 | 38.6
4.8 | 36.7 | 33.6 | 35 | 41.5 | 40.5
4.6 | 39.3 | 35.9 | 36.6 | 43.1 | 42.6
4.4 | 40.8 | 38.8 | 38.7 | 45.2 | 44.8
4.2 | 42.6 | 40.7 | 40.9 | 47.8 | 46.9
4 | 45 | 43.6 | 43.1 | 49.7 | 49.1
3.8 | 47.7 | 46.1 | 45.9 | 51.2 | 51.4
3.6 | 50.3 | 48.1 | 48.5 | 53.1 | 53.3
3.4 | 53.5 | 49.8 | 50.7 | 55.1 | 55.5
3.2 | 56.6 | 52.1 | 53.4 | 57.5 | 57.7
3 | 58.8 | 54.8 | 56.3 | 60.5 | 60
2.8 | 61.4 | 57.2 | 59 | 63.4 | 61.9
2.6 | 63.8 | 59.8 | 61.9 | 66 | 64.8
2.4 | 66.3 | 62.8 | 64.3 | 68.4 | 67.1
2.2 | 66.9 | 66.9 | 67.3 | 71.1 | 68.7
2 | 72.9 | 69.2 | 70.7 | 74.2 | 71.5
1.8 | 75.4 | 73 | 73.4 | 77 | 75.1
1.6 | 78.6 | 76.2 | 75.6 | 79.9 | 77
1.4 | 81.6 | 78.7 | 78.3 | 83.2 | 79
1.2 | 84.8 | 81.5 | 81.1 | 85.9 | 82.6
1 | 87.8 | 84.4 | 84 | 88.8 | 86
0.8 | 90.7 | 88 | 87.7 | 91.9 | 88.9
0.6 | 93.1 | 91 | 91.1 | 94.4 | 91.6
0.4 | 95.7 | 94.3 | 94.2 | 96.4 | 95.2
0.2 | 98.2 | 97.4 | 98.1 | 98.7 | 98.2
0 | 100 | 100 | 100 | 100 | 100