View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
via135 via135 is offline
external usenet poster
 
Posts: 94
Default 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