Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Newbie With A Question | Excel Worksheet Functions | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |