How To: Make distributions, ogive charts & histograms in Excel

Make distributions, ogive charts & histograms in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 22nd installment in his "Excel Statistics" series of free video lessons, you'll learn 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.

While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.

Check them out >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

1 Comment

This was awesome! Your tutorial was easy to follow! Had to create an ogive for my stats class and the walkthrough in the book isn't nearly as clear as yours. Thanks again!

Share Your Thoughts

  • Hot
  • Latest