Member-only story
In my last blog post I discussed how to create a Poisson distribution in Excel, and that post can be read here:- https://tracyrenee61.medium.com/how-to-create-a-poisson-distribution-in-excel-1debd0ac59bf
In this blog post I intend to discuss how to create a geometric distribution in Excel.
In order to grasp the geometric distribution, it is first necessary to understand the Bernoulli distribution. Each trial, such as a coin toss or roll of the die, is formalised using the Bernoulli distribution and then a probability is calculated to construct the geometric distribution.
The Swiss mathematician Jacob Bernoilli developed the Bernoulli distribution, which is a discrete probability distribution of a random variable that takes the value of 1 with probability p and the value of 0 with probability q = 1 — p. Less formally, the Bernoulli distribution can be thought of as a model for a set of outcomes of any single experiment that asks a yes-no question, which leads to a boolean valued outcome.
The Bernoulli distribution is a special case of the binomial distribution, where a single trial is conducted so that n would be 1 in such a distribution.
The formula for the probability mass function (PMF) for this distribution is:-
