Excel Autocorrelation Calculation (1 Viewer)

[Andy Teal]

Hello Experts,

I'm working with vibration sensor data in Excel, and I've got a set of 1808 values representing samples from one shaft rotation. I'm not an Excel or stats expert, but I've heard about Autocorrelation, which should give values between +1 and -1.
I want to use Autocorrelation to create a chart that visually shows one shaft rotation. I'm not sure how many lag segments to use, but once I figure out the right setup, I can experiment with it.
Can you guide me on how to approach Autocorrelation in Excel or suggest a relevant article for this purpose?

Much appreciations!

 

[bob fitz]

Have you tried Google: calculate autocorrelation in excel

e.g. https://www.statology.org/autocorrelation-excel/

 

[Gasman]

Have you tried Google: calculate autocorrelation in excel

e.g. https://www.statology.org/autocorrelation-excel/

Now there is an idea Bob.
You could swear people have never even heard of it.

 

[bob fitz]

Now there is an idea Bob.
You could swear people have never even heard of it.

It's surprising the little tips you can pick up from places like this