Determing deviation from the mean(number of sigma) and plotting

Hello everybody

I have Rain and DI values for 40 years and I want to plot deviation of individual years from the mean similar to this plot. How can I determine deviation of each year from the mean based on number of siga(6 sigma). I have put the rain values in the attachment.

Thanks in advance

Answer 1

[Rishik Ramena]

You can use the mean and std function to get the mean and standard deviation of your timeseries data. You can then use a formula like (data-mean)/standard deviation to get the deviation of your data in multiple of sigmas. Then use the plot function to plot the deviations along with the data.