Excel Question ~ Poisson function and tie scores
I am trying to set up a spreadsheet to figure totals for hockey. Does anyone know how to remove the ties from the poisson function results? Is it possible? The ties are throwing my numbers off a little.
Right now my cell looks like
=Poisson(Total,Avg goals per game,False)
Where total=6 and avg goals/game=5.73 it is returning 15.96% but including a 3-3 score which isn't possible.
Thanks,
TheRake
|