Normalised finishing position

Hi,
I am trying to understand the below formula. It was given to me some time ago and no contact with giver.
NmFin : Normalised FP = ((N+1)-2x) / sqrt(3(N+1)(N-1))
It will be used in a horse race to determine a normalised finishing position for any race.
Suppose the following:
finish position = 5
Number of runners = 12
I'd like to convert for use in Excel, if you can help
Many Thanks
Ian
raceproretiredAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
d-glitchConnect With a Mentor Commented:
Sure.  Here is a table.
It looks like it makes maps average performance to zero.
It doesn't work for races with a single participant.
TableNormalized-for-ExEx.xlsx
0
 
raceproretiredAuthor Commented:
Many thanks, it works a treat
Ian
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.