Running a Durbin Watson test with XLSTAT-Time
Dataset for running the Durbin-Watson test
The data have been obtained in Lewis T. and Taylor L.R. (1967). Introduction to Experimental Ecology, New York: Academic Press, Inc.. They concern 237 children, described by their gender, age in months, height in inches (1 inch = 2.54 cm), and weight in pounds (1 pound = 0.45 kg). The spreadsheet with the data can be downloaded here.
We have run a simple linear regression between the height and the weight to get the residuals.
Goal of this tutorial
Using Durbin-Watson test, we want to detect if the residuals from a linear regression are autocorrelated or not.
Setting up a Durbin-Watson test
After opening XLSTAT, select the XLSTAT / XLSTAT-Time/Durbin-Watson testcommand, or click on the corresponding button of the XLSTAT- Time toolbar.
Once you've clicked on the button, the dialog box appears.
Select the data on the Excel sheet. In our case, the residuals are obtained via the linear regression between the height and the weight and the explanatory variable is the "Height".
As the column header was selected for the variables, the Variable labels option needs to be activated.
On the Options tab, the user can set the significance level of the test and the order (number of lags). Here we choose to leave the default values.
The computations begin once you have clicked on OK. The results will then be displayed in a new sheet.
Interpreting the results
The first results displayed are the statistics for the residuals. Next the results of the Durbin-Watson test and a short interpretation are displayed.
Since the p-value is greater than the significance level (5%), the null hypothesis cannot be rejected.
Click here for other tutorials.