Monday, January 6, 2020

Fun with Excel - Equality VII

I have created several spreadsheets with the purpose of showing how people appear more equal if we do more to take strengths and weaknesses into consideration. This time, I'm going to simplify things. I have created 100,000 records with two skills of random values. I then modified those values to ensure everyone is equal overall.


This spreadsheet can be found at: Equality VII.xlsx

Like my other spreadsheets, looking at just the first skill is unimpressive. Under this approach, you will have everyone with a unique rating from 1 to 100,000. I didn't bother including those ranks. If you look at both skills, there will be different ways to rate individuals. For example, if you highly value both skills until you reach an individual's skill level, then find higher levels rather meaningless, then that individual will rate highly. If you apply this approach variably to match each individual's levels, every single record will have a way to be considered the best.

I have calculated this type of ranking. For each record, I have included a rank based off the number of records with equal or higher values for both skills. Technically speaking, I shouldn't need to. The results are obvious. Every single record of the 100,000 returned a value of 1, indicating that there is a measure for each individual in which they could be considered the best.

My views on equality fits very well with individualism. We all have unique strengths and weaknesses. The more we consider, the more we move towards an overall average. When you consider the different ways in which we can evaluate an individual, what makes each and every one of us unique is insufficient to put one person above another. There are limitations to my views. I do not view Ghandi as equal to Hitler. Looking past these limits, it seems ridiculous to put one person above another just because of different strengths.

No comments:

Post a Comment