# Finding Peak and Trough

1. ## Finding Peak and Trough

Hello all,
I need to find the Peak and Trough for all the points in the attached graph and the data point used for plotting it. How do i find it. (Beginner pls excuse)   Register To Reply

2. ## Re: Finding Peak and Trough

When you say peak and trough, do you just mean the co-ordinates of points on the graph? I'd use the following formula in the two rows next to the data, first just insert a row at the top and make cell A1 = 0:

In col B:

=AND(A2>A1,A2>A3)

In col C:
=AND(A2>A1,A2>A3)

THen just drag down. 'TRUE' in col B means it's found a peak, and 'TRUE' in C means a trough.

Let me know if it works!  Register To Reply

3. ## Re: Finding Peak and Trough

Thanks for the suggestion , But am getting only one peak value but I would need to find out all the Peak and Trough and as shown in graph i have attached and i need to find the average of the peak and trough to get a polynomial curve... and the result from it...  Register To Reply

4. ## Re: Finding Peak and Trough

OK, so how you plan to "get a polynomial curve"?
I prepared rough scatterplot and it does not look like really polynominal for me, but may be I'm wrong.
Anyway after you have the curve fitted then you "just need" local extrema (minima and maxima) - but having the fitted curve equation known it is usually relatively easy task.  Register To Reply

5. ## Re: Finding Peak and Trough

Looks like a harmonic function, probably some kind of step-like instead of a sinewave; there's drift in the amplitude and frequency over time (looks like amplitude is increasing and frequency is decreasing), as well as a trend downards that may be linear but I guess might be logrithmic. Well, it might have some kind of second or third order behavior as a sinusoid rather than actually being a modified square wave.

Anyway, I doubt it's exactly a polynomial.

I feel like figuring out what kind of equation is governing this behavior is too fuzzy for a computer. Once you've got the formulation you can drive the coefficients down with least squares + solver, but the human needs to figure out what's going on here.  Register To Reply

6. ## Re: Finding Peak and Trough

The above suggestion should return all local peaks and troughs.  Register To Reply

7. ## Re: Finding Peak and Trough

I think you need to apply a large binomial or Gaussian filter to the data to smooth it before trying to locate the extrema.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 