ExcelRaceRatings
New Member
- Joined
- Jan 9, 2016
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hello all,
I am looking to produce a rating (number) for a horse based on it's previous race strength figures. In the below example the highest race strength is "19" but i want to be able to rate the horses based on Starting price (lowest to highest) and Last Start Margin ((lowest to highest). So a horse that started in a Race Strength "8" race at $3.20 and beaten 0.5 lengths should rate higher than a horse that started in a Race Strength "12" at $16 and beat 4.9 lengths.
Can any statistically minded people offer some advice on how this possible and the formulas required? Thanks in advance.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I am looking to produce a rating (number) for a horse based on it's previous race strength figures. In the below example the highest race strength is "19" but i want to be able to rate the horses based on Starting price (lowest to highest) and Last Start Margin ((lowest to highest). So a horse that started in a Race Strength "8" race at $3.20 and beaten 0.5 lengths should rate higher than a horse that started in a Race Strength "12" at $16 and beat 4.9 lengths.
Can any statistically minded people offer some advice on how this possible and the formulas required? Thanks in advance.
Race Strength | Starting Price | Last Start Margin |
8.00 | 3.2 | 0.5 |
19.00 | 41 | 6.7 |
18.00 | 26 | 3.9 |
7.00 | 6 | 1.5 |
2.90 | 2.25 | -0.4 |
3.00 | 2.9 | 1 |
13.00 | 11 | 7 |
12.00 | 16 | 4.9 |
7.00 | 4 | 0.8 |
10.00 | 26 | 12 |
12.00 | 51 | 8.9 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>