Member-only story
In a recent post I reviewed 25 popular probability distributions in Python, and that particular piece can be found here:- https://medium.com/@tracyrenee61/a-review-of-the-25-most-popular-distributions-in-statistics-using-python-eabae1ddfb45
In this post I intend to discuss how to create a binomial distribution in Excel. Excel is a very sophisticated piece of software, which can carry out complicated computations in a series of cells that are placed within rows and columns of a spreadsheet.
The binomial distribution was invented by Swiss mathematician Jacob Bernoull, in a proof published posthumously in 1713, determined that the probability of k such outcomes in n repetitions is equal to the kth term (where k starts with 0) in the expansion of the binomial expression (p + q)n, where q = 1 — p.
The binomial distribution evaluates the probability for an outcome to either succeed or fail. It is a mutually exclusive outcome, where the analyst can have one or the other, but not both at the same time.
The binomial distribution describes the probability of k successes in n draws with replacement. in contrast, the hypergeometric distribution describes the probability of k successes in draws without replacement.
