How do I change a poisson spreadsheet into a bivariate version?

  • Context: Undergrad 
  • Thread starter Thread starter pswirly
  • Start date Start date
  • Tags Tags
    Change Poisson
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
2 replies · 7K views
pswirly
Messages
1
Reaction score
0
I have an excel spreadsheet that uses poisson to figure out the probability of correct scores in soccer matches.

How do I amend the spreadsheet to use a bivariate poisson distribution?
 
Physics news on Phys.org
If the two variables are independent, just multiply the Poisson distributions of each. If they are not independent, what information about the correlation do you have?
 
HallsofIvy said:
If the two variables are independent, just multiply the Poisson distributions of each. If they are not independent, what information about the correlation do you have?

1. There is additional restriction - draw probability as parameter for distribution. Draw - this is the case when M(t) = N(t).
In common Pdraw = sum(M(ti)*N(ti)), i = 0, 1, 2 ...

2. I have tried to multiply the Poisson distributions of each for calculation the spreadsheet, but calculated Pdraw is lower than fact Pdraw. And calculated data don't correlate with fact data. Results from this that I don't take into account some factors (first of all, draw probability), which shall correct Poisson distribution.

How I can take into account draw probability to modificate the Poisson distribution?