Member-only story
Create an exponential distribution and test it with Python in Excel
In my last blog post I described how to create and test a uniform distribution using Python in Excel, and that post can be read here:- https://medium.com/@tracyrenee61/create-a-uniform-distribution-and-test-it-using-python-in-excel-6e09f74efd48
In this post I intend to discuss how to make an exponential distribution and test it in Excel with Python.
The exponential distribution was first recognised by the French mathematician Abraham de Moivre in his work on probabilities associated with discretely generated random variables. The mathematical relation between exponential distribution and coin tossing was further developed by the French mathematician Emile Borel in 1909.
The exponential distribution is a probability distribution that is used to model the time we must wait until a certain event occurs.
The exponential distribution can answer questions like:-
- When will a customer enter a shop?
- How long will a laptop work before it breaks down?
- How long will a battery work before it dies?
- How long do we have to wait for a volcanic eruption in a certain area?
