How to Plot a Normal Distribution (Bell Curve) in Excel - with Shading!
HTML-код
- Опубликовано: 22 авг 2023
- 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.mavenanalytics.io/course/...
▶️ 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.mavenanalytics.io/online-...
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!
Out of box🎉❤
Thanks for making an excellent and very helpful video!
Wow!!! So great, I was finding this kind of explanation for years!!! Thanks a lot for this sharing
Very very useful, thanks for making this video
MUST better and quicker explanation than MS Office. thank you
Great video! Looks so easy! :)
Thank you this was very helpful.
Incredible! Thank you for sharing your knowledge.
Glad you enjoyed it!
Excellent!
Absolute GOAT
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.
Can this be applied for independent t-test?
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.
There is A LOT to know/memorize.
Top skills! Love this.
shut up
Hi Enrique, question : why U use Mean and not Median value ? Thanks by Italy 🇮🇹
How many minimum data do i need to plot bell curve?
What if my dataset is returning NDIST() > 1 ?
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?
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.
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
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
Yeah mine too. I think if the data is not evenly distributed we aren't going to get a perfect bell curve.
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
1:18 how you did that thing, your explanation is too fast man I am watchin it 5th time
update: I done it by pressing F4 , but my graphs didnt look like the bell shape. what can be the reason?
Very bad presentation
I think you meant to say very good! No worries though, I misspell things all the time so I get it😉
Great Video! Keep up the good work,