Spreadsheet: 297723d1392557036-how-to-calculate-the-covariance-for-my-excel-file-appendix-2_survey-result_minitab
Sheet: Sheet1

No. | Q1 | Q2 | Q3 | Q4 | Q5 | Ave |  | Q1 | Q2 | Q3 | Q4 | Q5 | Ave |  | Q1 | Q2 | Q3 | Q4 | Q5 | Ave |  | Q1
1 | 4 | 4 | 4 | 3 | 4 | 3.8 |  | 4 | 4 | 4 | 3 | 4 | 3.8 |  | 4 | 5 | 4 | 3 | 4 | 4 |  | 3
2 | 5 | 4 | 3 | 3 | 4 | 3.8 |  | 5 | 5 | 3 | 4 | 3 | 4 |  | 5 | 4 | 5 | 4 | 5 | 4.6 |  | 4
3 | 4 | 4 | 3 | 3 | 3 | 3.4 |  | 4 | 3 | 3 | 3 | 5 | 3.6 |  | 3 | 4 | 4 | 3 | 4 | 3.6 |  | 3
4 | 4 | 4 | 3 | 4 | 4 | 3.8 |  | 5 | 5 | 4 | 4 | 4 | 4.4 |  | 5 | 4 | 5 | 5 | 5 | 4.8 |  | 3
5 | 3 | 4 | 4 | 3 | 3 | 3.4 |  | 3 | 3 | 3 | 3 | 4 | 3.2 |  | 4 | 5 | 4 | 3 | 3 | 3.8 |  | 3
6 | 4 | 4 | 3 | 4 | 2 | 3.4 |  | 4 | 4 | 5 | 4 | 5 | 4.4 |  | 3 | 3 | 4 | 5 | 5 | 4 |  | 3
7 | 5 | 4 | 2 | 4 | 3 | 3.6 |  | 5 | 4 | 3 | 3 | 3 | 3.6 |  | 3 | 4 | 3 | 4 | 5 | 3.8 |  | 3
8 | 4 | 3 | 4 | 2 | 4 | 3.4 |  | 4 | 4 | 5 | 4 | 5 | 4.4 |  | 4 | 4 | 3 | 3 | 5 | 3.8 |  | 3
9 | 4 | 5 | 5 | 3 | 5 | 4.4 |  | 5 | 3 | 4 | 3 | 4 | 3.8 |  | 4 | 5 | 3 | 4 | 4 | 4 |  | 4
10 | 4 | 3 | 3 | 4 | 4 | 3.6 |  | 3 | 5 | 3 | 4 | 4 | 3.8 |  | 4 | 3 | 3 | 4 | 5 | 3.8 |  | 3
11 | 3 | 5 | 4 | 5 | 3 | 4 |  | 4 | 5 | 4 | 5 | 5 | 4.6 |  | 4 | 4 | 4 | 3 | 3 | 3.6 |  | 4
12 | 4 | 4 | 4 | 3 | 4 | 3.8 |  | 5 | 4 | 2 | 4 | 3 | 3.6 |  | 4 | 4 | 5 | 4 | 5 | 4.4 |  | 3
13 | 5 | 5 | 3 | 4 | 5 | 4.4 |  | 2 | 3 | 5 | 4 | 5 | 3.8 |  | 5 | 3 | 4 | 5 | 4 | 4.2 |  | 4
14 | 4 | 4 | 4 | 4 | 4 | 4 |  | 3 | 5 | 4 | 3 | 4 | 3.8 |  | 3 | 3 | 3 | 3 | 5 | 3.4 |  | 3
15 | 5 | 5 | 5 | 2 | 5 | 4.4 |  | 4 | 4 | 3 | 5 | 3 | 3.8 |  | 5 | 4 | 5 | 4 | 4 | 4.4 |  | 3
16 | 3 | 5 | 4 | 3 | 4 | 3.8 |  | 5 | 3 | 5 | 4 | 4 | 4.2 |  | 4 | 4 | 4 | 5 | 4 | 4.2 |  | 3
17 | 4 | 4 | 4 | 4 | 5 | 4.2 |  | 4 | 5 | 4 | 3 | 2 | 3.6 |  | 3 | 5 | 3 | 3 | 4 | 3.6 |  | 4
18 | 5 | 3 | 4 | 4 | 4 | 4 |  | 3 | 3 | 3 | 4 | 3 | 3.2 |  | 5 | 3 | 4 | 4 | 3 | 3.8 |  | 3
19 | 4 | 4 | 4 | 4 | 5 | 4.2 |  | 4 | 5 | 5 | 2 | 4 | 4 |  | 4 | 5 | 3 | 4 | 5 | 4.2 |  | 3
20 | 5 | 5 | 5 | 4 | 3 | 4.4 |  | 5 | 2 | 4 | 4 | 3 | 3.6 |  | 4 | 4 | 4 | 4 | 5 | 4.2 |  | 4
21 | 4 | 4 | 4 | 4 | 3 | 3.8 |  | 3 | 3 | 2 | 3 | 5 | 3.2 |  | 4 | 3 | 3 | 3 | 4 | 3.4 |  | 3
22 | 5 | 5 | 5 | 5 | 4 | 4.8 |  | 4 | 3 | 4 | 5 | 4 | 4 |  | 5 | 5 | 4 | 4 | 4 | 4.4 |  | 4
23 | 5 | 4 | 5 | 5 | 5 | 4.8 |  | 5 | 4 | 3 | 4 | 4 | 4 |  | 5 | 4 | 4 | 5 | 4 | 4.4 |  | 4
24 | 4 | 4 | 3 | 4 | 3 | 3.6 |  | 4 | 2 | 5 | 3 | 3 | 3.4 |  | 4 | 5 | 3 | 4 | 3 | 3.8 |  | 3
25 | 4 | 3 | 3 | 5 | 4 | 3.8 |  | 3 | 3 | 3 | 5 | 3 | 3.4 |  | 4 | 4 | 3 | 4 | 4 | 3.8 |  | 3
26 | 4 | 4 | 3 | 4 | 4 | 3.8 |  | 3 | 3 | 5 | 3 | 3 | 3.4 |  | 3 | 5 | 5 | 3 | 4 | 4 |  | 3
27 | 4 | 3 | 4 | 4 | 3 | 3.6 |  | 4 | 4 | 4 | 3 | 3 | 3.6 |  | 4 | 5 | 3 | 3 | 4 | 3.8 |  | 3
28 | 4 | 4 | 3 | 3 | 3 | 3.4 |  | 3 | 2 | 3 | 4 | 4 | 3.2 |  | 2 | 3 | 4 | 3 | 3 | 3 |  | 2
29 | 3 | 3 | 4 | 3 | 4 | 3.4 |  | 4 | 3 | 3 | 3 | 3 | 3.2 |  | 4 | 3 | 4 | 4 | 3 | 3.6 |  | 3
30 | 3 | 4 | 5 | 3 | 3 | 3.6 |  | 4 | 3 | 5 | 3 | 3 | 3.6 |  | 3 | 4 | 3 | 3 | 4 | 3.4 |  | 3
31 | 4 | 3 | 4 | 3 | 4 | 3.6 |  | 3 | 4 | 4 | 4 | 4 | 3.8 |  | 3 | 4 | 4 | 3 | 4 | 3.6 |  | 3
32 | 4 | 4 | 3 | 3 | 4 | 3.6 |  | 3 | 5 | 3 | 3 | 3 | 3.4 |  | 3 | 4 | 3 | 3 | 3 | 3.2 |  | 3
33 | 3 | 3 | 3 | 3 | 5 | 3.4 |  | 3 | 4 | 3 | 4 | 3 | 3.4 |  | 4 | 3 | 3 | 4 | 3 | 3.4 |  | 2
34 | 3 | 3 | 4 | 3 | 4 | 3.4 |  | 3 | 3 | 4 | 4 | 4 | 3.6 |  | 4 | 3 | 4 | 4 | 3 | 3.6 |  | 3
35 | 3 | 3 | 4 | 5 | 3 | 3.6 |  | 3 | 4 | 4 | 4 | 3 | 3.6 |  | 3 | 4 | 4 | 3 | 4 | 3.6 |  | 3
36 | 4 | 3 | 3 | 3 | 4 | 3.4 |  | 4 | 3 | 3 | 3 | 4 | 3.4 |  | 3 | 4 | 3 | 3 | 4 | 3.4 |  | 2
37 | 3 | 3 | 4 | 3 | 4 | 3.4 |  | 3 | 4 | 4 | 3 | 3 | 3.4 |  | 3 | 4 | 4 | 4 | 3 | 3.6 |  | 3
38 | 3 | 3 | 3 | 3 | 2 | 2.8 |  | 3 | 4 | 4 | 3 | 3 | 3.4 |  | 4 | 3 | 3 | 4 | 3 | 3.4 |  | 1
39 | 3 | 3 | 4 | 5 | 3 | 3.6 |  | 3 | 3 | 3 | 3 | 4 | 3.2 |  | 3 | 4 | 4 | 3 | 4 | 3.6 |  | 3
40 | 3 | 4 | 3 | 3 | 4 | 3.4 |  | 3 | 3 | 3 | 4 | 3 | 3.2 |  | 4 | 3 | 3 | 3 | 4 | 3.4 |  | 2
41 | 4 | 3 | 3 | 3 | 3 | 3.2 |  | 3 | 2 | 3 | 3 | 3 | 2.8 |  | 3 | 4 | 4 | 3 | 3 | 3.4 |  | 2
42 | 3 | 4 | 3 | 3 | 4 | 3.4 |  | 3 | 3 | 3 | 3 | 3 | 3 |  | 3 | 3 | 4 | 3 | 4 | 3.4 |  | 2
43 | 4 | 3 | 4 | 3 | 4 | 3.6 |  | 3 | 3 | 4 | 4 | 3 | 3.4 |  | 4 | 4 | 3 | 4 | 3 | 3.6 |  | 3
44 | 4 | 4 | 3 | 4 | 4 | 3.8 |  | 3 | 4 | 4 | 3 | 3 | 3.4 |  | 4 | 4 | 3 | 3 | 3 | 3.4 |  | 3
45 | 3 | 4 | 4 | 3 | 5 | 3.8 |  | 3 | 3 | 3 | 4 | 4 | 3.4 |  | 4 | 4 | 3 | 4 | 4 | 3.8 |  | 3
Ave | 3.866666666666667 | 3.8 | 3.688888888888889 | 3.555555555555555 | 3.8 | 3.742222222222222 |  | 3.644444444444444 | 3.577777777777778 | 3.666666666666667 | 3.577777777777778 | 3.6 | 3.613333333333334 |  | 3.777777777777778 | 4 | 3.666666666666667 | 3.644444444444444 | 3.911111111111111 | 3.782222222222223 |  | 3
Correl |  |  |  |  |  | 0.7792981856697088 |  |  |  |  |  |  | 0.5079670682147925 |  |  |  |  |  |  | 0.5577127403751861