Your data analysis solution

Mann-Kendall trend test in Excel tutorial

2018-11-09

This tutorial will help you compute run and interpret a Mann-Kendall trend test on a time series in Excel using XLSTAT.

Dataset to perform a Mann-Kendall trend test

An Excel sheet with both the data and the results can be downloaded by clicking on the button below:
Download the data

The data have been obtained in [Box, G.E.P. and Jenkins, G.M. (1976). Time Series Analysis: Forecasting and Control. Holden-Day, San Francisco], and correspond to monthly international airline passengers (in thousands) from January 1949 to December 1960. It is widely used as a nonstationary seasonal time series. Our goal is to test whether there is a trend in the time series.

hw1.gif

Setting up a Mann-Kendall trend test with XLSTAT

After opening XLSTAT, select the Mann-Kendall trend tests under the Time series analysis menu.

The Mann-Kendall dialog box appears.

Using the demo file, select column B (Passengers) in the Time series field and column A (Month) in the Date data field. 

As we selected the column headers, we leave the option Series labels activated.

XLSTAT offers two tests: the classical Mann-Kendall test to test if there is a trend in the time series; the seasonal Mann-Kendall test that takes into account the seasonality in the time series (here 12 months). Here, we will show how to apply the second one, so we choose the Seasonal Mann-Kendall Test and enter 12 in the Period field  (period = number of lags between two seasons).
We also assume that the series are dependent (eg values of January and February are dependent) so we activate the option Serial dependence.  

In the Options tab, we select tau<>0 as an alternative hypothesis.

Once you have clicked the OK button, the computation starts. The results are then displayed.

Interpreting the results of a Mann-Kendall test

The first output displays the descriptive statistics of the series followed by results of the test. In this example, we consider the fact that our time series are seasonal with a seasonality of 12 months. The seasonal Mann-Kendall test takes into account the 12-month seasonality and tests whether there is a trend not due to seasonality. 

The Kendall's tau is even closer to 1 when we take into account the seasonality. The p-value shows that the null hypothesis is rejected; we can conclude that there is a trend in our time series when we take into account the seasonality.

1c26995d494fb3061dd0ae8571ffc0a4@xlstat.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283