Posted to microsoft.public.excel.misc
|
|
Question about use of Poisson probabilities
why don't u try
http://www.ytnow.com/probability/mat...%20probability
-via135
On Feb 4, 7:52 pm, "Dora Smith" wrote:
My boss wants me to use poisson probabilities to compute the liklihood of
meeting various goals in relation to our project, where the average number
of records per month is 617,000.
I am having trouble getting Excel to compute probabilities as other than 0
or 1, though when I do examples on the web that involve very small numbers I
get teh correct answers with no trouble.
Are poisson probabilities intended for this use? Or are they only
applicable for small numbers of discrete events, like the liklihood that 4
cars will run a traffic light in a day?
What would be the appropriate statistic for the probability of meeting a
goal of 700,000 discrete events in a month, or a few million in a year?
--
Yours,
Dora Smith
Austin, TX
--
Yours,
Dora Smith
Austin, TX
|