Statistics Help Please
- Thread starter Sameira
- Start date
Have a play with excel, you should be able to do it in there
right looking at that chart...
clerical staff is right .... 100 % = 360 Degrees so if you divide 360 by 100 and multiply by 35 % you get 126 Deg
Programmers is wrong percentage.. if 140 people = 35 % then 1 % = 140 divided by 35 = 4 people
so there are 40 programmers so 40 divided by 4 = 10 % so again divide 126 by 35 and multiply by 10 = 30 degrees
system analysts = 18 % times 4 (number of people for 1 %) = 72
now divide 126 by 35 and multiply by 18
Technicians = 120 .... if 4 people = 1 % then divide 120 by 4 = 30 %
angle = 126 divided by 35 multiplied by 30 = 109 degrees
lastly web designers.... now we know the whole must be 100 percent so...
100 - (30 % technicians + 35 % clerical staff + 10 % programmers + 18 system analysts ) = 7 %
since 1 % = 4 people 7 % times 4 = 28 web designers...
now 126 divided by 35 multiplied by 7 % = 25.2 degrees
now to prove the answer add up all the angles and it should = 360
and it does
types of personnel number angle percentage
technicians 120 108 30
clerical staff 140 126 35
web designer 28 25.2 7
programmers 40 36 10
system analysts 72 64.8 18
total 360 deg 100 %
hope this helps
regards
Taff
clerical staff is right .... 100 % = 360 Degrees so if you divide 360 by 100 and multiply by 35 % you get 126 Deg
Programmers is wrong percentage.. if 140 people = 35 % then 1 % = 140 divided by 35 = 4 people
so there are 40 programmers so 40 divided by 4 = 10 % so again divide 126 by 35 and multiply by 10 = 30 degrees
system analysts = 18 % times 4 (number of people for 1 %) = 72
now divide 126 by 35 and multiply by 18
Technicians = 120 .... if 4 people = 1 % then divide 120 by 4 = 30 %
angle = 126 divided by 35 multiplied by 30 = 109 degrees
lastly web designers.... now we know the whole must be 100 percent so...
100 - (30 % technicians + 35 % clerical staff + 10 % programmers + 18 system analysts ) = 7 %
since 1 % = 4 people 7 % times 4 = 28 web designers...
now 126 divided by 35 multiplied by 7 % = 25.2 degrees
now to prove the answer add up all the angles and it should = 360
and it does
types of personnel number angle percentage
technicians 120 108 30
clerical staff 140 126 35
web designer 28 25.2 7
programmers 40 36 10
system analysts 72 64.8 18
total 360 deg 100 %
hope this helps
regards
Taff
Spikeman
Inactive User
Nice one taff - I just printed it out to have a play as well after finishing my daily Sudoku.
spiky
Inactive User
well done taff, spot on m8
