Periodogram- looking for cyclical data.

[farmerscott]

Hi Everybody,

Can anyone help me look for cyclical data. I have some rainfall data that I want to test.

I am not sure if we can build any formulas from scratch or we need xlstats.

Thanks for your time.

FarmerScott

 

[Michael M]

Hey Scott
I'm guessing your rainfall data would be an almost zero graph wouldn't it !!!
Hasn't been much of the moisture around, and it seems to be ongoing.
However, there is a couple of links in this old post which might be of use....

https://www.mrexcel.com/forum/excel...ogram-partialcorrelogram-add-please-help.html

 

[farmerscott]

Mate,

Will have a look at the link.

Correct the rain gauge is getting a nice long holiday at the moment.

cheers.