Using Excel For Principles Of Econometrics Pdf Site

Run the regression using the ToolPak. Compare your R-squared and AIC to the textbook’s Table 6.3. If they match within rounding error (typically ±0.001), your Excel setup is correct.

Ensure your dependent variable ($y$) and independent variable ($x$) are in adjacent columns. using excel for principles of econometrics pdf

Compare your DW to the PDF’s critical table (dL and dU). In Excel, use =IF(DW < dL, "Positive Autocorrelation", "Inconclusive") . Run the regression using the ToolPak

: Once enabled, these tools appear under the Data Analysis button in the Data tab. Core Econometric Applications in Excel use =IF(DW &lt