In the real world the values of many random variables -for example, the heights of adult males in the United States- are normally distributed. That is, the bulk of the values are around the mean of the distribution.;
, A normal distribution is a continuous probability distribution in which 68% of the values are within one standard deviation of the mean, 95% are within two standard deviations, and 99.7% are within three standard deviations.
 In Excel, the NORM.INV function returns a normally distributed value given a probability, a mean, and a standard deviation. NORM refers to a normal distribution with a given mean and a given standard deviation. and INV refers to inverse, that is, finding a value given a probability, rather than finding a probability given a value.
 The RAND() function returns a random number between zero and one.
 Combining the two above-referenced functions returns a normally distributed random value with a given mean and a given standard deviation.
 To create a random sample of a normal distribution with a mean of 70 and a standard distribution of 3, enter the above-referenced combined function in cell A1.
 To create a sample of size 10, copy cell A1 to cells A2 to A10.
 Excel displays the random sample of a normal distribution with a mean of 70 and a standard deviation of 3.
Understand Normal Distributions.
Know the 68 95 99.7 Rule.
Learn NORM.INV.
Get to know RAND().
Learn to combine functions.
Entering the combined function.
Replicate the Combined Function.
View the Results.
{"src": "wikihow-all_validation", "title": "How to Create a Normal Distribution with Excel"}