I am trying to set up a control chart and need to produce random values
with the poisson distribution. in excel i use =EXP(-x), but unfortunately
when x > 490 (circa) excel returns an error.
is there any workaround to find and EXP value in Excel for values larger
than the limit excel imposes?
i thought of a trick, for instance, like:
a = x/490
b = EXP(-490) * a
but i do not have a statistical backgroud.
thanks to all,