NumXL 1.67 MARTHA public availability

A Correlogram tale

This issue is brimming with info about a key tool in our time series arsenal toolbox: correlogram analysis. We take you first through the auto-correlation and the partial auto-correlation functions definition. Next, we derive and highlight the common patterns in the ACF and PACF plots generated by AR, MA, and ARMA type of processes. Finally, we draw a number of observations and drive quick intuitions to further help us identifying the candidate model(s) and its order using only ACF/PACF plots set.

The exercise will leave you with a thorough understanding of correlogram analysis while demonstrating how NumXL can help you find an ideal model for your data.

For more details and a step-by-step tutorial, along with a downloadable spreadsheet and PDF, click this link: A Correlogram Tale

Leave a Reply

Your email address will not be published. Required fields are marked *

We are glad you have chosen to leave a comment. Please keep in mind that comments are moderated according to our comment policy.