Stationary Test - Augmented Dickey-Fuller (ADF)

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 stationary 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.
  3. The Stationary Test dialog box appears.
  4. Select the cell 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 stationery, 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.

Stationary Test Output

The test wizard generates the output table as shown below:
The stationary test(s) output table as generated by NumXL functions and Wizards.


Please sign in to leave a comment.

Was this article helpful?
4 out of 6 found this helpful