The Excel Tips and Tricks thread - Pace and Cap

Dorianmode · 10-07-2020, 07:01 PM

Ok. Great. So in the regression stats tool in Access, you can create a general tool, (I suggest it be runners 1-12, even though many races will not have 12 runners). The winners will be (I suggest) the number "1". (in one column). In your races then in the tool, rank the horses as they come in, from your "opinion" and see how they stack up when you run the regression.

So what you are comparing is the graph of the winners, (#1) with the graph of the ending (final position) horses you think will win. The regression will tell you how you do ... and if you want to make it complicated, ... separate the specific elements of what constitutes (goes into) "your opinion" and you can see how each of the elements rank in the final positions of the horses.

10-07-2020, 07:01 PM	#19
Dorianmode always learning Join Date: Jul 2011 Location: Minneapolis / Rancho Santa Fe Posts: 277	Ok. Great. So in the regression stats tool in Access, you can create a general tool, (I suggest it be runners 1-12, even though many races will not have 12 runners). The winners will be (I suggest) the number "1". (in one column). In your races then in the tool, rank the horses as they come in, from your "opinion" and see how they stack up when you run the regression. So what you are comparing is the graph of the winners, (#1) with the graph of the ending (final position) horses you think will win. The regression will tell you how you do ... and if you want to make it complicated, ... separate the specific elements of what constitutes (goes into) "your opinion" and you can see how each of the elements rank in the final positions of the horses.