15 – Frequency Tables
Summarize your findings from each survey into this summary data table.
|
Respondent |
Knowledge |
Age |
Gender |
|
|
|
|
1 |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
3 |
|
|
|
|
|
|
|
4 |
|
|
|
|
|
|
|
5 |
|
|
|
|
|
|
|
6 |
|
|
|
|
|
|
|
7 |
|
|
|
|
|
|
|
8 |
|
|
|
|
|
|
To do this
Insert > Table 10 X 7
select boxes, right-click, then “merge cells”
|
|
Age |
||||||||
|
Young |
Middle |
Old |
Total |
||||||
|
f |
% |
f |
% |
f |
% |
F |
% |
||
|
Knowledge |
High
|
|
|
|
|
|
|
|
100 |
|
Medium
|
|
|
|
|
|
|
|
100 |
|
|
Low
|
|
|
|
|
|
|
|
100 |
|
|
Total
|
|
|
|
|
|
|
|
100 |
|