Excel Histogram with Normal Distribution Curve

Where do you get the "X" value?

Why are we multiply by 5000 sir

THANK YOU there isnt any video like yours, i find this hardly it was very non understandable how can distribution be like a curve, how create by own and understand the whole process, Thanks a lot))))

I'm looking to get the percentage of the histogram outside of the curve, is that possible?

Excellent

how did you find the variance please?

How did U find the midpoint in the bin??

great video! 8/10

Why dont use answer to the questions about mean and standart deviation? How did you get it?

Here student Number is 31. Your frequency distribution in Bins is more than 5000, How is the procedure to calculate like you

Another question. How can I calculate frequency -15 against bin value 150?

Omg this was very helpful I have a group research ang I'm assigned to the Organizing ang Presentation of our data. So this helped me alot for my FDT and visualization for the normality of distribution. Thankyou verymuch!!

This has helped me so much, thank you!

I have a data set with averages. Am I still able to use the normdist formula ? or is there another way ?

Thank you sooo much. I have been trying to find a guide to this for sooo long and finaly something what I understand.🙏🙏🙏👍👍👍👍👍👍👍👍

Can I save the work and reuse it by refreshing the input data and have the curve updated accordingly? I’d like to use it to show distribution of students’ marks as there are new quizzes and exams without having to do the steps from the beginning.

When you're correcting the y-value for the normal distribution (norm.dist) did you say add 5000 times 5? (=norm.dist(cell, cell, cell)+5000*5? Or =norm.dist(cell,cell,cell) *5000*5? Your cursor covers the exact spot to see if you added or multiplied the 5000*5.

The worst video explaining this

Lifesaver! Thank you so much!!

Saved an entire work my friend, congratulations

Ty so much for showing howto add the analysis toolpak

THANK YOU FOR THE EXCELENT EXPLANATION. COULD YOU PLS EXPLAIN WHEN ERROR BARS COME VERTICALLY WHAT CAN WE DO?

This really help a lot for me, Respect!

hello I am failing to download the excel sheet - is the link working ?

can any one help with file - failing to download

Thank you so much however, when I try adding the curve, my normal graph (lets say series 1) goes down. Now I have a curve way over the actual graph. Theres jut something Im missing

where can i download the excel sheet

really good! Thanks.

Wow. This really saved my day. So much better than the other explanations I clicked through before finding this. Thanks!

how you gonna make a tutorial video and then cut an edit in with new things done????

Good Work, really helpful

The sum after applying norm.dist function is not coming 1 in the y column (before applying correction multiplication). what to do please help. My data does not contain integer values; it has decimal values (float), and I have taken all data values as X.

Very helpful video. Really impressed my colleagues with this one!

If this is the quickest way to do it, the developers should be fired for not having a trendline available in histogram

Oh my god! Finally! THANK YOU VERY MUCH! You saved our team! Much love and respect from department of biochemistry in Greece! (Eva, Spyros, Giannis <3)

thank you so much for your great explanation. I really understood it. how about Excel Histogram with Normal Distribution Curve for a Likert Scale Data

👌☺️😍

the time I deleted the error bars, my graph was gone. What happened

Why do we have to multiply by 5000?

5.28
Brother, where did the 5,000 come from?

bro the moment when you created the histogram was sickkkk

This is nice! I love the way you hacked Excel to overlay a normal distribution over a "histogram" as this is impossible to do with normal Excel tools.

One comment from me: the built in histogram add-in kills the formula. So if you plug in different data you need to redo the bins and frequency again. I would prefer to use the frequency function and a smart function to create the bins from the range and a given number of bins.

🎉😮😢😢😊

I couldn't find the link to downloading the data you used.

This is probably the best tutorial on this topic. Thank you!!

Thank you so much. I spent two days trying to do it for my capability studies, since I don't have access to any statistics software tool. Xbar charts, R charts, Probability Plot, Chronological Control Chart were all good but the Histogram... Wow. I did it a little bit different (I used all my data and its normal distribution values, as well as added bar for +/- 3 sigma and USL and LSL but the error bars part was the one I needed for visuals. Thanks once again.

It turned out that the curve of the normal distribution is lower than the values of the histogram. Why?

Can you add percentile markers (e.g. 10th and 90th percentile) in the form of vertical lines to a histogram?