A histogram is a column chart that shows the frequency of data in a certain range in a simpler way. It provides the visualization of numerical data by using the number of data points that fall within a specified range of values (also called “bins”). Steps to create a histogram are:
- Make sure you load the Analysis ToolPakto add the Data Analysis command to the Data tab.
- On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column.
- Click Data > Data Analysis > Histogram > OK.