Find max/min value for each wave/period in a sine wave shaped chart

sigoynern

New Member
Joined
Jan 8, 2013
Messages
4
Hey folks!

I’m new here, so far so good:)

I have a 14 list of 29000 numbers each which I’ve made some charts from. All the charts have a sine wave-function shape but the min and max values are never the same. I want to find the average max and min value for each chart. But then I need to read the max and min value for each wave/period.
It’s possible to arrange the mouse marker at points from the chart to read the values, but is there an easier way to find max/min value for each period?

Screenshoot from one of my charts is comming asap

thanks for helping me out
 
Last edited:

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
<a href="http://s1310.beta.photobucket.com/user/sigoynern/media/chart-shape_zpsa241f67c.jpg.html" target="_blank"><img src="http://i1310.photobucket.com/albums/s657/sigoynern/chart-shape_zpsa241f67c.jpg" border="0" alt="Photobucket"/></a>


A screenshoot of the chart.
 
Upvote 0
Hey folks not alot of tips. Maybe my question was a little confusing. I'm interrested in getting the local max and min for the charts shown in the screen shot above.
All the charts are wave shaped with 30 waves per chart. I want to find the local max/min values for each wave/periode.

Example. look at the Force_Z_pers1.
It has 30 max and 30 min values. the first local min=-1100 and the max=-136.
These values can be found either by pointing the mouse arrow above the wanted position, or by scrolling down the list tracking the change of the values to find the max/min value.

But like I said, these processes are time consuming and I'm wondering if there is another way.

Hope to get some answers:)
 
Upvote 0
THanks for your interest.

I have all the raw data's so its possible for me to go through all the numbers but that will take a long time

regards sigurd
 
Upvote 0
If you have the data, we can do a curve-fit. Once we have the parameters for the model equation (sine wave, dampened harmonic oscillator, etc.), we can directly calculate local maxima, minima, inflection points, etc.
 
Upvote 0

Forum statistics

Threads
1,214,649
Messages
6,120,732
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top