DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,659
- Office Version
- 365
- Platform
- Windows
DRSteele submitted a new Excel article:
Ranking with Tiebreakers - Using a new statsitic, we can rank performance by using cascading tiebreakers
Read more about this Excel article...
Ranking with Tiebreakers - Using a new statsitic, we can rank performance by using cascading tiebreakers
Using tiebreakers is frequently required in sports leagues and sales data to come up with winners and losers. We can use a clever trick to rank with tiebreakers, a process otherwise made difficult by the many conditions.
Here we have sales data for automobile salesmen, and we want to grant Christmas bonuses based on their performance. The first statistic we want to use to rank them is the Sales Level. If there is a tie in that statistic, we then want to rank the salesmen by the number of...
Read more about this Excel article...