hot to calculate peaks of an "irregular" sine wave
Hello,
I just posted this also in .programming, but maybe this is the more appropriate NG. I need to calculate the distance between each peaks of an irregular sinusoidal wave, similar to this one http://imageshack.us/photo/my-images/528/grapha.jpg , where each peak is represented by a red dot. I am a very beginner with excel so I am already sorry for my questions. I have the charts (and I also would like to show on the chart each peak, as in the picture above I simply put a big red dot with Paint) and all the values of the curve, obviously. I am looking for a function/algorythm to calculate these peaks and their distance, as I need to do a similar task with several spreadsheets. These datas are taken from a gyroscope, a device to measure (also) changes in angles; for its intrinsic characteristics, it tends to drift (without a linear pattern, even it may seem linear). Any helps would be more than appreciated! |
hot to calculate peaks of an "irregular" sine wave
On Nov 10, 12:39*am, federico tiso wrote:
Hello, I just posted this also in .programming, but maybe this is the more appropriate NG. I need to calculate the distance between each peaks of an irregular sinusoidal wave, similar to this onehttp://imageshack.us/photo/my-images/528/grapha.jpg , where each peak is represented by a red dot. I am a very beginner with excel so I am already sorry for my questions. I have the charts (and I also would like to show on the chart each peak, as in the picture above I simply put a big red dot with Paint) and all the values of the curve, obviously. I am looking for a function/algorythm to calculate these peaks and their distance, as I need to do a similar task with several spreadsheets. These datas are taken from a gyroscope, a device to measure (also) changes in angles; for its intrinsic characteristics, it tends to drift (without a linear pattern, even it may seem linear). Any helps would be more than appreciated! The drift looks like it may be a random walk, but is the period reasonably regular? xt |
All times are GMT +1. The time now is 07:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com