Generate Normally Distributed Data in Excel
You need to randomly generate normally-distributed data in Excel.
We will use Excel's
Step 1: Place your random number formula in the target cells
In this example, we'll generate data with mean \(\mu = 100\) and standard deviation \(\sigma = 15\). The
=NORM.INV(RAND(), 100, 15):
Step 2 (optional): Plot a histogram
The histogram for a dataset with \(n = 30\):
In this case the main part of the mass is a bit under the mean of 100, and we have a surprising number of scores toward the top end of the range. Still this isn't that amazing since the dataset is pretty small. With a larger dataset we'd see more convergence toward a proper bell curve.