Table of Contents
To generate a Normal Distribution in Google Sheets, we can use the function “=NORMINV(RAND(), mean, standard_deviation)”. This function generates a random number between 0 and 1 using the RAND function, which is then converted into a number on the Normal Distribution curve using the NORMINV function. By adjusting the mean and standard deviation values, we can control the position and shape of the distribution. By repeating this process and plotting the resulting values, we can create a Normal Distribution curve in Google Sheets.
To generate a in Google Sheets, you can use the following formula:
=NORMINV(RAND(), $B$1, $B$2)
This formula assumes that the mean of the normal distribution is specified in cell B1 and the standard deviation is specified in cell B2.
You can then click and drag this formula down to as many cells as you’d like to generate a normal distribution with a particular sample size.
The following example shows how to use this formula to generate a normal distribution in Google Sheets.
Example: Generate a Normal Distribution in Google Sheets
First, we will choose a mean and a standard deviation to use for our normal distribution.
We will choose 0 and 1, respectively:
Next, we’ll type the following formula into cell A5 to generate the first value for our normal distribution:
=NORMINV(RAND(), $B$1, $B$2)
We can then click and drag this formula down to 20 more cells to create a normal distribution with a mean of 0, standard deviation of 1, and sample size of 20:
If you change the values for the mean and standard deviation in cells B1 and B2, respectively, then the values in cells A5:A24 will automatically update.
For example, suppose we change the mean to 30 and the standard deviation to 4:
The new values represent a normal distribution with a mean of 30, standard deviation of 4, and sample size of 20.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets: