Two Plus Two Newer Archives  

Go Back   Two Plus Two Newer Archives > General Gambling > Sports Betting
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-07-2006, 04:20 PM
TheRake TheRake is offline
Senior Member
 
Join Date: Sep 2003
Location: Fort Worth, TX
Posts: 1,019
Default 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
Reply With Quote
  #2  
Old 02-07-2006, 05:13 PM
Central Limit Central Limit is offline
Senior Member
 
Join Date: Jan 2006
Location: Twenty dollars.
Posts: 336
Default 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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.