I have data set of some three hundred values measuring a population over time and I want to calculate the frequency of oscillation in its plot—effectively measuring the frequency of boom and bust cycles. Any thoughts on the right function (or series of functions)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Measuring Frequency of Oscillation
- Thread starter mlocsin
- Start date
Damon Ostrander
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 4,239
Hi mlocsin,
Probably the best method mathematically to determine the frequency content of the values is to use the Fourier transform to convert the time series into the frequency domain. I recommend you check out the Fourier Analysis Tool in the Analysis ToolPak.
Probably the best method mathematically to determine the frequency content of the values is to use the Fourier transform to convert the time series into the frequency domain. I recommend you check out the Fourier Analysis Tool in the Analysis ToolPak.
Upvote
0
