[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 80
  • Last Modified:

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
0
racepro
Asked:
racepro
1 Solution
 
d-glitchCommented:
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
 
raceproAuthor Commented:
Many thanks, it works a treat
Ian
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now