Regression Stability Test

To conduct the Chow Test for regression stability, we need to define our sample subsets.

For this tutorial, we selected the first nine (9) observations as our first data set, and the last ten (10) observations as our second data set.

Input data set - monthly sales for 20 sales persons.


Now we are ready to conduct the test. First, locate the statistical test icon in the NumXL tab and click on the “Regression Stability” item in the drop‐down list.

  1. Select an empty cell to store the Regression stability test output table
    Select an empty cell in your worksheet to display the normality test results.
  2. locate the statistical test icon in the NumXL tab and click on the “Regression Stability” item in the drop‐down list.
    Locate and click on the regression stability test icon in NumXL toolbar
  3. The regression stability wizard (form) pops up.
  4. Select the cell range for the dependent variable and the explanatory variables for data set 1, and do the same for data set 2.
    Select the input data cells range in The regression stability test dialog/wizard
    Note: In this case, the regression intercept or constant will be estimated from our data. In other cases, where the intercept is fixed to a given number (e.g. zero), then we should put this number there.
  5. Selecting the input data cell range will enable the “Options” and “Missing Values” tabs. Click the “Options” Tab.
  6. In the options tab.
    Options tab in the regression stability Test dialog in NumXL
  7. If your data include one or more intermediate observations with missing values, click the “Missing Values” tab.
  8. Initially, missing values are dropped from the sample data. If you wish to change this behavior/treatment, select an alternative method.
    regression stability test dialog missing-values
  9. Now, Click “OK” to generate the test output table.


The Chow test (regression stability test) wizard generates the output table as shown below:
The output table for the regression stability test in Excel using NumXL Wizards and functions



This regression stability test function and wizard are available starting with version 1.60.

Tutorial Video


Article is closed for comments.

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