Correlogram Analysis in Excel

Brief tutorial for conducting a correlogram analysis for your time series in Excel using NumXL functions and wizards.

Video script

Scene 1:

Module 4: correlogram analysis. In this module, we will show how NumXL can provide correlogram analysis.

Scene 2:

For this module, I will use the same spider log returns as in module 2. Let's begin with our analysis. Switch to the NumXL toolbar tab or menu and click on the correlogram analysis icon.

Scene 3:

Select the cells range of the sample data in our workbook.

Scene 4:

You will also need to specify how your data has been chronologically ordered. Since our sample data is sorted so that the oldest entries are at the top, I can leave the ascending checkbox checked.

Scene 5:

Next, in the ACF section check the ACF option and edit the maximum lag order in our analysis. By default, the maximum lag is set to ten.

Now check the upper and lower limits option, as well as the graph option. Finally, enter the value for the significance level or leave the default of five percent.

Scene 6:

Do the same for the PACF, partial autocorrelation factor. In the output section both the table and the graph output range default to the current active cell. For our demo, we will leave them unchanged. Click OK to continue.

Scene 7:

Let's examine the output table and graph in the output table.

Examine the ACF entry the value is computed using the ACF function. The ACF function references the input sample data and the lag order of the table row index.

Next examine the ACF graph, upper and lower limits entries. The values are computed using ACFCI (.) function. The ACFCI function, reference the input sample data, the row index of the table, and the test significance level.

Scene 8:

This concludes module 4, if you have any questions, concerns, or feedback please call our toll-free number at 1(312) 324-0367 or email us at We look forward to working with you!



Please sign in to leave a comment.

Was this article helpful?
1 out of 1 found this helpful