Create a uniform distribution and test it using Python in Excel

In my last post I discussed how to create a Poisson distribution and perform hypothesis on it and that post can be found here:- https://medium.com/@tracyrenee61/create-a-poisson-distribution-and-test-it-in-python-in-excel-d866cd10a687

In this post I intend to cover how to create a uniform distribution and test it.

The discrete uniform distribution, or rectangle, is a symmetric probability distribution wherein a finite number of values are equally likely to be observed, with every one of n values having equal probability 1/n. In short, every event from a to b is equally likely to occur.

The formula for the discrete uniform distribution is:-

The uniform distribution can be created and tested in Excel using Python, and the screenshot below depicts the spreadsheet that I made to illustrate how it can be done:-

I created three uniform distributions and entered the Python code below to form them:-