Member-only story
In my last blog post I discussed how to create a hypergeometric distribution in Excel, and that post can be read here:- https://tracyrenee61.medium.com/how-to-create-a-hypergeometric-distribution-in-excel-b7081b4559a4
In this post I intend to cover how to create a normal distribution in Excel.
The French mathematician Abraham de Moivre developed the normal distribution as an approximation to the binomial distribution, and it was subsequently used by Laplace in 1783 to study measurement errors and by Gauss in 1809 in the analysis of astronomical data.
The normal distribution is the most commonly used distribution in all if statistics. This distribution is also called the Gaussian distribution and is a type of continuous probability distribution for a real valued random variable.
Normal distributions are important in statistics and are often used in the natural and social sciences to represent real valued random variables whose distributions are not known.
The importance of the normal distribution is partly due to the central limit theorem, which states that under some conditions, the average of many samples of a random variable with finite mean and variance is itself a random variable whose distribution converges to a normal distribution as the samples increase.
