How to Create a Bell Curve In Microsoft Excel

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.

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

[jtd]

This is the best tutorial on bell curves. Incase you have been looking through 20 videos like me.

[maxinejacquelinekami]

I'm a new lecturer without teaching QUALIFICATION! this is very helpful and I appreciate it.

[rosariamancini]

Thank you for this video!! Sometimes self-learning while attending an online college is extremely tricky, but you have helped me out tremendously! Much appreciated.

[catirerubio]

Clearly explained steps. Thanks. Very, very hard to memorize them, but that is my problem. You show the way. Thanks again.

[dianebelli]

You are a legend thanks so much for sharing your knowledge and expertise

[Godsmercybeonyou]

Your great and very helpful 👍 thanks from india

[lindin]

Thank you so much! This was helpful and easy to follow.

[zinnymedia]

YOU ARE BEST! TRUST ME I MEAN IT! 🎊 THANK YOU

[ZandarKoad]

Hmmm, the thumbnail shows a bell curve with a Histogram. But that's not what we got in the video. I really needed a bell curve with a histogram!

[Joda-esxd]

Great Video really enjoyed it. I wanted to ask If I have a set of 2 sets of data is it possible to merge multiple curved bells?

[rupeshns]

How can we create different types of Distribution curves in excel like Trapezoidal, two -peak, bacl loaded, front loaded curves?

[austinyarnell]

Is there a way to include names in the bell curve when using a "smooth line curve with markers" chart? I want each data point's to have it's corresponding name above or on one of the axises so people can visualize where they fall on the chart

[IMChrisThom]

Good video. Could you use the same techniques if you data was on a table so you can do filtering?

[Midnightlies]

do you have to sort the data from smallest to largest or will it still work?

[Sagemeister]

Thank for this tutorial. I'm working on a report and I want to position the largest number in the middle of the bell curve and smallest numbers on the outer sides the bell curve. Is there a function in EXCEL that can do this? For example if the sample is: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. In my report I would position 1 and 2 on the outer sides of the bell curve, 3 and 4 next to 1, and 2. and ultimately 9 and 10 would be in the center. My report contains approximately 5, 000 data. Thank you.

[JAMESIANA.GONZAGA]

how to combine histogram with normal curve?

[CoxFamily-iboj]

Does this work if my data is hh:mm:ss? I work in call center and I am trying to give a bell curve of our agent’s time spent on a certain type of call

[StartupIstan]

i am facing an error in normal distribution cant make a graph 4.3554E-208, E appears in Normal distribution

[MikeMessiah]

The normal distibution value is coming in minus (-) for me. I am gettting an inverted bell curve. I followed all the steps you showed!

[Midnightlies]

Why did you use the avg function and not mean?