Table of Contents
Creating a bell curve in Google Sheets can be done by using the NORMDIST function and plotting the data as a scatter chart. First, enter the range of data to be used in the NORMDIST function. Next, create the data points by inputting the mean and standard deviation of the range into the NORMDIST function. Then, plot the data points as a scatter chart. Finally, adjust the data points to create the bell shape.
A “bell curve” is the nickname given to the shape of a normal distribution, which has a distinct “bell” shape:
The following step-by-step example shows how to make a bell curve in Google Sheets for a given mean and standard deviation.
Step 1: Define the Mean & Standard Deviation
First, we’ll define the values for the mean and standard deviation of a given normal distribution:
Step 2: Define Percentiles
Next, we’ll define the percentiles to use in the plot ranging from -4 to 4 in increments of 0.1:
Step 3: Define Data Values
Next, we’ll create a column of data values to use in the plot using the following formula:
Step 4: Find the values for the Normal Distribution PDF
Next, we’ll use the following formula to find the values for the normal distribution probability density function:
Step 5: Create the Bell Curve
Lastly, we can highlight the values in the range B5:C85, then click Insert and then click Chart.
You’ll notice that if you change the mean and standard deviation, the bell curve will update automatically.
For example, here’s what the bell curve turns into if we use mean = 10 and standard deviation = 2:
Feel free to modify the chart title, add axis labels, and change the color if you’d like to make the chart more aesthetically pleasing.
The following tutorials offer additional information about the normal distribution: