The null hypothesis for the Durbin-Watson test is H0: Ļ = 0, and the alternative hypothesis is Ha: Ļ ā 0. To calculate the Durbin-Watson test statistic in Excel, follow these steps:
1. Calculate the first-order differences of the data.
2. Square the first-order differences.
3. Sum the squared first-order differences.
4. Divide the sum of squared first-order differences by the sum of squared data.
5. The result is the Durbin-Watson test statistic. Round to two decimal places.