
86 3: Data presentation ⏐ Part B Summarising and analysing data
1 Tables
1.1 Tables and tabulation
Tables are a simple way of presenting information about two variables.
Raw data (for example a list of results from a survey) need to be summarised and analysed, to give them
meaning. One of the most basic ways is the preparation of a table.
• Tabulation means putting data into tables.
• A table is a matrix of data in rows and columns, with the rows and the columns having titles.
Since a table is two-dimensional, it can only show two variables. To tabulate data, you need to recognise what the
two dimensions should represent, prepare rows and columns accordingly with suitable titles, and then insert the
data into the appropriate places in the table.
1.2 Example: Tables
The total number of employees in a certain trading company is 1,000. They are employed in three departments:
production, administration and sales. 600 people are employed in the production department and 300 in
administration. There are 110 males under 21 in employment, 110 females under 21, and 290 females aged 21
years and over. The remaining employees are males aged 21 and over.
In the production department there are 350 males aged 21 and over, 150 females aged 21 and over and 50 males
under 21, whilst in the administration department there are 100 males aged 21 and over, 110 females aged 21 and
over and 50 males aged under 21.
Draw up a table to show all the details of employment in the company and its departments and provide suitable
secondary statistics to describe the distribution of people in departments.
Solution
The basic table required has the following two dimensions.
• Departments
• Age/sex analysis
In this example we are going to show the percentage of the total workforce in each department.
Analysis of employees
Department
Production
Administration
Sales
Total
No
%
No
%
No
%
No
%
Males 21 yrs +
350
58.4
100
33.3
40 ** 40.0
490 *
49.0
Females 21 yrs +
150
25.0
110
36.7
30
** 30.0
290
29.0
Subtotals 21 yrs +
500
83.4
210
70.0
70
70.0
780
78.0
Males under 21
50
8.3
50
16.7
10 ** 10.0
110
11.0
Females under 21
50
*
8.3
40
*
13.3
20
**
20.0
110
11.0
Subtotals under 21
100
16.6
90
30.0
30
30.0
220
22.0
Total
600
100.0
300
100.0
100
100.0
1,000
100.0
* Balancing figure to make up the column total
** Balancing figure then needed to make up the row total
Key term
FA
T F
RWAR