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

Re: Excel Question ~ Poisson function and tie scores
 

I'm not 100%, but I think you need to compute the probability of a 3-3tie and subtract it.