Excel Histogram, Ogive Charts and Cumulative Frequency
Written By: admin on March 9, 2010
27 Comments
Watch a video tutorial on how to create a Percent Cumulative Frequency Distribution with Formulas, a Histogram and an Ogive Chart. See how to add a new data series to a chart and how to have two different Charts Types in one chart.








There are over 100 stats videos at the excelisfun channel at YouTube. Search for this video title that shows how to use the excelisfun channel and how to find the Stats/Excel playlists with over 100 videos:
excelisfun Search for Excel Videos, Playlists & Download Workbooks
thx so much i would be crazy if i haven’t found this excel video , do you have all excel applications video which uses for statistics in your channel or will u add in the future
You are welcome!
Thankyou so much!!! x
You are welcome!!
Man you rock tooooo much….really needed this for my ib math project….thanks a lot buddy
You are welcome!
Thank you for the help… and let me say, I’ve never seen someone so excited over Excel
You are welcome!
thanks so much!
Not at all! Watch these video titles first:
Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas
Excel Statistics 20: P1 Quantitative Freq. Dist. w Formulas
Excel Statistics 21: P2 Quantitative Freq. Dist. w Formulas
quick question.. the first few colums, was all that data entered manually? cause thats what i’ve been doing in stats class..
You are welcome! Thanks for the 5 stars!
Thank you SO much!
5 stars!
You are welcome!
yeah thanks alot dude!! awesome help
You are welcome!
Thank you so much! You have possibly saved my life.
Seriously, thank you. xxx
Thanks for the 5 stars!!
That is ok, perhaps that is something that will be complemented some day. QC (quality control” is a very interesting subject.
Thanks for the other videos there was really needed. Continue in the same spirit.
*five stars from me*
I have made no SPC videos.
Thanks! .
Hey is it possible that you also done a lot of different charts for SPC? (statistic Processing Control) That would be very interesting. For example Steward charts or control charts or other quality methods.
I have over 100 stats videos at the excelisfun channel. This video title shows pareto :
Excel Statistics 18: Pareto Chart for Categorical Data See how to create
Thats awesome. I wonder if you can explain pareto chart in that way you did now?
That would be something.
You are welcome!