ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Modelling arrival intervals using Poisson distributions (https://www.excelbanter.com/excel-discussion-misc-queries/118563-modelling-arrival-intervals-using-poisson-distributions.html)

John

Modelling arrival intervals using Poisson distributions
 
i have been asked to generate time intervals between arrival times from a
Poisson distribution, mean 5 minutes. I cannot work out how to do it

Mike Middleton

Modelling arrival intervals using Poisson distributions
 
John -

=-LN(RAND())/0.2

- Mike
http://www.mikemiddleton.com

"John" wrote in message
...
i have been asked to generate time intervals between arrival times from a
Poisson distribution, mean 5 minutes. I cannot work out how to do it





All times are GMT +1. The time now is 11:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com