Table of frequencies and percents from a default histogram

This macro displays the frequency and percentage of observations that fall into the default bins created by histogram.

Download the Macro

Be sure that Minitab knows where to find your downloaded macro. Choose Tools > Options > General. Under Macro location browse to the location where you save macro files.


If you use an older web browser, when you click the Download button, the file may open in Quicktime, which shares the .mac file extension with Minitab macros. To save the macro, right-click the Download button and choose Save target as.

Required Inputs

  • A column of numeric data

Running the Macro

Suppose your data are in C1 and you want to display the frequency for each of the bins in the default histogram. To run the macro, choose Edit > Command Line Editor and type:


Click Submit Commands.


As with MINITAB's histogram algorithm, observations that fall on interval boundaries are put into the interval to the right, with one exception: observations on the boundary of the interval that is farthest to the right are put in the final interval.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy