Multiple Questions Knowledge

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 53

Respondents Question 1 Question 2 Question 3

1 2 1 4
2 1 1 3
3 1 1 4
4 1 1 2
5 1 1 2
6 2 1 4
7 2 3 3
8 2 1 2
9 2 1 4
10 2 1 4
11 1 1 4
12 1 1 1
13 2 2 2
14 1 1 4
15 1 1 4
16 1 1 4
17 1 1 2
18 2 1 2
19 1 1 4
20 2 1 4
21 1 1 4
22 2 3 2
23 2 3 2
24 2 1 3
25 1 1 3
26 2 1 4
27 2 1 4
28 1 3 2
29 1 4 2
30 1 3 3
31 1 1 4
32 3 1 3
33 1 1 4
34 1 1 3
35 1 1 4
36 2 3 3
37 2 1 2
38 3 1 3
39 2 1 3
40 2 3 3
41 2 3 2
42 1 1 4
43 3 4 3
44 1 3 2
45 1 1 4
46 4 1 4
47 3 3 3
48 1 3 3
49 1 1 4
50 1 1 2
51 4 1 4
52 1 1 4
53 2 1 3
54 4 3 4
55 1 1 3
56 1 1 3
57 2 3 2
58 3 1 4
59 1 1 2
60 2 1 4
61 1 1 4
62 1 3 2
63 1 1 4
64 2 1 2
65 1 2 2
66 1 1 3
67 2 1 3
68 1 1 3
69 2 3 2
70 2 1 2
71 3 1 3
72 1 1 2
73 1 1 2
74 2 3 2
75 2 4 3

Correct 38 54 28
Incorrect 37 21 47
Average 37.5 37.5 37.5

Legend
Question 1
1 Applying the Currency format
2 Applying the Accounting Format
3 Manually typing the currency symbol
4 Using the Format Painter

Question 2
1 MAX
2 MIN
3 SUM
4 AVERAGE

Question 3
1%
2=
3*
4$

Question 4
1 Menu Bar
2 Standard Toolbar
3 Title Bar
4 Formula Bar

Question 5
1 Statistics
2 Workbook Analysis
3 Workbook Statistics
4 Excel Statistics

Question 6
1 xlsm
2 xlsx
3 msxcl
4 xcl

Question 7
1 Page Break
2 Cell
3 Box
4 Range
Question 8
1 Text Layout
2 Orientation
3 Cell Orientation
4 Text Flip

Question 9
1 Financial
2 Statistical
3 Logical
4 Math; Trigonometry

Question 10
1 Straight-Line Method
2 Declining Balance Method
3 Sum-of-Years'-Digits Method
4 MACRS (Modified Accelerated Cost Recovery System)

Question 11
1 Straight-Line Method
2 Wide range of built-in functions for calculations
3 Ease of sharing and collaborating on spreadsheets
4 Ability to handle large datasets efficiently

Question 12
1 Faster Calculations
2 Improved Accuracy
3 Enhanced Reporting Capabilities
4 Time Savings

Question 13
1 SUM
2 AVERAGE
3 VLOOKUP INDEX/MATCH CONCATENATE DATE functions (e.g., TODAY, DATE, DAY
4 FINANCIAL FUNCTIONS (e.g., PV, FV, PMT)

Question 14
1 From the file menu, select the new command
2 Use the relevant mathematical operation to enter the formula, along with any input
3 Select the cell where the formula should be entered
4 To alert Excel that you are ready to add a formula, type the equals sign (=)
Question 15
1 Layers and Planes
2 Height and Width
3 Lines and Spaces
4 Rows and Columns
Question 4 Question 5 Question 6 Question 7
3 3 2 2
3 3 2 2
3 3 2 2
3 1 2 3
3 1 2 2
3 3 2 2
3 1 2 2
3 1 2 2
3 4 2 2
3 3 2 2
3 3 2 2
3 4 2 2
1 4 2 2
3 3 2 2
3 1 2 2
3 3 1 2
3 4 2 2
3 4 2 2
3 4 2 2
3 4 2 2
3 4 2 2
3 1 2 2
3 3 2 1
3 4 2 2
3 2 2 2
3 4 2 2
3 2 2 2
2 4 2 2
3 1 2 1
3 3 2 2
3 4 2 2
3 4 2 2
3 4 2 1
3 2 2 2
3 2 2 2
3 4 3 3
3 3 2 2
3 4 2 1
3 1 2 2
3 4 2 2
3 4 2 2
3 4 2 2
3 2 2 2
3 1 2 2
3 1 2 2
3 1 2 2
3 4 4 2
3 4 2 2
3 4 2 2
3 4 2 2
3 3 2 2
3 3 2 2
3 4 2 2
3 4 2 2
3 1 2 2
3 4 2 2
3 1 2 2
3 3 2 2
3 3 2 3
3 4 2 2
3 4 2 2
3 3 2 2
3 4 1 2
3 2 2 2
3 3 2 2
3 3 2 1
3 2 2 2
1 3 2 2
3 1 2 2
3 4 1 2
2 3 2 2
3 4 2 3
3 3 2 3
3 2 2 2
3 2 2 2

0 31 70 65
4 44 5 10
2 37.5 37.5 37.5
nctions (e.g., TODAY, DATE, DAY)

he formula, along with any input values

ype the equals sign (=)


Question 8 Question 9 Question 10 Question 11
2 1 2 3
2 1 3 2
2 1 1 4
2 1 1 2
2 1 1 4
2 1 1 4
1 1 1 4
1 2 1 2
2 1 1 4
3 1 1 3
2 1 1 4
1 1 3 4
4 1 1 1
2 1 1 2
3 1 1 4
3 1 1 2
3 1 1 4
2 1 2 4
2 1 1 2
3 1 1 2
2 1 1 4
3 1 1 2
1 1 1 1
1 1 4 2
2 2 1 4
2 1 1 3
2 1 1 2
3 2 2 4
4 1 2 2
1 1 1 4
2 1 1 2
3 1 1 4
3 1 1 2
1 1 1 2
3 1 1 2
2 1 3 4
3 1 1 3
3 1 1 4
1 1 3 2
3 2 1 3
1 1 3 2
3 1 1 4
2 1 1 2
3 3 3 2
3 2 1 2
2 1 1 4
1 1 1 4
3 1 4 4
2 3 2 2
4 1 1 2
2 1 1 4
2 1 1 1
1 1 1 4
1 1 2 2
1 1 1 2
1 1 1 2
2 1 1 2
2 2 3 2
3 1 1 2
2 1 2 4
2 1 1 4
1 1 1 4
2 1 2 2
3 1 1 2
3 1 1 2
1 1 1 2
3 1 1 2
3 1 1 2
1 1 1 4
2 1 1 4
1 1 1 4
4 1 1 4
3 1 1 4
4 1 3 4
4 1 3 4

28 67 56 33
47 8 19 41
37.5 37.5 37.5 37
Question 12 Question 13 Question 14 Question 15
3 3 4 2
2 1 4 2
4 1 4 2
1 1 4 2
3 3 4 2
3 1 3 2
4 1 4 2
1 1 2 2
3 1 3 2
3 3 4 2
3 3 3 2
3 3 4 2
1 1 4 2
1 1 3 2
2 2 3 2
2 3 4 2
3 1 4 2
1 1 4 2
4 1 3 2
3 2 3 2
1 1 4 2
1 1 3 2
3 3 1 2
2 1 4 2
4 1 3 2
3 1 3 2
1 3 3 2
1 3 2 2
1 1 4 2
1 1 4 2
4 1 3 2
1 3 4 2
4 3 3 2
1 3 1 2
1 1 4 2
2 3 4 2
2 1 4 2
1 3 2 2
3 1 3 2
4 3 4 1
1 1 4 2
2 1 4 2
3 3 1 2
1 1 3 2
1 1 3 2
1 3 4 2
4 1 3 2
3 3 2 2
1 1 4 2
1 1 4 2
1 1 4 2
4 3 4 2
2 3 3 2
2 3 4 2
4 1 4 2
4 3 4 2
1 1 4 2
2 3 4 2
2 1 3 2
3 1 4 2
2 3 4 2
1 3 1 2
4 3 4 2
2 1 4 2
1 1 4 2
1 1 3 2
1 2 4 2
1 1 4 2
2 1 4 2
1 1 4 2
1 3 4 2
1 3 3 2
1 3 4 2
2 1 4 2
2 1 4 2

32 43 46 0
43 32 29 1
37.5 37.5 37.5 0.5
Respondents Question 1 x-mean (x-mean)^2
1 2 0.347 0.120 HS=
2 1 -0.653 0.427 LS=
3 1 -0.653 0.427
4 1 -0.653 0.427 Range=
5 1 -0.653 0.427
6 2 0.347 0.120 n=
7 2 0.347 0.120
8 2 0.347 0.120 Mean=
9 2 0.347 0.120
10 2 0.347 0.120 Variance=
11 1 -0.653 0.427 SD=
12 1 -0.653 0.427
13 2 0.347 0.120 Variance=
14 1 -0.653 0.427 SD=
15 1 -0.653 0.427
16 1 -0.653 0.427
17 1 -0.653 0.427
18 2 0.347 0.120
19 1 -0.653 0.427
20 2 0.347 0.120
21 1 -0.653 0.427
22 2 0.347 0.120
23 2 0.347 0.120
24 2 0.347 0.120
25 1 -0.653 0.427
26 2 0.347 0.120
27 2 0.347 0.120
28 1 -0.653 0.427
29 1 -0.653 0.427
30 1 -0.653 0.427
31 1 -0.653 0.427
32 3 1.347 1.814
33 1 -0.653 0.427
34 1 -0.653 0.427
35 1 -0.653 0.427
36 2 0.347 0.120
37 2 0.347 0.120
38 3 1.347 1.814
39 2 0.347 0.120
40 2 0.347 0.120
41 2 0.347 0.120
42 1 -0.653 0.427
43 3 1.347 1.814
44 1 -0.653 0.427
45 1 -0.653 0.427
46 4 2.347 5.507
47 3 1.347 1.814
48 1 -0.653 0.427
49 1 -0.653 0.427
50 1 -0.653 0.427
51 4 2.347 5.507
52 1 -0.653 0.427
53 2 0.347 0.120
54 4 2.347 5.507
55 1 -0.653 0.427
56 1 -0.653 0.427
57 2 0.347 0.120
58 3 1.347 1.814
59 1 -0.653 0.427
60 2 0.347 0.120
61 1 -0.653 0.427
62 1 -0.653 0.427
63 1 -0.653 0.427
64 2 0.347 0.120
65 1 -0.653 0.427
66 1 -0.653 0.427
67 2 0.347 0.120
68 1 -0.653 0.427
69 2 0.347 0.120
70 2 0.347 0.120
71 3 1.347 1.814
72 1 -0.653 0.427
73 1 -0.653 0.427
74 2 0.347 0.120
75 2 0.347 0.120
Respondents Question 2
4 1 1
1 2 1
3 1
3 4 1
5 1
75 6 1
7 3
1.653 SUM= 46.987 8 1
9 1
0.635 10 1
0.797 11 1
12 1
0.635 13 2
0.797 14 1
15 1
16 1
17 1
18 1
19 1
20 1
21 1
22 3
23 3
24 1
25 1
26 1
27 1
28 3
29 4
30 3
31 1
32 1
33 1
34 1
35 1
36 3
37 1
38 1
39 1
40 3
41 3
42 1
43 4
44 3
45 1
46 1
47 3
48 3
49 1
50 1
51 1
52 1
53 1
54 3
55 1
56 1
57 3
58 1
59 1
60 1
61 1
62 3
63 1
64 1
65 2
66 1
67 1
68 1
69 3
70 1
71 1
72 1
73 1
74 3
75 4
x-mean (x-mean)^2
-0.573 0.329 HS= 4
-0.573 0.329 LS= 1
-0.573 0.329
-0.573 0.329 Range= 3
-0.573 0.329
-0.573 0.329 n= 75
1.427 2.035
-0.573 0.329 Mean= 1.573 SUM= 68.347
-0.573 0.329
-0.573 0.329 Variance= 0.924
-0.573 0.329 SD= 0.961
-0.573 0.329
0.427 0.182 Variance= 0.924
-0.573 0.329 SD= 0.961
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
2.427 5.889
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
1.427 2.035
-0.573 0.329
2.427 5.889
1.427 2.035
-0.573 0.329
-0.573 0.329
1.427 2.035
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
-0.573 0.329
-0.573 0.329
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
-0.573 0.329
-0.573 0.329
0.427 0.182
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
-0.573 0.329
-0.573 0.329
-0.573 0.329
-0.573 0.329
1.427 2.035
2.427 5.889
Respondents Question 3 x-mean (x-mean)^2
1 4 0.973 0.947 HS=
2 3 -0.027 0.001 LS=
3 4 0.973 0.947
4 2 -1.027 1.054 Range=
5 2 -1.027 1.054
6 4 0.973 0.947 n=
7 3 -0.027 0.001
8 2 -1.027 1.054 Mean=
9 4 0.973 0.947
10 4 0.973 0.947 Variance=
11 4 0.973 0.947 SD=
12 1 -2.027 4.107
13 2 -1.027 1.054 Variance=
14 4 0.973 0.947 SD=
15 4 0.973 0.947
16 4 0.973 0.947
17 2 -1.027 1.054
18 2 -1.027 1.054
19 4 0.973 0.947
20 4 0.973 0.947
21 4 0.973 0.947
22 2 -1.027 1.054
23 2 -1.027 1.054
24 3 -0.027 0.001
25 3 -0.027 0.001
26 4 0.973 0.947
27 4 0.973 0.947
28 2 -1.027 1.054
29 2 -1.027 1.054
30 3 -0.027 0.001
31 4 0.973 0.947
32 3 -0.027 0.001
33 4 0.973 0.947
34 3 -0.027 0.001
35 4 0.973 0.947
36 3 -0.027 0.001
37 2 -1.027 1.054
38 3 -0.027 0.001
39 3 -0.027 0.001
40 3 -0.027 0.001
41 2 -1.027 1.054
42 4 0.973 0.947
43 3 -0.027 0.001
44 2 -1.027 1.054
45 4 0.973 0.947
46 4 0.973 0.947
47 3 -0.027 0.001
48 3 -0.027 0.001
49 4 0.973 0.947
50 2 -1.027 1.054
51 4 0.973 0.947
52 4 0.973 0.947
53 3 -0.027 0.001
54 4 0.973 0.947
55 3 -0.027 0.001
56 3 -0.027 0.001
57 2 -1.027 1.054
58 4 0.973 0.947
59 2 -1.027 1.054
60 4 0.973 0.947
61 4 0.973 0.947
62 2 -1.027 1.054
63 4 0.973 0.947
64 2 -1.027 1.054
65 2 -1.027 1.054
66 3 -0.027 0.001
67 3 -0.027 0.001
68 3 -0.027 0.001
69 2 -1.027 1.054
70 2 -1.027 1.054
71 3 -0.027 0.001
72 2 -1.027 1.054
73 2 -1.027 1.054
74 2 -1.027 1.054
75 3 -0.027 0.001
Respondents Question 4 x-mean
4 1 3 0.080
1 2 3 0.080
3 3 0.080
3 4 3 0.080
5 3 0.080
75 6 3 0.080
7 3 0.080
3.027 SUM= 55.947 8 3 0.080
9 3 0.080
0.756 10 3 0.080
0.870 11 3 0.080
12 3 0.080
0.756 13 1 -1.920
0.870 14 3 0.080
15 3 0.080
16 3 0.080
17 3 0.080
18 3 0.080
19 3 0.080
20 3 0.080
21 3 0.080
22 3 0.080
23 3 0.080
24 3 0.080
25 3 0.080
26 3 0.080
27 3 0.080
28 2 -0.920
29 3 0.080
30 3 0.080
31 3 0.080
32 3 0.080
33 3 0.080
34 3 0.080
35 3 0.080
36 3 0.080
37 3 0.080
38 3 0.080
39 3 0.080
40 3 0.080
41 3 0.080
42 3 0.080
43 3 0.080
44 3 0.080
45 3 0.080
46 3 0.080
47 3 0.080
48 3 0.080
49 3 0.080
50 3 0.080
51 3 0.080
52 3 0.080
53 3 0.080
54 3 0.080
55 3 0.080
56 3 0.080
57 3 0.080
58 3 0.080
59 3 0.080
60 3 0.080
61 3 0.080
62 3 0.080
63 3 0.080
64 3 0.080
65 3 0.080
66 3 0.080
67 3 0.080
68 1 -1.920
69 3 0.080
70 3 0.080
71 2 -0.920
72 3 0.080
73 3 0.080
74 3 0.080
75 3 0.080
(x-mean)^2 Respondents
0.0064 HS= 3 1
0.0064 LS= 1 2
0.0064 3
0.0064 Range= 2 4
0.0064 5
0.0064 n= 75 6
0.0064 7
0.0064 Mean= 2.920 SUM= 9.520 8
0.0064 9
0.0064 Variance= 0.129 10
0.0064 SD= 0.359 11
0.0064 12
3.6864 Variance= 0.129 13
0.0064 SD= 0.359 14
0.0064 15
0.0064 16
0.0064 17
0.0064 18
0.0064 19
0.0064 20
0.0064 21
0.0064 22
0.0064 23
0.0064 24
0.0064 25
0.0064 26
0.0064 27
0.8464 28
0.0064 29
0.0064 30
0.0064 31
0.0064 32
0.0064 33
0.0064 34
0.0064 35
0.0064 36
0.0064 37
0.0064 38
0.0064 39
0.0064 40
0.0064 41
0.0064 42
0.0064 43
0.0064 44
0.0064 45
0.0064 46
0.0064 47
0.0064 48
0.0064 49
0.0064 50
0.0064 51
0.0064 52
0.0064 53
0.0064 54
0.0064 55
0.0064 56
0.0064 57
0.0064 58
0.0064 59
0.0064 60
0.0064 61
0.0064 62
0.0064 63
0.0064 64
0.0064 65
0.0064 66
0.0064 67
3.6864 68
0.0064 69
0.0064 70
0.8464 71
0.0064 72
0.0064 73
0.0064 74
0.0064 75
Question 5 x-mean (x-mean)^2
3 0.080 0.006 HS= 4
3 0.080 0.006 LS= 1
3 0.080 0.006
1 -1.920 3.686 Range= 3
1 -1.920 3.686
3 0.080 0.006 n= 75
1 -1.920 3.686
1 -1.920 3.686 Mean= 2.920 SUM=
4 1.080 1.166
3 0.080 0.006 Variance= 1.291
3 0.080 0.006 SD= 1.136
4 1.080 1.166
4 1.080 1.166 Variance= 1.291
3 0.080 0.006 SD= 1.136
1 -1.920 3.686
3 0.080 0.006
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
1 -1.920 3.686
3 0.080 0.006
4 1.080 1.166
2 -0.920 0.846
4 1.080 1.166
2 -0.920 0.846
4 1.080 1.166
1 -1.920 3.686
3 0.080 0.006
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
2 -0.920 0.846
2 -0.920 0.846
4 1.080 1.166
3 0.080 0.006
4 1.080 1.166
1 -1.920 3.686
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
2 -0.920 0.846
1 -1.920 3.686
1 -1.920 3.686
1 -1.920 3.686
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
4 1.080 1.166
3 0.080 0.006
3 0.080 0.006
4 1.080 1.166
4 1.080 1.166
1 -1.920 3.686
4 1.080 1.166
1 -1.920 3.686
3 0.080 0.006
3 0.080 0.006
4 1.080 1.166
4 1.080 1.166
3 0.080 0.006
4 1.080 1.166
2 -0.920 0.846
3 0.080 0.006
3 0.080 0.006
2 -0.920 0.846
3 0.080 0.006
1 -1.920 3.686
4 1.080 1.166
3 0.080 0.006
4 1.080 1.166
3 0.080 0.006
2 -0.920 0.846
2 -0.920 0.846
Respondents Question 6 x-mean (x-mean)^2
1 2 0.000 0.000 HS=
2 2 0.000 0.000 LS=
3 2 0.000 0.000
4 2 0.000 0.000 Range=
5 2 0.000 0.000
6 2 0.000 0.000 n=
7 2 0.000 0.000
95.520 8 2 0.000 0.000 Mean=
9 2 0.000 0.000
10 2 0.000 0.000 Variance=
11 2 0.000 0.000 SD=
12 2 0.000 0.000
13 2 0.000 0.000 Variance=
14 2 0.000 0.000 SD=
15 2 0.000 0.000
16 1 -1.000 1.000
17 2 0.000 0.000
18 2 0.000 0.000
19 2 0.000 0.000
20 2 0.000 0.000
21 2 0.000 0.000
22 2 0.000 0.000
23 2 0.000 0.000
24 2 0.000 0.000
25 2 0.000 0.000
26 2 0.000 0.000
27 2 0.000 0.000
28 2 0.000 0.000
29 2 0.000 0.000
30 2 0.000 0.000
31 2 0.000 0.000
32 2 0.000 0.000
33 2 0.000 0.000
34 2 0.000 0.000
35 2 0.000 0.000
36 3 1.000 1.000
37 2 0.000 0.000
38 2 0.000 0.000
39 2 0.000 0.000
40 2 0.000 0.000
41 2 0.000 0.000
42 2 0.000 0.000
43 2 0.000 0.000
44 2 0.000 0.000
45 2 0.000 0.000
46 2 0.000 0.000
47 4 2.000 4.000
48 2 0.000 0.000
49 2 0.000 0.000
50 2 0.000 0.000
51 2 0.000 0.000
52 2 0.000 0.000
53 2 0.000 0.000
54 2 0.000 0.000
55 2 0.000 0.000
56 2 0.000 0.000
57 2 0.000 0.000
58 2 0.000 0.000
59 2 0.000 0.000
60 2 0.000 0.000
61 2 0.000 0.000
62 2 0.000 0.000
63 1 -1.000 1.000
64 2 0.000 0.000
65 2 0.000 0.000
66 2 0.000 0.000
67 2 0.000 0.000
68 2 0.000 0.000
69 2 0.000 0.000
70 1 -1.000 1.000
71 2 0.000 0.000
72 2 0.000 0.000
73 2 0.000 0.000
74 2 0.000 0.000
75 2 0.000 0.000
Respondents Question 7 x-mean
4 1 2 0.000
1 2 2 0.000
3 2 0.000
3 4 3 1.000
5 2 0.000
75 6 2 0.000
7 2 0.000
2.000 SUM= 8.000 8 2 0.000
9 2 0.000
0.108 10 2 0.000
0.329 11 2 0.000
12 2 0.000
0.108 13 2 0.000
0.329 14 2 0.000
15 2 0.000
16 2 0.000
17 2 0.000
18 2 0.000
19 2 0.000
20 2 0.000
21 2 0.000
22 2 0.000
23 1 -1.000
24 2 0.000
25 2 0.000
26 2 0.000
27 2 0.000
28 2 0.000
29 1 -1.000
30 2 0.000
31 2 0.000
32 2 0.000
33 1 -1.000
34 2 0.000
35 2 0.000
36 3 1.000
37 2 0.000
38 1 -1.000
39 2 0.000
40 2 0.000
41 2 0.000
42 2 0.000
43 2 0.000
44 2 0.000
45 2 0.000
46 2 0.000
47 2 0.000
48 2 0.000
49 2 0.000
50 2 0.000
51 2 0.000
52 2 0.000
53 2 0.000
54 2 0.000
55 2 0.000
56 2 0.000
57 2 0.000
58 2 0.000
59 3 1.000
60 2 0.000
61 2 0.000
62 2 0.000
63 2 0.000
64 2 0.000
65 2 0.000
66 1 -1.000
67 2 0.000
68 2 0.000
69 2 0.000
70 2 0.000
71 2 0.000
72 3 1.000
73 3 1.000
74 2 0.000
75 2 0.000
(x-mean)^2 Respondents
0.000 HS= 3 1
0.000 LS= 1 2
0.000 3
1.000 Range= 2 4
0.000 5
0.000 n= 75 6
0.000 7
0.000 Mean= 2.000 SUM= 10.000 8
0.000 9
0.000 Variance= 0.135 10
0.000 SD= 0.368 11
0.000 12
0.000 Variance= 0.135 13
0.000 SD= 0.368 14
0.000 15
0.000 16
0.000 17
0.000 18
0.000 19
0.000 20
0.000 21
0.000 22
1.000 23
0.000 24
0.000 25
0.000 26
0.000 27
0.000 28
1.000 29
0.000 30
0.000 31
0.000 32
1.000 33
0.000 34
0.000 35
1.000 36
0.000 37
1.000 38
0.000 39
0.000 40
0.000 41
0.000 42
0.000 43
0.000 44
0.000 45
0.000 46
0.000 47
0.000 48
0.000 49
0.000 50
0.000 51
0.000 52
0.000 53
0.000 54
0.000 55
0.000 56
0.000 57
0.000 58
1.000 59
0.000 60
0.000 61
0.000 62
0.000 63
0.000 64
0.000 65
1.000 66
0.000 67
0.000 68
0.000 69
0.000 70
0.000 71
1.000 72
1.000 73
0.000 74
0.000 75
Question 8 x-mean (x-mean)^2
2 -0.227 0.051 HS= 4
2 -0.227 0.051 LS= 1
2 -0.227 0.051
2 -0.227 0.051 Range= 3
2 -0.227 0.051
2 -0.227 0.051 n= 75
1 -1.227 1.505
1 -1.227 1.505 Mean= 2.227 SUM=
2 -0.227 0.051
3 0.773 0.598 Variance= 0.826
2 -0.227 0.051 SD= 0.909
1 -1.227 1.505
4 1.773 3.145 Variance= 0.826
2 -0.227 0.051 SD= 0.909
3 0.773 0.598
3 0.773 0.598
3 0.773 0.598
2 -0.227 0.051
2 -0.227 0.051
3 0.773 0.598
2 -0.227 0.051
3 0.773 0.598
1 -1.227 1.505
1 -1.227 1.505
2 -0.227 0.051
2 -0.227 0.051
2 -0.227 0.051
3 0.773 0.598
4 1.773 3.145
1 -1.227 1.505
2 -0.227 0.051
3 0.773 0.598
3 0.773 0.598
1 -1.227 1.505
3 0.773 0.598
2 -0.227 0.051
3 0.773 0.598
3 0.773 0.598
1 -1.227 1.505
3 0.773 0.598
1 -1.227 1.505
3 0.773 0.598
2 -0.227 0.051
3 0.773 0.598
3 0.773 0.598
2 -0.227 0.051
1 -1.227 1.505
3 0.773 0.598
2 -0.227 0.051
4 1.773 3.145
2 -0.227 0.051
2 -0.227 0.051
1 -1.227 1.505
1 -1.227 1.505
1 -1.227 1.505
1 -1.227 1.505
2 -0.227 0.051
2 -0.227 0.051
3 0.773 0.598
2 -0.227 0.051
2 -0.227 0.051
1 -1.227 1.505
2 -0.227 0.051
3 0.773 0.598
3 0.773 0.598
1 -1.227 1.505
3 0.773 0.598
3 0.773 0.598
1 -1.227 1.505
2 -0.227 0.051
1 -1.227 1.505
4 1.773 3.145
3 0.773 0.598
4 1.773 3.145
4 1.773 3.145
Respondents Question 9 x-mean (x-mean)^2
1 1 -0.133 0.018 HS=
2 1 -0.133 0.018 LS=
3 1 -0.133 0.018
4 1 -0.133 0.018 Range=
5 1 -0.133 0.018
6 1 -0.133 0.018 n=
7 1 -0.133 0.018
61.147 8 2 0.867 0.751 Mean=
9 1 -0.133 0.018
10 1 -0.133 0.018 Variance=
11 1 -0.133 0.018 SD=
12 1 -0.133 0.018
13 1 -0.133 0.018 Variance=
14 1 -0.133 0.018 SD=
15 1 -0.133 0.018
16 1 -0.133 0.018
17 1 -0.133 0.018
18 1 -0.133 0.018
19 1 -0.133 0.018
20 1 -0.133 0.018
21 1 -0.133 0.018
22 1 -0.133 0.018
23 1 -0.133 0.018
24 1 -0.133 0.018
25 2 0.867 0.751
26 1 -0.133 0.018
27 1 -0.133 0.018
28 2 0.867 0.751
29 1 -0.133 0.018
30 1 -0.133 0.018
31 1 -0.133 0.018
32 1 -0.133 0.018
33 1 -0.133 0.018
34 1 -0.133 0.018
35 1 -0.133 0.018
36 1 -0.133 0.018
37 1 -0.133 0.018
38 1 -0.133 0.018
39 1 -0.133 0.018
40 2 0.867 0.751
41 1 -0.133 0.018
42 1 -0.133 0.018
43 1 -0.133 0.018
44 3 1.867 3.484
45 2 0.867 0.751
46 1 -0.133 0.018
47 1 -0.133 0.018
48 1 -0.133 0.018
49 3 1.867 3.484
50 1 -0.133 0.018
51 1 -0.133 0.018
52 1 -0.133 0.018
53 1 -0.133 0.018
54 1 -0.133 0.018
55 1 -0.133 0.018
56 1 -0.133 0.018
57 1 -0.133 0.018
58 2 0.867 0.751
59 1 -0.133 0.018
60 1 -0.133 0.018
61 1 -0.133 0.018
62 1 -0.133 0.018
63 1 -0.133 0.018
64 1 -0.133 0.018
65 1 -0.133 0.018
66 1 -0.133 0.018
67 1 -0.133 0.018
68 1 -0.133 0.018
69 1 -0.133 0.018
70 1 -0.133 0.018
71 1 -0.133 0.018
72 1 -0.133 0.018
73 1 -0.133 0.018
74 1 -0.133 0.018
75 1 -0.133 0.018
Respondents Question 10 x-mean
3 1 2 0.573
1 2 3 1.573
3 1 -0.427
2 4 1 -0.427
5 1 -0.427
75 6 1 -0.427
7 1 -0.427
1.133 SUM= 12.667 8 1 -0.427
9 1 -0.427
0.171 10 1 -0.427
0.414 11 1 -0.427
12 3 1.573
0.171 13 1 -0.427
0.414 14 1 -0.427
15 1 -0.427
16 1 -0.427
17 1 -0.427
18 2 0.573
19 1 -0.427
20 1 -0.427
21 1 -0.427
22 1 -0.427
23 1 -0.427
24 4 2.573
25 1 -0.427
26 1 -0.427
27 1 -0.427
28 2 0.573
29 2 0.573
30 1 -0.427
31 1 -0.427
32 1 -0.427
33 1 -0.427
34 1 -0.427
35 1 -0.427
36 3 1.573
37 1 -0.427
38 1 -0.427
39 3 1.573
40 1 -0.427
41 3 1.573
42 1 -0.427
43 1 -0.427
44 3 1.573
45 1 -0.427
46 1 -0.427
47 1 -0.427
48 4 2.573
49 2 0.573
50 1 -0.427
51 1 -0.427
52 1 -0.427
53 1 -0.427
54 2 0.573
55 1 -0.427
56 1 -0.427
57 1 -0.427
58 3 1.573
59 1 -0.427
60 2 0.573
61 1 -0.427
62 1 -0.427
63 2 0.573
64 1 -0.427
65 1 -0.427
66 1 -0.427
67 1 -0.427
68 1 -0.427
69 1 -0.427
70 1 -0.427
71 1 -0.427
72 1 -0.427
73 1 -0.427
74 3 1.573
75 3 1.573
(x-mean)^2 Respondents
0.329 HS= 4 1
2.475 LS= 1 2
0.182 3
0.182 Range= 3 4
0.182 5
0.182 n= 75 6
0.182 7
0.182 Mean= 1.427 SUM= 48.347 8
0.182 9
0.182 Variance= 0.653 10
0.182 SD= 0.808 11
2.475 12
0.182 Variance= 0.653 13
0.182 SD= 0.808 14
0.182 15
0.182 16
0.182 17
0.329 18
0.182 19
0.182 20
0.182 21
0.182 22
0.182 23
6.622 24
0.182 25
0.182 26
0.182 27
0.329 28
0.329 29
0.182 30
0.182 31
0.182 32
0.182 33
0.182 34
0.182 35
2.475 36
0.182 37
0.182 38
2.475 39
0.182 40
2.475 41
0.182 42
0.182 43
2.475 44
0.182 45
0.182 46
0.182 47
6.622 48
0.329 49
0.182 50
0.182 51
0.182 52
0.182 53
0.329 54
0.182 55
0.182 56
0.182 57
2.475 58
0.182 59
0.329 60
0.182 61
0.182 62
0.329 63
0.182 64
0.182 65
0.182 66
0.182 67
0.182 68
0.182 69
0.182 70
0.182 71
0.182 72
0.182 73
2.475 74
2.475 75
Question 11 x-mean (x-mean)^2
3 0.093 0.009 HS= 4
2 -0.907 0.822 LS= 1
4 1.093 1.195
2 -0.907 0.822 Range= 3
4 1.093 1.195
4 1.093 1.195 n= 75
4 1.093 1.195
2 -0.907 0.822 Mean= 2.907 SUM=
4 1.093 1.195
3 0.093 0.009 Variance= 1.059
4 1.093 1.195 SD= 1.029
4 1.093 1.195
1 -1.907 3.635 Variance= 1.059
2 -0.907 0.822 SD= 1.029
4 1.093 1.195
2 -0.907 0.822
4 1.093 1.195
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
2 -0.907 0.822
1 -1.907 3.635
2 -0.907 0.822
4 1.093 1.195
3 0.093 0.009
2 -0.907 0.822
4 1.093 1.195
2 -0.907 0.822
4 1.093 1.195
2 -0.907 0.822
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
3 0.093 0.009
4 1.093 1.195
2 -0.907 0.822
3 0.093 0.009
2 -0.907 0.822
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
1 -1.907 3.635
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
2 -0.907 0.822
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
4 1.093 1.195
Respondents Question 12 x-mean (x-mean)^2
1 3 0.907 0.822 HS=
2 2 -0.093 0.009 LS=
3 4 1.907 3.635
4 1 -1.093 1.195 Range=
5 3 0.907 0.822
6 3 0.907 0.822 n=
7 4 1.907 3.635
78.347 8 1 -1.093 1.195 Mean=
9 3 0.907 0.822
10 3 0.907 0.822 Variance=
11 3 0.907 0.822 SD=
12 3 0.907 0.822
13 1 -1.093 1.195 Variance=
14 1 -1.093 1.195 SD=
15 2 -0.093 0.009
16 2 -0.093 0.009
17 3 0.907 0.822
18 1 -1.093 1.195
19 4 1.907 3.635
20 3 0.907 0.822
21 1 -1.093 1.195
22 1 -1.093 1.195
23 3 0.907 0.822
24 2 -0.093 0.009
25 4 1.907 3.635
26 3 0.907 0.822
27 1 -1.093 1.195
28 1 -1.093 1.195
29 1 -1.093 1.195
30 1 -1.093 1.195
31 4 1.907 3.635
32 1 -1.093 1.195
33 4 1.907 3.635
34 1 -1.093 1.195
35 1 -1.093 1.195
36 2 -0.093 0.009
37 2 -0.093 0.009
38 1 -1.093 1.195
39 3 0.907 0.822
40 4 1.907 3.635
41 1 -1.093 1.195
42 2 -0.093 0.009
43 3 0.907 0.822
44 1 -1.093 1.195
45 1 -1.093 1.195
46 1 -1.093 1.195
47 4 1.907 3.635
48 3 0.907 0.822
49 1 -1.093 1.195
50 1 -1.093 1.195
51 1 -1.093 1.195
52 4 1.907 3.635
53 2 -0.093 0.009
54 2 -0.093 0.009
55 4 1.907 3.635
56 4 1.907 3.635
57 1 -1.093 1.195
58 2 -0.093 0.009
59 2 -0.093 0.009
60 3 0.907 0.822
61 2 -0.093 0.009
62 1 -1.093 1.195
63 4 1.907 3.635
64 2 -0.093 0.009
65 1 -1.093 1.195
66 1 -1.093 1.195
67 1 -1.093 1.195
68 1 -1.093 1.195
69 2 -0.093 0.009
70 1 -1.093 1.195
71 1 -1.093 1.195
72 1 -1.093 1.195
73 1 -1.093 1.195
74 2 -0.093 0.009
75 2 -0.093 0.009
Respondents Question 13 x-mean
4 1 3 1.187
1 2 1 -0.813
3 1 -0.813
3 4 1 -0.813
5 3 1.187
75 6 1 -0.813
7 1 -0.813
2.093 SUM= 94.347 8 1 -0.813
9 1 -0.813
1.275 10 3 1.187
1.129 11 3 1.187
12 3 1.187
1.275 13 1 -0.813
1.129 14 1 -0.813
15 2 0.187
16 3 1.187
17 1 -0.813
18 1 -0.813
19 1 -0.813
20 2 0.187
21 1 -0.813
22 1 -0.813
23 3 1.187
24 1 -0.813
25 1 -0.813
26 1 -0.813
27 3 1.187
28 3 1.187
29 1 -0.813
30 1 -0.813
31 1 -0.813
32 3 1.187
33 3 1.187
34 3 1.187
35 1 -0.813
36 3 1.187
37 1 -0.813
38 3 1.187
39 1 -0.813
40 3 1.187
41 1 -0.813
42 1 -0.813
43 3 1.187
44 1 -0.813
45 1 -0.813
46 3 1.187
47 1 -0.813
48 3 1.187
49 1 -0.813
50 1 -0.813
51 1 -0.813
52 3 1.187
53 3 1.187
54 3 1.187
55 1 -0.813
56 3 1.187
57 1 -0.813
58 3 1.187
59 1 -0.813
60 1 -0.813
61 3 1.187
62 3 1.187
63 3 1.187
64 1 -0.813
65 1 -0.813
66 1 -0.813
67 2 0.187
68 1 -0.813
69 1 -0.813
70 1 -0.813
71 3 1.187
72 3 1.187
73 3 1.187
74 1 -0.813
75 1 -0.813
(x-mean)^2 Respondents
1.408 HS= 3 1
0.662 LS= 1 2
0.662 3
0.662 Range= 2 4
1.408 5
0.662 n= 75 6
0.662 7
0.662 Mean= 1.813 SUM= 69.387 8
0.662 9
1.408 Variance= 0.938 10
1.408 SD= 0.968 11
1.408 12
0.662 Variance= 0.938 13
0.662 SD= 0.968 14
0.035 15
1.408 16
0.662 17
0.662 18
0.662 19
0.035 20
0.662 21
0.662 22
1.408 23
0.662 24
0.662 25
0.662 26
1.408 27
1.408 28
0.662 29
0.662 30
0.662 31
1.408 32
1.408 33
1.408 34
0.662 35
1.408 36
0.662 37
1.408 38
0.662 39
1.408 40
0.662 41
0.662 42
1.408 43
0.662 44
0.662 45
1.408 46
0.662 47
1.408 48
0.662 49
0.662 50
0.662 51
1.408 52
1.408 53
1.408 54
0.662 55
1.408 56
0.662 57
1.408 58
0.662 59
0.662 60
1.408 61
1.408 62
1.408 63
0.662 64
0.662 65
0.662 66
0.035 67
0.662 68
0.662 69
0.662 70
1.408 71
1.408 72
1.408 73
0.662 74
0.662 75
Question 14 x-mean (x-mean)^2
4 0.547 0.299 HS= 4
4 0.547 0.299 LS= 1
4 0.547 0.299
4 0.547 0.299 Range= 3
4 0.547 0.299
3 -0.453 0.206 n= 75
4 0.547 0.299
2 -1.453 2.112 Mean= 3.453 SUM=
3 -0.453 0.206
4 0.547 0.299 Variance= 0.684
3 -0.453 0.206 SD= 0.827
4 0.547 0.299
4 0.547 0.299 Variance= 0.684
3 -0.453 0.206 SD= 0.827
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
3 -0.453 0.206
4 0.547 0.299
3 -0.453 0.206
1 -2.453 6.019
4 0.547 0.299
3 -0.453 0.206
3 -0.453 0.206
3 -0.453 0.206
2 -1.453 2.112
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
4 0.547 0.299
3 -0.453 0.206
1 -2.453 6.019
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
2 -1.453 2.112
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
1 -2.453 6.019
3 -0.453 0.206
3 -0.453 0.206
4 0.547 0.299
3 -0.453 0.206
2 -1.453 2.112
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
1 -2.453 6.019
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
3 -0.453 0.206
4 0.547 0.299
4 0.547 0.299
4 0.547 0.299
Respondents Question 15 x-mean (x-mean)^2
1 2 0.013 0.000
2 2 0.013 0.000
3 2 0.013 0.000
4 2 0.013 0.000
5 2 0.013 0.000
6 2 0.013 0.000
7 2 0.013 0.000
50.587 8 2 0.013 0.000
9 2 0.013 0.000
10 2 0.013 0.000
11 2 0.013 0.000
12 2 0.013 0.000
13 2 0.013 0.000
14 2 0.013 0.000
15 2 0.013 0.000
16 2 0.013 0.000
17 2 0.013 0.000
18 2 0.013 0.000
19 2 0.013 0.000
20 2 0.013 0.000
21 2 0.013 0.000
22 2 0.013 0.000
23 2 0.013 0.000
24 2 0.013 0.000
25 2 0.013 0.000
26 2 0.013 0.000
27 2 0.013 0.000
28 2 0.013 0.000
29 2 0.013 0.000
30 2 0.013 0.000
31 2 0.013 0.000
32 2 0.013 0.000
33 2 0.013 0.000
34 2 0.013 0.000
35 2 0.013 0.000
36 2 0.013 0.000
37 2 0.013 0.000
38 2 0.013 0.000
39 2 0.013 0.000
40 1 -0.987 0.974
41 2 0.013 0.000
42 2 0.013 0.000
43 2 0.013 0.000
44 2 0.013 0.000
45 2 0.013 0.000
46 2 0.013 0.000
47 2 0.013 0.000
48 2 0.013 0.000
49 2 0.013 0.000
50 2 0.013 0.000
51 2 0.013 0.000
52 2 0.013 0.000
53 2 0.013 0.000
54 2 0.013 0.000
55 2 0.013 0.000
56 2 0.013 0.000
57 2 0.013 0.000
58 2 0.013 0.000
59 2 0.013 0.000
60 2 0.013 0.000
61 2 0.013 0.000
62 2 0.013 0.000
63 2 0.013 0.000
64 2 0.013 0.000
65 2 0.013 0.000
66 2 0.013 0.000
67 2 0.013 0.000
68 2 0.013 0.000
69 2 0.013 0.000
70 2 0.013 0.000
71 2 0.013 0.000
72 2 0.013 0.000
73 2 0.013 0.000
74 2 0.013 0.000
75 2 0.013 0.000
x-mean)^2
HS= 2
LS= 1

Range= 1

n= 75

Mean= 1.987 SUM= 0.987

Variance= 0.013
SD= 0.115

Variance= 0.013
SD= 0.115

You might also like