Augmented Dickey-Fuller (ADF) Stationary Test

To test whether a given time series is stationary or not, we apply an indirect test for the existence of a unit root. The two common tests for unit root are Augmented Dickey-Fuller (ADF) and Kwiatkowski–Phillips–Schmidt–Shin (KPSS). The ADF test incorporates a deterministic trend (and squared trend), so it allows a trend-stationary process to occur.

NumXL provides an intuitive interface to help Excel users conduct stationary tests using several scenarios. In this tutorial, we’ll demonstrate the steps to conduct this test using NumXL functions in Excel.

  1. Select an empty cell to store the stationary test(s) results table.
    select an empty cell where you wish the stationary test results to be generated in your excel worksheet
  2. Locate the Statistical Test (STAT TEST) icon in the toolbar (or menu in Excel 2003) and click on the down-arrow. When the drop-down menu appears, select “Stationary Test”.
    Stationary Test icon in NumXL toolbar in Excel 2007/2010
  3. The Stationary Test dialog box appears.
  4. Select the cells range for the input data.
    General tab in NumXL Stationary test dialog in Excel
  5. Click the “Options” tab. Select which unit root tests and scenarios you’d like to use to test for stationarity (i.e. trend-stationary, trend-squared stationary, etc.)
    Options Tab in NumXL Stationary test dialog in Excel
  6. If your data include one or more intermediate observations with missing values, click the “Missing Values” tab.
    Missing values treatment tab in NumXL Stationary test dialog in Excel
  7. Click OK to generate the output table.
  8. The test wizard generates the output table as shown below:
    The stationary test(s) output table as generated by NumXL functions and Wizards


Have more questions? Submit a request