Hi, please could someone offer some suggestions as to how to find the peaks and troughs when dealing with large samples of data?
Here is an image of the produced graph:
I have searched and tried to use some of the ideas in other threads, but I have a few problems:
1. my data has 2500 points, the points have some fluctuations. The tip of the peaks shown in the image are composed of say 100 points which have some variation. Therefore finding the largest number will not work.
2. the peaks change in size. therefore I can't use LARGE and SMALL functions to find the highest and lowest points. i.e. the points leading up to a big peak are greater than the peak of the small peaks.
Please could someone point me in the right direction as to how to solve these two issues?
Any help would really be appreciated. I have attached the spreadsheet to show the data variation issue.