Poisson distribution

This looks great. Can you Please upload this file with code.


---L---- ------M------- N O -P-- -Q- -R- -S-
4 Expected value
5 5.408609321 Size 100
6
7
8 1 2 3 80% 90% 95%
9 0.013522 0 0 1 2 2
10 0.013522 0 0 1 2 2
11 0.013522 0 0 1 2 2
12 0.027043 0 0 3 4 5
13 0.054086 0 0 6 7 8

According to my excel poisson formula at row 13 stock level 7 gives 82% and 9 gives 95% . Does the inv Poisson calculate a bit differently.

What i was hoping for was to include a condition to chose stock level number from 76%-85% as 80% , 86%-92% as 90 and 93%-96% as 95. Can we put some code in this macro that makes this possible.