Correlogram Analysis

The Correlogram functionality automates the statistical analysis of serial correlation, model order identification, and exploratory patterns in a data sample.


To use this functionality, select the corresponding icon on the toolbar (or the menu item).

This figure show the location of the correlogram icon in the summary statistics section of NumXL toolbar

Point to the data sample on your worksheet, select the maximum number of lags for both ACF and PACF analysis, choose a table and/or graph presentation, and designate a location on your sheet to print the ACF/PACF tables and the Correlogram graph.

Correlogram settings dialog


Upon completion, the function outputs the ACF/PACF along with confidence limits (if selected) as formulas (instead of raw numbers) in the designated location of your worksheet




Article is closed for comments.

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