you may use this sheet. 

www.ilmanlaatu.fi/ilmansaasteet/julkaisu/pdf/MAKESENS_1_0.xls

It is self explanatory and may be helpful to you.

The Mann-Kendall test is for detecting either an upward or downward trend in data collected over time.I suggest you to use MINITAB software which gives you enough analysis information.

http://support.minitab.com/en-us/minitab/17/macro-library/macro-files/nonparametrics-macros/mktrend/

Mann-Kendall test is a non-parametric trend test which can be used to detect the trend in meteorological time series like precipitation, or other time series. Non-parametric tests do not require the data-set to be normally distributed.

It shows the statistical significance of the identified trend on different confidence levels, by calculating an index called z-score. Sign of the z-score shows the direction of the trend and higher the value of it, higher the confidence level of the statistical significance of the trend.

If you are using MATLAB, you can use this code for the calculations:

http://www.mathworks.com/matlabcentral/fileexchange/25531-mann-kendall-test

a good algorithm in matlab can be found in (http://www.mathworks.com/matlabcentral/fileexchange/25533-mann-kendall-modified-test)

good luck

Hi, Mohsin Siddique

Mohsin Siddique or any one.

Could you please show to math function of excel in MAKESENS file, especially Trend statistic as step by step how to find each value, because I do need to do my study as fast as possible. please help me to solve this problem.

Thank you

Modified Mann-Kendall Test For Serially Correlated Data Using Yue and Wang (2004) Variance Correction Approach.

Code Modified Mann-Kendall Test For Serially Correlated Data Usin...

Modified Mann-Kendall Test For Serially Correlated Data Using Hamed and Rao (1998) Variance Correction Approach

Code Modified Mann-Kendall Test For Serially Correlated Data Usin...

I had a question. I used mmkh function of modified mann-kendall package. But it is giving the same result as mkttest function of mann-kendall package. But in the help pages it is written that mkttest is man kendall test without any modification while mmkh should be the modified mankendall test jsed by Hamed and Rao (1998). So if there is autocorrelation the results should be different.

please answer my question. I am badly in need of this answer.

Dear Dr. Roy,

Please share a screenshot of the results. Also, if possible may I have a look at the data!

The code is working fine I tested it again.

I have uploaded a CRAN package named 'modifiedmk' please check if you get solution using the package. Tutorial is also available as a word document for the package in my profile (may be as a project update)!

Thank you so much for your quick response Sir. Here I uploaded my serially correlated data set bin.csv and the screenshots of the results I found using mkttest and mmkh functions. This data set has lag 1 autocorrelation. I have checked it earlier. So according to my knowledge mkttest is mann kendall test without any autocorrelation correction and mmkh introduced by Hamid and Rao is a modified mann Kendal test which can remove complete serial correlation of the data set. So according to this knowledge the results of Z should be different. But here the results I found using mkttest and mmkh are the same.

P.S. I am a graduate student, not a PhD holder.

Dear Dr. Binata Roy,

It is perfectly normal in some cases. Variance of the data doesn't change even after variance correction.

It is not an error. You can proceed further with your analysis. Also, if you like, you can use mmkh3lag as first three lags are considered in many studies (refer the citation in the help file)

What is the difference between the Mann Kendall Test and the modified Mann Kendall Test?

John...please refer to literature. In modified Mann Kendall test, we try to eliminate the effects if Auto correaltion in the days and there are more than one way of doing it. Hence there is no single version if modified Mann-kendall test. There are a few ways if doing it. Refer any standard review paper for further details.

I would like to know how to use mann kendall for monthly series of data from two rainfall stations with same distribution of data ( i.e1970-2000)

Dear sir;

I have this result with Mann kendell modified

what can i say about trend !! i compare P value (old an d new) or just corrected z and original z.

Corrected Zc new P-value N/N* Original Z old P.value Tau

1.315615e+00 1.883033e-01 1.000000e+00 1.315615e+00 1.883033e-01 1.086957e-01

Sen's slope old.variance new.variance

1.215840e+00 3.727433e+04 3.727433e+04

before performing Modified mann kendall test should i apply auto correlation on my time series data or directly i should apply the test on raw data.. and how should i interpret the result for trend. KIndly help

@Vishal Sharma, You have to perform autocorrelation test and then perform trend tests.

Sandeep Kumar Patakamuri I want to perform MMK trend test for raster data. How can I do that in R?

Shoaib Ali please follow the link below

https://www.researchgate.net/post/How_to_perform_Mann_Kendall_trend_test_for_raster_data_in_R

@Sandeep Kumar Patakamuri

Sir i did auto correlation first.and then have applied mann kendall test using mmkh function in R .. Now how should i interpret my results ... Literature says if values of p is less than 0.05 then that Z values will tell you regarding trend ...

Vishal Sharma Please refer to the attached publication. Also, I would suggest checking the data for Homogeneity before performing climatological analysis.

Article Long-Term Homogeneity, Trend, and Change-Point Analysis of R...

Sandeep Kumar Patakamuri Dear sir, I know about that link which one you shared. I already have performed Mann Kendall trend test for raster data. I asked you , how to perform Modified Mann Kendall trend test for raster data?

Shoaib Ali In the same way as you have performed Mann-Kendall test. Just change the function based on your requirements.

'modifiedmk' package have a variety of modified Mann-Kendall tests to experiment with. Refer the package documentation for further help.

Dear Sir, Please can the Mann-Kendall test run for 3 decades in trend analysis?