Increase the data variation range

**jdbaba** · 11-03-2011, 02:53 PM

Hi All,

I have time series of water level data. The data is tidal data and it has a variation like a sinusoidal curve. What I want to do is I want to increase the variation of the time series. I want a program or code to find out the maximum of the sinusoidal curve and then increase the values. I want to increase the peak in both negative and positive. I don’t know how to do that in excel . Would somebody give me some tips on how to proceed ?

The attached figure shows the time series of two sets of data. One is current and another is new . I want the increase the variation of new data in both higher and lower direction by 0.2. HOw do I do this ?

Thanks

JD

**6StringJazzer** · 11-03-2011, 09:50 PM

Do you want to multiply the data by 0.2, or increase the magnitude by 0.2 (i.e., add 0.2 to positive number and subtract it from negative numbers)? What is the relationship between the max of the curve and this number?

Also, see my signature re: attaching images.

**jdbaba** · 11-04-2011, 01:18 PM

Thanks 6StringJazzer for your suggestion. I also thought same before but the data are not such that the peak is positive and the bottom peak is negative. So I did the average of each day and subtracted the average from the data. The whole series is now changed such that the upper peak would be positive and bottom peak would be negative and then I used your suggestion which worked perfectly.