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

If what you want to do is to keep the average score the same but decrease the
range, for each player use a formula of =average+(old
score-average)*fraction
where fraction is a number less than one which gives you the range you want.

If this is not what you want, please give an example

"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

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

G'day,
Thank you both for your replies.
Your methods are both good.

However to explain my problem a little better. Let's say I have 22 players.
1 score of 3
11 between 13 to 19
8 between 20 to 30
2 at 41 and 52

I'd like to keep parity in the middle 2 bunches as these scores do reflect
the player performance very well.
However I'd like to bring closer the scores of 3, 41 and 52 as these do not
reflect player performance.
Ideally 3 would be say 9 and the others say 33 and 35, that would reflect
performance.

Any Ideas?
Thanking you in anticipation,
build

PS
I once posted here 10 or so years ago and I think either Chip or Thomas came
up with a brilliant answer, so I was hoping for a de-ja vu


"bj" wrote in message
...
If what you want to do is to keep the average score the same but decrease
the
range, for each player use a formula of
=average+(old score-average)*fraction
where fraction is a number less than one which gives you the range you
want.

If this is not what you want, please give an example

"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