Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
OK, I understand why it makes more sense to use the normal distribution, on
our hundreds of thousands of records, but my boss is not convinced - mabye because he knows the Poisson distribution is skewed to the left, and he said something about getting higher probabilities than 97%. I dunno. Maybe the purpose has to do with improving performance. My question now is, can Excel generate one-tailed confidence intervals for the Poisson distribution? In other words, is there a way to plug a level of probability you want to achieve in and have it give you the number of records one has a 99% probability of achieving? If not, what plugins for Excel are available to accomplish that - without needing to know visual basic or something to use them? I have an idea not, but I'm double checking. -- Yours, Dora Smith Austin, TX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Confidence Intervals | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Generate 1-to-1 outputs for a list of inputs into a excel formula | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |