Data Interpretation - Table Charts
The following table shows the number of new employees added to different categories of employees in a company and also the number of employees from these categories who left the company every year since the foundation of the Company in 1995.
Year | ||||||||||
Managers | Technicians | Operators | Accountants | Peons | ||||||
New | Left | New | Left | New | Left | New | Left | New | Left | |
1995 | 760 | - | 1200 | - | 880 | - | 1160 | - | 820 | - |
1996 | 280 | 120 | 272 | 120 | 256 | 104 | 200 | 100 | 184 | 96 |
1997 | 179 | 92 | 240 | 128 | 240 | 120 | 224 | 104 | 152 | 88 |
1998 | 148 | 88 | 236 | 96 | 208 | 100 | 248 | 96 | 196 | 80 |
1999 | 160 | 72 | 256 | 100 | 192 | 112 | 272 | 88 | 224 | 120 |
2000 | 193 | 96 | 288 | 112 | 248 | 144 | 260 | 92 | 200 | 104 |
Required difference
= (272 + 240 + 236 + 256 + 288) - (200 + 224 + 248 + 272 + 260)
= 88.
Total number of Peons working in the Company in 1999
= (820 + 184 + 152 + 196 + 224) - (96 + 88 + 80 + 120)
= 1192.
Number of Managers working in the Company:
In 1995 | = 760. |
In 2000 | = (760 + 280 + 179 + 148 + 160 + 193) - (120 + 92 + 88 + 72 + 96) |
= 1252. |
Percentage increase in the number of Managers
= | ![]() |
(1252 - 760) | x 100 | ![]() |
% = 64.74%. |
760 |
Number of Technicians working in the Company:
In 1995 | = 1200. |
In 2000 | = (1200 + 272 + 240 + 236 + 256 + 288) - (120 + 128 + 96 + 100 + 112) |
= 1936. |
Percentage increase in the number of Technicians
= | ![]() |
(1936 - 1200) | x 100 | ![]() |
% = 61.33%. |
1200 |
Number of Operators working in the Company:
In 1995 | = 880. |
In 2000 | = (880 + 256 + 240 + 208 + 192 + 248) - (104 + 120 + 100 + 112 + 144) |
= 1444. |
Percentage increase in the number of Operators
= | ![]() |
(1444 - 880) | x 100 | ![]() |
% = 64.09%. |
880 |
Number of Accountants working in the Company:
In 1995 | = 1160. |
In 2000 | = (1160 + 200 + 224 + 248 + 272 + 260) - (100 + 104 + 96 + 88 + 92) |
= 1884. |
Percentage increase in the number of Accountants
= | ![]() |
(1884 - 1160) | x 100 | ![]() |
% = 62.41%. |
1160 |
Number of Peons working in the Company:
In 1995 | = 820. |
In 2000 | = (820 + 184 + 152 + 196 + 224 + 200) - (96 + 88 + 80 + 120 + 104) |
= 1288. |
Percentage increase in the number of Peons
= | ![]() |
(1288 - 820) | x 100 | ![]() |
% = 57.07%. |
820 |
Clearly, the percentage increase is maximum in case of Managers.
Total number of employees of various categories working in the Company in 1997 are:
Managers | = (760 + 280 + 179) - (120 + 92) = 1007. |
Technicians | = (1200 + 272 + 240) - (120 + 128) = 1464. |
Operators | = (880 + 256 + 240) - (104 + 120) = 1152. |
Accountants | = (1160 + 200 + 224) - (100 + 104) = 1380. |
Peons | = (820 + 184 + 152) - (96 + 88) = 972. |
Pooled average of all the five categories of employees working in the Company in 1997
= | 1 | x (1007 + 1464 + 1152 + 1380 + 972) |
5 |
= | 1 | x (5975) |
5 |
= 1195.
Total number of Operators who left the Company during 1995 - 2000
= (104 + 120 + 100 + 112 + 144)
= 580.
Total number of Operators who joined the Company during 1995 - 2000
= (880 + 256 + 240 + 208 + 192 + 248)
= 2024.
![]() |
![]() |
580 | x 100 | ![]() |
% = 28.66% ![]() |
2024 |