Forum Discussion
I have a challenging excel problem
Hi guys, Have got quite a challenging problem. I'm trying to build a model that produces the probability of horses winning a race. There are 4 "speedmaps" (i.e. scenarios of how the race mi...
To get the figures you show either calculate the probability for each horse individually
= SUMPRODUCT( HorseA, Likelihood )
= SUMPRODUCT( HorseB, Likelihood )
= SUMPRODUCT( HorseC, Likelihood )
or as a single calculation
= MMULT( speedmaps, TRANSPOSE(Likelihood) )
[committed with CSE]
where 'Likelihood' is the probability for each speedmap.