How to Plot a Normal Distribution (Bell Curve) in Excel – with Shading!

preview_player
Показать описание
This video walks step by step through how to plot a normal distribution, or a bell curve, in Excel and also how to shade a section under the normal distribution curve using a combination of line and area charts.

Рекомендации по теме
Комментарии
Автор

absolutely superb! Thank you. I'm a slightly above average excel user and my stats knowledge is at high school level. I was able to create a distribution chart of children in my class running laps over time. Thank you!

ravells
Автор

Two short ones: 1) should the grades be in ascending order? 2) how to plot if the data contains a mix of positive, negative numbers and zero? thank you.

mspreddi
Автор

Thanks for making an excellent and very helpful video!

RahimUddin-imvo
Автор

Wow!!! So great, I was finding this kind of explanation for years!!! Thanks a lot for this sharing

cpeovbm
Автор

MUST better and quicker explanation than MS Office. thank you

ValentinaLwin
Автор

This is a great example to learn from but you FLY through each click and step. For someone trying to learn, I think I spent more time rewinding because you move faster than can copy and learn.

ANargi
Автор

Incredible! Thank you for sharing your knowledge.

scion
Автор

Very very useful, thanks for making this video

manasik
Автор

Hi Enrique, question : why U use Mean and not Median value ? Thanks by Italy 🇮🇹

FFF-irsc
Автор

How many minimum data do i need to plot bell curve?

enamulhaque
Автор

Could you help me?
I'm confusing with this :

△ = 8 * (WRS1 - WRS2) / 1000 = 8 * (415-192) / 1000 = 1.784

C1 = -1.060

result = ~N(0, 1)(C1 + △) = 76.5%

How to calculate the formula to get  result 76.5% ?

That Normal Distribution Average = 0 and Standard Deviation = 1

Thxs a alot before

colorboxmedia
Автор

What if my dataset is returning NDIST() > 1 ?

IonCubekhanz
Автор

Can this be applied for independent t-test?

elijahmanuel
Автор

I am just curious, why have you taken 60 as the lowest? Is it based on your assumption or the data set doesn't contain a value lower than 60?

sangeetsaurabh
Автор

Hi Maven, Do you have any video similar to this in the Tableau. I have created the shading but it passes diagonally, how to change it to pass straightly down. Can you help me out.

fylvlkb
Автор

My data did not get a smooth line as yours, I assuming because it was not a made up data but real one, please advise if you feel otherwise

manasik
Автор

1:18 how you did that thing, your explanation is too fast man I am watchin it 5th time

tıbhendese