View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Leveling Methods

Build,

If you multiply all scores with the same coefficient only the absolute
magnitudes will change. Relative order as well as ratios between
scores will stay the same.

You can multiply with 1/maxscore to get numbers in [0,1]

HTH
Kostis Vezerides

On Oct 11, 3:26 am, "build" wrote:
G'day All,
This is not really excel related so please excuse the off topic subject.
I did a google but media commentry dominate the results unfortunately.

I want to level the scores of 22 players or reduce the difference between
the top and bottom score but still reflect parity of scores. Hmmm, not
worded well? Hope someone sees what I'm getting at.

Thanking you in anticipation,
build