How to Generate a Normal Distribution in Google Sheets


To generate a normal distribution 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:

Google Sheets generate normal distribution

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:

How to Perform a Normality Test in Google Sheets
How to Normalize Data in Google Sheets
How to Find Outliers in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *