Calculating quartiles using the counting method

This macro calculates the first and 3rd quartiles using the counting method found in many textbooks, as opposed to the percentile method used in Minitab.

This macro calculates the first and third quartiles using the counting method found in many textbooks, as opposed to the percentile method used in Minitab.

Download the Macro

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

Important

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 values

Running the Macro

Suppose column C1 contains the data. To run the macro, choose View > Command Line/History and type:

%QRTILES C1

Click Run.