Last time, I put together a spreadsheet that randomly generated ratings of eight different skills for 100,000 people (100,001 actually due to a mistake on my part). The idea behind this was to show how people can rank when you use favorable criteria for each individual. The more you take into consideration, the better people will look.
On my latest spreadsheet, which can be found at https://1drv.ms/x/s!Ar3VXpGA-24ugYJP8mMNgdgLzjYtTA, I have broken down some numbers. All of these reflect all 100,000 people. These numbers show how things change as you consider more skills and/or traits. These can be found on my Tables and Charts tab.
The first thing on this spreadsheet is a list of key stats. As we increase from one to eight skills, the maximum, average, and median rankings drop substantially. The number of people who are the best in some measure increases substantially.
You will also see a significant uptick in the number of individuals who could be considered to be above average. At just three skills considered, well over ninety percent can be considered above average by some measure. When you reach seven, there is only one outlier. At all eight skills, every person on this list of 100,000 has a way in which he or she can be considered above average.
Also in this section with its own chart is a breakdown of the worst person's ranking in terms of percentage. This is a variant of the max total, but it's displayed in a manner that can be better adjusted to different totals.
At the bottom of the sheet, I included a distribution chart. This shows how many people can be found ranking from 1-10,000, 10,001-20,000, and so on This should make it very clear that people can stand out better as you do more to consider their strengths and weaknesses.
No comments:
Post a Comment