Frequencies and percents from intervals produced by a histogram

This macro shows the intervals, frequencies, and percentages from a histogram where the user specifies the intervals.

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 measurement data used to create a histogram
  • The midpoints of the first and final intervals of the histogram, or (if your histogram used cut points instead of midpoints) the start point of the first interval and the end point of the final interval.
  • The increment between midpoints or cut points on the histogram

Optional Inputs

Use if your histogram specified cut points instead of midpoints.

Running the Macro

Suppose the first interval of a histogram of your data in C1 has a midpoint of 20.5, the final interval of your histogram has a midpoint of 40.5, and the increment between the midpoints is 2.To run the macro, choose Edit > Command Line Editor and type:

%HBINS 20.5 40.5 2 C1

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