Mann-Kendall test for detecting trends

This macro calculates the Mann-Kendall test for detecting either an upward or downward trend in data collected over time. An adjustment is made for tied observations in this non-parametric test. You must have at least 10 observations for the Normal approximation to be appropriate.

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.

Download MKTREND.mac

Required Inputs

A column of numeric data

Optional Inputs

ALPHA K: Use to change the default significance level of 0.05 to a value you specify.

Running the Macro

Suppose your data are in C2. To run the macro, choose View > Command Line/History and type:

%MKTREND C2

Click Run.