I have a question on regression analysis.
Let's assume I have a set of data on each horse for over 1000 races. I want to know how to weight each of these factors to produce the most likely winner.
Let's say I want to use 5 factors to help predict the outcome
1. Speed Figure Last Race
2. Class Figure Last Race
3. Finish Position Last Race
4. Lengths Behind at Finish Last Race
5. Winning Margin Last Race (if the horse won)
I want to use those 5 factors to predict the finish position in today race (which I also have in my data along with Date, Track, and Race).
I've seen some very basic regression analysis done in Excel, but one thing I don't understand is how to make the analysis recognize that each race is it's own unit/group.
It has to understand that a 70 speed figure in one race might have been the top figure in one race and lead to a win but in another race that 70 speed figure may have been the worst speed figure and lead to a 9th.
__________________
"Unlearning is the highest form of learning"
|