To create a sample bell curve, follow these steps:Įnter the following column headings in a new worksheet:Ī1:Original B1:Average C1:Bin D1:Random E1:Histogram G1:HistogramĮnter the following data in the same worksheet:Įnter the following formulas in the same worksheet: From the histogram, you can create a chart to represent a bell curve. After Microsoft Excel generates a set of random numbers, you can create a histogram using those random numbers and the Histogram tool from the Analysis ToolPak. N the following example you can create a bell curve of data generated by Excel using the Random Number Generation tool in the Analysis ToolPak. This article describes how you can create a chart of a bell curve in Microsoft Excel.
A bell curve is a plot of normal distribution of a given data set.
