View Single Post
  #4  
Old 10-30-2005, 01:53 AM
DougOzzzz DougOzzzz is offline
Senior Member
 
Join Date: Dec 2004
Posts: 132
Default Re: Maths help for Novice

I thought I posted this before but it didn't show up... anyway, here is what the Excel spreadsheet looks like:

4 columns -

Column A has goals scored, from 0-20.
Column B has the formula =POISSON(A1,0.9,false) The A1 will change based on the current row.
Column C has the formula =POISSON(A1,2.0,false)
Column D has the formula, starting in cell D3, =C3*SUM(A$1:A1). The first 1 following the dollar sign remains constant, while the 2nd 1 will always be the current row minus 2. The sum of column D is the total probability.
Reply With Quote