In Series, enter a column of numeric data that were collected at regular intervals and recorded in time order.
This worksheet shows the first few rows of a table with 50 rows. Sales A contains the number of computers that are sold each month and is valid with Augmented Dickey-Fuller Test because the column has no missing values. Sales B is also valid with Augmented Dickey-Fuller Test because the column has only missing values at the beginning. Columns with missing values at the end or with missing values at the beginning and end are also valid. Sales C is not valid with Augmented Dickey-Fuller Test because a missing value is between two numbers in the series.
C1 | C2 | C3 |
---|---|---|
Sales A | Sales B | Sales C |
195000 | * | 195000 |
213330 | 195000 | * |
208005 | 213330 | 213330 |
249000 | 249000 | 208005 |
237040 | 237040 | 249000 |
… | … | … |
Enter the highest lag order to evaluate when fitting the regression model to calculate the test statistic. By default, the final highest lag order is the order for the regression model that minimizes the Akaike Information Criterion (AIC).
Select a criterion to determine the final highest lag order for the regression model that the analysis uses to calculate the test statistic. Usually, the default criterion of Minimum AIC works well.
Include additional terms in the regression model. The default is to include a constant term which says that the mean of the series is non-zero if the series is stationary.
Select whether to show the original time series data, the differenced time series data, or both series of data in plots. Select Time series, autocorrelation, and partial autocorrelation to show the plots for the chosen series. Without this selection, the results do not include plots.