How to Create Bell Curve in Excel

Welcome to the Business Guruji. This video explains how to create a bell curve in Excel. Bell Curve is a normal distribution curve and is very commonly used in industries

[@srinivasakumarg3519]

Thanks bro..GOD BLESS YOU🎉

[@ianhnizdo4787]

OHHH since its not evenly distributed it won't look smooth! THANK YOU SO MUCH FOR THE EXAMPLE WITH THE STUDENTS! I've been racking my brain trying to find an answer for the graph I had.

[@TheNemesis442]

thank you for going over the practical bell curve at the end of the video, I kept getting something similar to what you had in the practical example and thought that because it didn't look like the bell curve that you had in the first example that I was doing something wrong.

[@stephenjackson5628]

They are doing something wrong. They are related the data back to the number of markers instead of the grades. If you look, the x axis should be from 30 to 100, but it's from 0-30.

[@thebusinessguruji8198]

@@stephenjackson5628 Thanks Stephen for your feedback. The x-axis shows the count of data points in the bell curve. In our example, there were 27 data points, hence the x-Axis is showing from 0-30. Do let me know in case of further clarification.

[@thebusinessguruji8198]

Thanks TheNemesis. The smoothness of the bell curve depends on the smoothness of the data. If we have perfectly distributed data (like in our first example), then we can get the smooth curve. In all practical cases, we will get a somewhat distorted curve (like in second example). Hope this clarifies.

[@sammngi]

Thanks alot for your tutorial, very simple and easy to understand. Be blessed

[@mohitgu123456]

Truly great effort and I still have few questions. Q1. Area , SD, %age and values significance? Q2. How are we using Mean and SD in Bell curve ( I believe Mean should be peak of this curve a line in between and SD the gap between intervals on X Axis. Need more on this. Q3. NormDist is plotted on Y Axis....But what does it give to me? What is its significance? Q4. What is the usage of this Curve/ Bad and Good Curve?

[@ghalaaldwyhi3098]

What did you click after coping the normal distribution ?

[@vigisbigtm]

This is the best tutorial I found. Keep up the good work. Great going!

[@donkaru3939]

thank you so much guruji your a genius

[@winnerokeafor390]

Why do I get #num after pressing down

[@jeb1110]

how do you smooth the bell curve in your example to be like your first example?

[@rabnudj]

excellent teacher, very clear

[@ladybug5335]

My f4 button is not working. Is there another way i could freeze the mean ang standard deviation

[@shabrabradford3566]

F4 didn't work for me either. I have to press function (fn) and F4 together.

[@Anits1989]

how is this done for a two tailed t-test?

[@haepisaus]

my normal distribution is showing a log graph... help...

[@anilamoloo4663]

why you used standard deviation for sample for marks

[@GemsGreenBox]

nice... thank you..!!!

[@abirzeghadi6265]

Thank you it was very helpful.

[@tmp1442]

what did you click after selecting the data in order to get the std devation ?

[@thebusinessguruji8198]

Hello Mohammed. I pressed enter. Please retry and let me know in case of any challenges.

[@cuevas8405]

But what about the student numbers? It's like saying that student 10 suddenly got a score from 80 to 75

[@pakaymastarichkul7521]

Great!!

[@Aaseef]

Amazing presentation

[@DABardx]

Thank you, sir

[@unnikrishnansanthosh]

Fantastic explanation...keep it up

[@smsm314]

Please Sir, on EViews how can we do a forecast by distribution?

[@rositanhamizinga509]

Obrigada

[@nikitadsouza4731]

Thanks, this was helpful

[@jelohsimo2435]

Using the FALSE function might lead students (e.g., me) into thinking these normal distribution values are the actual probabilities (or you might also call it "areas") of getting data less than or equal to the raw data that corresponds to a z-score. I hope you could explain this more thoroughly. Still, thanks for the video!

[@kinobyseven6522]

Thank you

[@chadeee16]

my curve is not belling lol lol

[@mahijeet5852]

how do i work if the data is values? instead of numbers , i have two columns with dates and sales value

[@rakeshthakur-nd5sk]

Nice Video

[@yasirt.m2455]

great... thanks

[@HeritageWealthPlanning]

fantastic!

[@ruwanishiromala]

Thank you so much ...

[@mrunalsawant9394]

how to freeze the cell

[@mohammednassih4482]

F4

[@clipsclipsammo4540]

keeps saying too few arguments.... im screwed

[@tmp1442]

1:50

[@lukechalk6214]

i love u