Spreadsheet: 54770d1254832301-help-with-variable-ranges-pre-test-analysis
Sheet: input

No. | Ref | q1 | q2 | q3 | q4 | q5 | q6 | q7 | q8 | q9 | q10 | q11 | q12 | q13 | q14 | q15 | q16 | q17 | q18 | q19 | q20 | [NAME] | q22 | q23 | q24 | q25 | q26 | q27 | q28 | q29 | q30 | q31 | q32 | q33 | q34 | q35 | q36 | q37 | q38 | q39 | q40 | TOTAL ANSWERED
 | correct | C | A | B | B | B | A | B | D | D | A | D | B | C | D | A | B | B | C | C | D | C | D | D | D | A | B | A | B | C | D | . | . | . | . | . | . | . | . | . | .
1 | 001 | A | A | A | D | A | C | B | A | C | A | B | D | A | C | A | C | A | D | B | A | D | D | A | D | D | A | D | A | A | D
2 | 002 | A | A | C | A | B | A | B | D | C | C | B | B | C | B | A | B | D | C | B | A | B | D | D | C | D | C | B | B | A | D
3 | 003 | B | B | D | A | C | A | B | A | C | B | A | C | B | A | A | A | C | B | A | D | A | B | B | D | C | A | D | B | A | D
4 | 004 | D | C | B | D | D | A | B | A | B | A | A | B | C | C | C | B | C | A | C | B | C | B | C | A | D | A | B | C | D | B
5 | 005 | C | A | C | B | D | A | C | D | D | C | A | D | B | B | A | B | C | A | B | C | C | D | D | D | A | B | A | B | C | D
6 | 006 | C | C | D | A | D | A | C | C | D | A | B | A | A | B | D | A | C | D | B | C | A | C | B | D | A | A | D | D | B | C
7 | 007 | C | A | C | C | B | C | B | C | D | C | A | A | B | C | A | B | B | A | D | D | C | C | A | D | A | B | B | A | B | A
8 | 008 | C | B | D | B | D | D | C | C | B | A | A | D | B | B | A | A | C | B | C | A | C | B | B | A | C | A | C | B | A | C
9 | 009 | C | A | A | B | C | A | D | C | B | C | C | D | D | B | A | B | D | B | C | A | C | D | A | D | A | D | B | C | C | D
10 | 010 | D | C | A | B | B | A | B | D | D | C | A | B | D | C | B | C | C | B | C | A | D | B | D | B | D | B | C | A | C | C
11 | 011 | C | C | C | B | A | A | C | A | D | C | C | B | A | B | A | B | B | B | B | D | D | B | A | D | C | D | A | B | D | B
12 | 012 | C | C | C | A | A | A | C | D | C | B | C | B | D | B | A | A | C | D | A | D | B | D | B | C | A | A | C | B | C | B
13 | 013 | C | C | B | B | D | A | C | B | D | C | A | D | D | C | A | B | C | C | C | D | C | D | D | D | C | B | B | B | C | D
14 | 014 | C | A | A | B | A | D | A | D | C | D | D | D | A | B | A | A | C | D | D | A | C | D | C | C | A | D | C | A | A | C
15 | 015 | C | A | B | B | B | A | B | D | D | C | A | A | A | C | A | B | C | B | B | B | C | C | D | D | A | B | B | A | C | A
16 | 016 | D | C | C | B | C | B | D | C | D | A | A | B | B | C | C | C | B | A | B | C | B | B | D | A | B | C | B | A | B | B
17 | 017 | C | C | C | B | A | A | C | D | B | B | D | A | A | C | A | D | B | A | B | A | B | B | C | C | A | B | C | D | C | B
18 | 018 | C | A | D | C | D | C | C | D | C | C | D | D | C | B | A | B | C | A | B | C | A | C | A | C | A | B | A | B | C | B
19 | 019 | C | B | B | B | C | A | C | D | D | C | B | D | B | D | A | B | D | A | C | A | C | D | B | D | A | A | B | C | B | D
20 | 020 | C | C | D | B | D | A | D | D | B | C | B | C | A | A | A | B | D | B | C | C | D | D | A | D | A | D | B | A | C | C
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 | A
 | B
 | C
 | D
 | TOTAL
 | reference
 | total subjects
 | total questions
 | score group size
 | high score group range
 | low score group range