![]() |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
I'm not 100%, but I think you need to compute the probability of a 3-3tie and subtract it.
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|