How do I change a poisson spreadsheet into a bivariate version? [Archive]

View Full Version : How do I change a poisson spreadsheet into a bivariate version?

pswirly

Jun20-09, 07:04 PM

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?

HallsofIvy

Jun21-09, 07:21 AM

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?