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.

Yield curves indicate where future interest rates are headed. Did you know that you can make one in excel? Discover how here.

You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.