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.

Have an iPhone? Check out all 200+ new features coming in iOS 13.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

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