In this lesson, I will show you how to create a bell curve using Microsoft Excel. We need to find the mean, standard deviation, and normal distribution to create the bell curve. The functions in Microsoft Excel needed to do this are AVERAGE, STDEV.P, and NORM.DIST After you have calculated all of this you are then able to insert a scatter chart to display as a bell curve.
Download the practice file: https://bit.ly/bellcurvedata
0:00 Intro
0:26 Sort your data
1:15 Calculate the Mean (AVERAGE)
1:57 Calculate the Standard Deviation in Microsoft Excel
2:47 Calculate the Normal Distribution in Excel
5:07 Create your Bell Curve with a Scatter Chart
Create Graphs and Charts in Excel: • How to Create Charts and Graphs in Mi...