How to Chart the Frequency of a Data Set on Excel. Plotting the frequency of data falling within numeric ranges illustrates the diversity of your data. As an example, a teacher might wish to ...

To read a histogram in Excel, first install the Analysis ToolPak Excel add-on, then input your data and generate a histogram, with optional chart and cumulative percentage numbers.

Drawing a box plot from a cumulative frequency graph is straightforward as long as the median and quartiles have been found. The guideline for median, lower quartile and upper quartile can be used ...