Hi there,
I have seen in Excel 2010 that there is a Possion Distribution function that I want to use (POISSON.DIST) and I want to use it in relation to the following article...
http://understandinguncertainty.org/node/228
So how would I set up the formula to calculate the % probability of each team scoring a specified number of goals in the match?
Andy
Hiya,
I'm a relative newb in maths and excel so need you lovely peoples help!
Basically, i've got a spreadsheet with poisson distribution using the required function in excel. I've been told that i need to use a bivariate poisson distribution to make my results more accurate.
I'm clueless here...
Any help would be greatly appreciated.
Thanks
Hello!
I want to simulate a process using the poisson distribution. If the poisson distributed event occurs I want a variable to show "1" else "0".
Can you help me? did you understand?
Hello!
I want to simulate a process using the poisson distribution. If the poisson distributed event occurs I want a variable to show "1" else "0".
Can you help me? did you understand?
I could use some VBA code for the inverse poisson.
InversePoisson ( Randin, Mean) would return the largest integer, N, with CDF(N) <= Randin where the CDF is the cumulative distribution for the Poission with parameter Mean.
I am testing accuracy of a Poisson simulation program and need a way to simulate Poisson values from first principles so to speak.
Thanks for any help you can provide!
Not sure if anyone can help with this. Basically I'm trying to find out how to apply the reverse of the Poisson function in excel. So as of now I have poisson(x value, mean, true-cumulative) and that lets me get the probability for that occurence. Basically I want to know how I can get the minimum/maximum x value based on a given probability.
So if I have a list of data (700 rows) and I want to find out what the minimum starting value should be given a desired average and the fact that I want the lowest value to be at the 0.05% probability. So 0.05% = (x, 35, True) solve for x.
I know I can prob do this with solver, but I am trying to figure out a way to do this formulaicly without having to use the solver (as I may have to use this many times)
Thanks for any insight/links/help as always!
Does anyone know how to construct this in Excel? I could do with some support?
Andy
I would like to model Bivariate Zero-Inflated Poisson through Excel VBA, then I would like to apply weight function stochastic, may I know if there any suggestion or idea?
I would like to model Bivariate Zero-Inflated Poisson through Excel VBA, then I would like to apply weight function stochastic, may I know if there any suggestion or idea?
Hello,
I have the poisson table with all the results in different columns depending on the coeffcient.
In the most left column I have the needed stock level versus the coefficients.
How can I make it run automatically when I have a certain coefficient in another table and want to lookup al the results which are in the column ?
E
E
E
E
E
E
E
E
E
E
M
0,02
0,04
0,06
0,08
0,1
0,15
0,2
0,25
0,3
0,35
0
0,98
0,961
0,942
0,923
0,905
0,861
0,819
0,779
0,741
0,705
1
1
0,999
0,998
0,997
0,995
0,99
0,982
0,974
0,963
0,951
2
1
1
1
1
0,999
0,999
0,998
0,996
0,994
3
1
1
1
1
1
4
5
6
7
8
9
Roland
