How to Create a Bell Curve In Microsoft Excel

Подписаться 966 тыс.

Просмотров 124 тыс.

50% 1

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/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 a...

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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.

@lindin5198 Год назад

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

@rywithtea2469 10 месяцев назад

I love all the shortcuts!

@gregnixon1296 Год назад

This is fantastic. Thank you.

@dianebelli7240 Год назад

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

@TeachersTech Год назад

You’re very welcome 😊

@katemferry 10 месяцев назад

So helpful, thank you!

@zinnymedia Год назад

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

@garrodhutchison 8 месяцев назад

Very informative thank you!

@VitasInfinite 4 месяца назад

Muchas gracias!

@IMChrisThom 10 месяцев назад

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

@Godsmercybeonyou Год назад

Your great and very helpful 👍 thanks from india

@TeachersTech Год назад

Thank you and you’re welcome!

@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

@inkooh8 Год назад

Thanks.

@wronggg 4 месяца назад

thank you

@sp-te2to 10 месяцев назад

Thankyou😊

@Sagemeister007 11 месяцев назад

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.

@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 3 месяца назад

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

@nezu_cc 10 месяцев назад

thanks

@rupeshns03 Год назад

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

@JAMESIANA.GONZAGA День назад

how to combine histogram with normal curve?

@Midnightlies7 6 месяцев назад

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

@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

@StartupIstan 6 месяцев назад

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

@CoxFamily-ib6oj 11 месяцев назад

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

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

@Midnightlies7 6 месяцев назад

Why did you use the avg function and not mean?

@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 День назад

mee toooo

@TheLastOutlaw289 2 месяца назад

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

@thandi44 2 месяца назад

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

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

@marcuscorey5968 10 дней назад

normal distritution....

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