2] To create a bell curve in excel, we need three values, average, standard deviation, and normal distribution. Let’s calculate the average of the data first.

Learn how to approximate the effective convexity of bonds using Microsoft Excel with a modified and simpler version of the standard convexity formula.

With that, Excel can generate a series of random numbers based on the data entered and the standard deviation. With this data you can then create a curved chart, known as a bell curve.

How to Put a Gaussian Curve on a Graph in Excel. Gaussian curves, normal curves and bell curves are synonymous. Each represents how statistical data with normal distribution plots on a graph.

Create production possibility frontier curves in Microsoft Excel and understand the importance of production possibility to businesses.