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

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.
🔗 Link to the full course, Statistics for Data Analysis with Enrique Ruiz: www.mavenanaly...
▶️ Want more Excel tips? Check out our Data Analysis in Minutes playlist: • Data Analysis Hacks Yo...
🗣️ Follow us on LinkedIn for daily data analysis tips and career guidance: / maven-analytics
💡 Interested in other courses? Join over 1,000,000 students who have taken our Maven Analytics courses in Excel, SQL, PowerBI, Tableau, Python and more: www.mavenanaly...

[@ravells]

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!

[@RahimUddin-im5vo]

Thanks for making an excellent and very helpful video!

[@HarwellMejia]

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

[@ValentinaLwin]

MUST better and quicker explanation than MS Office. thank you

[@BridgeLocations]

Very helpful, thank you!

[@OnepiercingtoomanyToomany]

Super helpful. My bell curve looks like a millipede path though 😅

[@AlloyedFrequencies]

Thank you very much

[@scion830]

Incredible! Thank you for sharing your knowledge.

[@MavenAnalytics]

Glad you enjoyed it!

[@swikriti8351]

Thank you this was very helpful.

[@manasik280479]

Very very useful, thanks for making this video

[@mspreddi1]

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.

[@LucaCosta65]

Excellent!

[@Tubeytime]

Absolute GOAT

[@A3Nargi]

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.

[@SwainLake]

A quick question: why did you make data in Column G, not using data in Column B?

[@FFF-ir8sc]

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

[@Lokfkdoydkgd]

Out of box🎉❤

[@catirerubio]

There is A LOT to know/memorize.

[@JennTheWriter]

Great video! Looks so easy! :)

[@elijahmanuel8686]

Can this be applied for independent t-test?

[@colorboxmedia5866]

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

[@enamulhaque630]

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

[@sangeetsaurabh9989]

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?

[@perdedor3571]

the data set is the MBA grade. taking a peak it looks like there are no grades below 60. so he likely just used 60 arbitrarily because it's a nice even number below the lowest number of the data set which was 66.9.

[@AishuMohan-k6l]

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.

[@IonCubekhanz]

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

[@broonzy2006]

Top skills! Love this.

[@imadethisaccountforaplang]

shut up

[@manasik280479]

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

[@sshubhamsingh46]

Yeah mine too. I think if the data is not evenly distributed we aren't going to get a perfect bell curve.

[@TrevX2001]

Check your X-Axis values... if you're getting blocky fill , then make the increments small. I was counting by 2's but then changed it to count by 1's and got a perfectly smooth fill@@sshubhamsingh46

[@tıbhendese]

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

[@tıbhendese]

update: I done it by pressing F4 , but my graphs didnt look like the bell shape. what can be the reason?

[@TexasHealthcareAdmin]

Great Video! Keep up the good work,

[@santhankkk]

Very bad presentation

[@lucasnikodemus8813]

I think you meant to say very good! No worries though, I misspell things all the time so I get it😉