Hi Suman,

For the Mann Kendall test pls go through the attached pdf. You will get the sufficient information. 

Thanks. Details of Mann-kendall will be helpful for me.

Here is our paper on the desired topic: http://www.mdpi.com/2225-1154/3/1/210

Follow the Link and its references (Especially the book  by Gilbert, R.O. 1987). You will find the explanation with workout example. If you can not manage the book, send me an email. I will try to send a scanned copy of this section for you.

http://vsp.pnnl.gov/help/Vsample/Design_Trend_Mann_Kendall.htm

Ok, I got it.

Dear Suman,

The Mann-Kendall test tells you if any series of dimension J has a significant monotonic tendency or not. It is quite useful to detect any possible trend and also if a break point (or several if the test is applied to part of the series) affect the series. Attention, the test is not adapted to detect any non-monotonic trend. Pay also attention if any tie is present in the series since some corrections must be applied to the computation of the variance to determine the statistics to be tested. The Sen's slope tells you the slope of the linear tendency of your series.

Hope that this can help you!

Regards,

G.C.

Thanks to all for the assistance.

Does MAKESENS - excel template provide modified mann kendall test for autocorrelated data?

Mr. Suman Kumar Kundu,

Use the package 'modifiedmk' in R for modified Mann-Kendall test by Hamed and Rao, Yue and Wand, Pre-whitening, Trend-Free Pre-Whitening, Sen's slope and Speraman's rho calculations

Dear Suman

You can use XLSTAT. That is an extension installed in excel and very easy and useful.

i have been also helped in this conversation. i have been looking for the answers on the same