This Blog entry is from the Basic Statistics section in Learn Palisade.
On the StatTools ribbon in Excel, click on the menu item towards the centre left which is titled Summary Graphs. In the drop down menu there is a sub menu item titled Histogram:
Clicking on Histogram will open the Histogram configuration window:
For the purposes of this example create a histogram based on just one variable, in this case Interval_Close, while allowing StatTools to infer the most appropriate number of bins.
To select the variable, simply check the checkbox next to the variable name:
Clicking the OK button will create the Histogram in a new Excel workbook:
Two outputs are created, the tabular representation of the Histogram which includes the probability density, and a bar chart providing a visualisation for the distribution.