How to Create a Bell Curve In Microsoft Excel

No video

How to Create a Bell Curve In Microsoft Excel

Рет қаралды 125,576

Күн бұрын

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: bit.ly/bellcur...
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 a...

Пікірлер: 48

@jtd10902 11 ай бұрын

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

@rosariamancini9714 Жыл бұрын

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.

@maxinejacquelinekami6938 Жыл бұрын

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

@catirerubio 5 ай бұрын

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

@dianebelli7240 Жыл бұрын

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

@TeachersTech Жыл бұрын

You’re very welcome 😊

@rywithtea2469 10 ай бұрын

I love all the shortcuts!

@gregnixon1296 Жыл бұрын

This is fantastic. Thank you.

@lindin5198 Жыл бұрын

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

@Godsmercybeonyou Жыл бұрын

Your great and very helpful 👍 thanks from india

@TeachersTech Жыл бұрын

Thank you and you’re welcome!

@garrodhutchison 9 ай бұрын

Very informative thank you!

@zinnymedia Жыл бұрын

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

@katemferry 11 ай бұрын

So helpful, thank you!

@VitasInfinite 5 ай бұрын

Muchas gracias!

@wronggg 5 ай бұрын

thank you

@ZandarKoad 6 ай бұрын

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!

@JAMESIANA.GONZAGA 11 күн бұрын

mee toooo

@sp-te2to 10 ай бұрын

Thankyou😊

@sickasianchild 4 ай бұрын

thanks

@inkooh8 Жыл бұрын

Thanks.

@thandi44 3 ай бұрын

Dear HR practitioner with an HC system out of 1994...I see you 🧡🧡

@IMChrisThom 10 ай бұрын

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

@Wisdom_owner Жыл бұрын

hi my best teacher

@TeachersTech Жыл бұрын

Hello!

@Wisdom_owner Жыл бұрын

@@TeachersTech please can you make a video about what kind of camputer`s secret study please

@Joda-es5xd Жыл бұрын

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?

@stickman2012 4 ай бұрын

That's what I'm wondering....

@austinyarnell4394 Жыл бұрын

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

@Sagemeister007 Жыл бұрын

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.

@Midnightlies7 6 ай бұрын

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

@rupeshns03 Жыл бұрын

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

@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!

@JAMESIANA.GONZAGA 11 күн бұрын

how to combine histogram with normal curve?

@CoxFamily-ib6oj Жыл бұрын

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 6 ай бұрын

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

@Midnightlies7 6 ай бұрын

Why did you use the avg function and not mean?

@TheLastOutlaw289 2 ай бұрын

My data isn't normally distributed.....

@jonasvandenborne1792 Жыл бұрын

My standard deviation is 0,03657 and my mean is 38,0916, so I get zero with the norm.dist functies. Is there another way to create a Bell curve with these values?

@wangusthewise8995 Жыл бұрын

It will still work, but your data set does not have a lot of variance with a std that low compared to the mean. So the bell curve should be pretty tight.

@marcuscorey5968 20 күн бұрын

normal distritution....

@queenejames8279 Жыл бұрын

Man I keep getting stuck at the Normal Distribution. The teacher couldn't even help me.

@Solzara Жыл бұрын

To set cell reference, you don't use "Function F4" - it's just F4

@kingsamvisuals Жыл бұрын

Depends on your computer. Macs and some PCs default the F row to stuff like brightness and media controls. If I need the F4 I would have to hold FN and press.

@priyankakarthikeyan3461 Жыл бұрын

What in case of mobile