D
Dora Smith
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?
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?