Chow Test Dummy Variable Excel

ARCHIVED: In Stata, how do I conduct the Chow Test?

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

The Chow Test examines whether parameters (slopes and the intercept) of one group are different from those of other groups. If you are interested only in differences among intercepts, try a dummy variable regression model (fixed-effect model).

Suppose you suspect that the impact of on employees' varies across companies; the slope of one company is different from the slopes of other companies. For the sake of convenience, consider only two companies (= 1 or 0) here; and are covariates.

The pooled model, which assumes both companies have the same slopes and intercept, is as follows:

. regress motivation salary size culture

You may fit separate regressions as follows:

. regress motivation salary size culture if d == 1 // for company 1. regress motivation salary size culture if d == 0 // for company 2

For the Chow Test, create an interaction term of the regressor and the dummy variable, and then fit the model with the interaction and the dummy as follows:

. gen salary_d = salary * d. regress motivation salary salary_d d size culture

The coefficient of is the deviation of the second company's intercept from the baseline intercept (= 0). Likewise, the coefficient of is the slope of the baseline company, and the coefficient of is the deviation of the comparison group's slope from the baseline slope.

Now, conduct the Chow Test using the command. The null hypothesis is that two companies have equal parameters for and intercept; Deviations of the slope and intercept are not statistically discernible from zero.

. test _b [salary_d] = 0, notest. test _b [d] = 0, accum

The option suppresses the output, and tests a hypothesis jointly with a previously tested one. Rejection of the null hypothesis means that two companies do not share the same intercept and slope of.

For more details about the Chow Test, see Stata's Chow tests FAQ.