Use Excel to generate random numbers that match a normal distribution

The application of normal distribution is very extensive, and many objects in natural science and social science research conform to normal distribution. This article describes how to use the random number generator in Excel to obtain random data that satisfies a normal distribution.

1. using the random number generator in Excel

2. obtain a normal distribution of 400 random numbers with a mean value of 0 and a standard deviation of 0.5

3. using descriptive statistics to observe data

4. generates a sequence with a step size of 0.05 and a range of [ -4~4]

5. Use the histogram to see if the data conforms to the normal distribution, which takes a longer time.

6. The curve satisfies the characteristic of normal distribution: "About the mean symmetry, middle height, both sides low".

Use Excel to generate random numbers that match a normal distribution