Table of Contents
To generate a normal distribution in Excel, you can use the built-in function “NORM.DIST”. This function allows you to input the mean, standard deviation, and desired x-value to calculate the probability of that value occurring in a normal distribution. You can also use the “NORM.INV” function to generate random numbers from a normal distribution based on the given mean and standard deviation. These functions can be found in the “Statistical” category under the “Formulas” tab in Excel. By using these functions, you can easily generate a normal distribution in Excel for data analysis or statistical calculations.
Generate a Normal Distribution in Excel
To generate a in Excel, you can use the following formula:
=NORMINV(RAND(), MEAN, STANDARD_DEVIATION)
You can then copy this formula down to as many cells in Excel as you’d like, depending on how large you’d like the dataset to be.
The following step-by-step example shows how to use this formula to generate a normal distribution in Excel.
Step 1: Choose a Mean & Standard Deviation
First, let’s choose a mean and a standard deviation that we’d like for our normal distribution.
For simplicity, we’ll choose 0 for the mean and 1 for the standard deviation:
Step 2: Generate a Normally Distributed Random Variable
Next, we’ll use the following formula to generate a single normally distributed random variable:
=NORMINV(RAND(), $B$1, $B$2)
The following screenshot shows how to do so:
Step 3: Choose a Sample Size for the Normal Distribution
Next, we can simply copy and paste this formula down to as many cells as we’d like.
For example, we may copy and paste this formula to a total of 20 cells:
Note: You can quickly generate a brand new dataset that follows a normal distribution by simply double clicking on any cell and pressing Enter.
Cite this article
stats writer (2024). How do I generate a normal distribution in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-generate-a-normal-distribution-in-excel/
stats writer. "How do I generate a normal distribution in Excel?." PSYCHOLOGICAL SCALES, 2 May. 2024, https://scales.arabpsychology.com/stats/how-do-i-generate-a-normal-distribution-in-excel/.
stats writer. "How do I generate a normal distribution in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-generate-a-normal-distribution-in-excel/.
stats writer (2024) 'How do I generate a normal distribution in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-generate-a-normal-distribution-in-excel/.
[1] stats writer, "How do I generate a normal distribution in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How do I generate a normal distribution in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.