Create a gamma distribution and test it using using Python in Excel

In my last blog post, I discussed how to create a beta distribution using Python in Excel and then carry out hypothesis tests on it, and that blog post can be read here:- https://tracyrenee61.medium.com/create-a-beta-distribution-and-test-it-using-python-in-excel-5b09f68e91e0

In this blog post I intend to discuss how to create a gamma distribution and also test it using Python in Excel.

The gamma function, being a generalisation of the factorial function to non-integral values, was introduced by Swiss mathematician Leonhard Euler in the 18th century.

The gamma distribution is a continuous probability distribution that models right skewed data. This distribution has been used to model cancer rates, insurance claims, and rainfall, just to name a few examples of its practical applications. It is similar to the exponential distribution and it can be used to model failure times, wait times, service times, etcetera.

The most frequent use of the gamma distribution is to model the time between independent events that occur at a constant average rate. Using this distribution, analysts can specify the number of events, such as modelling the time until the second and third accident occurs, thereby modelling failure times.