Communication Audit Project
myfrst
Surveyinformation1.xlsx
Sheet1
| Questions | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8 | Person 9 | Person 10 | Average |
| 1 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 4.8 |
| 2 | 4 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4 | 4.7 | Total Point |
| 3 | 4 | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 4.7 | 32.8 | 32 out of 35 |
| 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 5 | 4.8 | Average |
| 5 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4.8 | 4.7 |
| 6 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 4.8 | Lowest Score |
| 7 | 5 | 5 | 5 | 4 | 5 | 3 | 5 | 4 | 5 | 4 | 4.5 | 4.5 |
| 8 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 4.9 | Total Point |
| 9 | 4 | 5 | 5 | 5 | 4 | 4 | 5 | 5 | 5 | 4 | 4.6 | 26 | 26/35 |
| 10 | 2 | 2 | 2 | 2 | 1 | 3 | 1 | 2 | 2 | 2 | 1.9 | Average |
| 11 | 3 | 3 | 2 | 3 | 2 | 3 | 1 | 2 | 2 | 2 | 2.3 | 3.71 |
| 12 | 3 | 3 | 3 | 3 | 3 | 1 | 1 | 1 | 2 | 2 | 2.2 | Lowest Score |
| 13 | 4 | 5 | 5 | 5 | 5 | 5 | 3 | 4 | 5 | 5 | 4.6 | 1.9 |
| 14 | 4 | 3 | 3 | 3 | 3 | 4 | 3 | 3 | 2 | 4 | 3.2 |
| 15 | 5 | 4 | 4 | 4 | 3 | 2 | 2 | 2 | 4 | 3 | 3.3 | Total Point |
| 16 | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 4 | 4 | 4 | 3.8 | 32.5 | 32/45 |
| 17 | 3 | 3 | 3 | 3 | 3 | 4 | 5 | 3 | 3 | 4 | 3.4 | Average |
| 18 | 5 | 5 | 5 | 3 | 4 | 5 | 5 | 3 | 4 | 4 | 4.3 | 3.611 |
| 19 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 4 | 3 | 3 | 4.4 | Lowest Score |
| 20 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 4 | 5 | 5 | 3.6 | 3.1 |
| 21 | 1 | 4 | 1 | 4 | 4 | 1 | 1 | 3 | 4 | 2 | 2.5 |
| 22 | 3 | 3 | 5 | 5 | 5 | 5 | 3 | 5 | 4 | 3 | 4.1 |
| 23 | 3 | 2 | 3 | 2 | 5 | 4 | 3 | 2 | 4 | 3 | 3.1 |
| 24 | 2 | 1 | 3 | 1 | 3 | 5 | 4 | 4 | 4 | 4 | 3.1 | Total Point |
| 25 | 3 | 2 | 3 | 2 | 4 | 4 | 4 | 3 | 4 | 4 | 3.3 | 18.6 | 19/30 |
| 26 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 4.1 | Average |
| 27 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 3 | 3.2 | 3.1 |
| 28 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 2 | 1.6 | Lowest Score |
| 29 | 4 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 3.5 | 1.6 |
| 30 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3.9 | Total Point |
| 31 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3.8 | 23.6 | 24/40 |
| 32 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Average |
| 33 | 1 | 1 | 1 | 1 | 2 | 1 | 2 | 1 | 2 | 2 | 1.4 | 2.95 |
| 34 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2.5 | Lowest Score |
| 35 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 2 | 2.2 | 1.4 |
| 36 | 4 | 4 | 3 | 4 | 4 | 3 | 3 | 4 | 3 | 3 | 3.5 |
| 37 | 1 | 2 | 2 | 3 | 2 | 2 | 3 | 2 | 3 | 2 | 2.2 |
| Total Score | 125 | 128 | 131 | 130 | 137 | 135 | 127 | 129 | 140 | 134 | 131.6 |
