Excel 2016 Data Analysis ToolPak Histograms and Percent Polygons

This how-to walks you through the process of using the Data Analysis ToolPak to visualize data distributions. This process is different from the pivot table method and provides results that are more easily compared. I detail the process of generating a histogram for each outcome and a plot of several percent polygons to compare several distributions.

[@robertkong8576]

Thank you. This is the best tutorial on histograms on Excel and so well presented.

[@DrRyanPhelps]

Thanks for the love.

[@megamouth4399]

This video has been really helpful, thank you for uploading

[@klam77]

SUPERB. very clear and complete too.

[@DrRyanPhelps]

Glad it was helpful!

[@MrLudiJasko]

Ok... How about sharing the data-file? So that we can work in parallel...

[@DrRyanPhelps]

This was meant to be a demo, but I will look into sharing the file.

[@dhcamper]

Even in HD, the video resolution is too low to read much of the font for some of the functions; that or the text is too small.
.
The screen on my laptop is pretty sizable; when the video is only partly filling the screen, the text is too small, and when it's full screen, the resolution at times is too low.
.
Still very helpful overall though.

[@DrRyanPhelps]

It may be the speed of your internet connection. Are you using listening along, because I also spell out the formulas used.

[@DrRyanPhelps]

Here is a link to the data: faculty.sfasu.edu/phelpsrt/youtubefiles/Percent_Polygons_DAToolPak.xlsx