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!
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!