Updates and Typos
This page maintains a list of all changes to the files on the CD and errata for the printed book. Download the corrected version by clicking on the relevant link. The workbook links from each individual chapter are also the latest versions of each workbook.
Word Documents
| Location | Document | Description | Date |
| Basic Tools/InternetData/CPS | [CPS.doc] | Changes in the documentation (location and format of codebooks) for Current Population Survey necessitated rewrite. | 23 Mar 2007 |
Excel Workbooks
| Chapter | [Workbook]Worksheet | Description | Date |
| 2: Correlation | [Correlation.xls]Patterns | Linear, Heteroskedastic and Nonlinear radio buttons switched | 13 Jan 2006 |
| 4: Computing Regression | [Reg.xls]minSSR, Q&A |
ShowSymbols macro was off by one row; added a Q&A question | 16 May 2006; 19 Jan 2007 |
| 9: Monte Carlo Simulation | [MonteCarlo.xls]MCSim | Excel 2007 produces a "1004" VB error when you run a Monte Carlo from the sheet. Unlike previous versions, Excel 2007 cannot handle a blank in the Series formula. | 23 Oct 2007 |
| 10: Review of Inferential Statistics | [BoxModel.xls] | Excel 2007 produces an error when drawing probability histograms involving ChartObjects.Delete. | 24 Oct 2007 |
| 14: The GaussMarkovTheorem | [GaussMarkovUnivariate.xls]ComputingSEs | Buttons did not work correctly for changing estimators. Error generated when running Monte Carlo in Excel 2007.
|
19 Feb 2007 26 Aug 2007
|
| 14: The GaussMarkovTheorem | [GaussMarkovBivariate.xls]ComputingSEs | OLS weights were not being recalculated immediately when Xs changed. Fixed Excel 2007 Monte Carlo chart issue (removed blanks from Series formula). | 9 Apr 2008 |
| 15: Understanding the Standard Error | [SEb1OLS.xls]MCSim | MCSim button prompts corrected typo ("integer" replacing "Long") and fixed Take a Picture button | 23 Feb 2006 |
| 15: Understanding the Standard Error | [SEForecast.xls]TwoComponents | View Chance Error components button was malfunctioning in Excel 2007. | 26 Aug 2008 |
| 15: Understanding the Standard Error | [SEForecast.xls]MCSim | View Forecasted Y's button was malfunctioning in Excel 2007 | 26 Aug 2008 |
| 15: Understanding the Standard Error | [SEForecast.xls]MCSimTriVariate | View Forecasted Y's button was malfunctioning in Excel 2007 | 26 Aug 2008 |
| 16: Confidence Intervals and Hypothesis Testing | [LinEstRandomVariables.xls]Data | Reset to Intro button was failing in Excel 2007. | 26 Aug 2008 |
| 16: Confidence Intervals and Hypothesis Testin | [LinEstRandomVariables.xls]ErrorDist | Draw Histogram button was not working in Excel 2007. | 26 Aug 2008 |
| 17: Joint Hypotheses | [ChisquareDist.xls]1, 3, and50 | Code inexplicably set chart linestyle to xlNone so it was not visible. Deleted these lines and works well. | 26 Aug 2008 |
| 17: Joint Hypotheses | [Correlated Estimates.xls]MonteCarlo | Run Monte Carlo button wasn't working in Excel 2007 | 26 Aug 2008 |
| 18: Omitted Variable Bias | [ComputerUse1997.xls]MCSim | Monte Carlo button malfunctioning in Excel 2007. | 26 Aug 2008 |
| 19: Heteroskedasticity | [Het.xls]Univariate | "View Residuals" button didn't work in Excel 2007; code changed. |
4 Aug 2008 |
| 19: Heteroskedasticity | [Het.xls]GenBiVar | Trendline redrawn to enable equation to refresh correctly; Title of chart corrected to read "SD Bands" instead of "SE Bands" |
17 Aug 2005 17 May 2006 |
| 19: Heteroskedasticity | [Het.xls]SimpleBiVarMC | MCSim button fixed to place P-value results in proper column. | 30 Mar 2006 |
| 19: Heteroskedasticity | [Het.xls]UniMCSim | View Instrument 1 vs. Instrument 2 button does not work in Excel 2007. Fixed. | 26 Aug 2008 |
| 19: Heteroskedasticity | [HetRobustSE.xls]ComputingSE | View Graph of Contributions to Variance button does not work in Excel 2007. Fixed. | 26 Aug 2008 |
| 19: Heteroskedasticity | [HetGLS.xls]UniMCSim | View Instrument 1 vs. Instrument 2 button does not work in Excel 2007. Fixed. | 26 Aug 2008 |
| 19: Heteroskedasticity | [HetGLS.xls]UniMCSim | Monte Carlo Simulation didn't work in Excel 2007. Fixed. | 26 Aug 2008 |
| 20: Autocorrelation | [Autocorr.xls]AR1Process | GenerateAnotherObservation button does not work in Excel 2007. Fixed. | 26 Aug 2008 |
| 20: Autocorrelation | [AutoCorr.xls]AR1Model | Trendline redrawn to enable equation to refresh correctly in first scatter plot. Also, Excel 2007 produces a "1004" VB error when you run OLS v FGLS Monte Carlo. Unlike previous versions, Excel 2007 cannot handle a blank in the Series formula. | 15 May 2008 |
| 20: Autocorrelation | [FreeThrowAutoCorr.xls]AR1Model | Monte Carlo simulation does not update in Excel 2007. Fixed | 26 Aug 2008 |
| 22: Dummy Dependent Variable Models | [LPMMonteCarlo.xls]Data | Old version of NormalRandom function replaced. Previously the Votes Yes cells were being computed incorrectly. | 20 Sep 2005 |
| 22: Dummy Dependent Variable Models | [NLLSFit.xls]ProbitNLLS10 | Removed Analysis Options button. | 2 June 2008 |
| Basic Tools/RandomNumber | Random.xls | Added functions for LINESTA (running LINEST on only Y>0 values) and RandomSample (drawing samples from a population with and without replacement). Added function MultivarXs to create a multivariate population which has a specified exact correlation matrix and exact means and SDs. The RandomSample and MultivarXs functions can be used to teach basic concepts using stochastic Xs; Fixed error in a routine for matrix multiplication (2 Mar 2007). This is only a problem for users of VecMatVecMult; if you haven't heard of that routine ignore this fix. |
18 Apr 2006;
2 Mar 2007 |
Excel Add-Ins
To update an installed add-in, quit Excel, find where the add-in is located on your hard drive, right-click on the desired add-in (from the list below), choose "Save Target As" or "Save Link As" (depending on your browser) and save it to where your original add-in was located. Launch Excel and click on the Tools menu to use the add-in (execute Tools: Add-ins if needed to make the add-in available in the Tools menu). For more detail, see InstallingAddinOverPreviousVersion.doc
| Add-in | Description | Date |
| Histogram.xla | Adjust bins feature does not work when there are missing values. We have not yet corrected this. | 21 Oct 2005 |
| Histogram.xla | Adjust bins feature didn't work in Excel 2007. This has been fixed. | 20 Sept 2008 |
| MCSimNV.xla | Enables Monte Carlo simulation with non-volatile cells. | 15 May 2006 |
| MCSim.xla | Includes error trapping for repetitions that give error messages in tracked cells. Allows up to as many rows and columns as are available for raw results. | 29 Apr2008 |
| DDVGN.xla | Enables estimation with more than 32,767 observations. The version on the CD included with the book reports an error when n>32,767. Also improved the way we handle cases of perfect classification. In addition, now includes functions for Logit and Probit NLLS estimation. 4 Oct 2006 revision corrects an error in Logit ML which crept in to the June, 2006 version. 18 Feb 2007 version corrects error in estimation of Robust SEs for NLLS estimation. Added companion Excel files which compare results to those from Stata. | 18 Feb 2007 |
| OLSRegression.xla | Added OLSReg function, which is analogous to Excel's LINEST but presents results in easier-to-read fashion; fixed problem with F stat in cases with no intercept (where whole model F test has a non-standard interpretation). Removed the constraint of up to 50 X vars -- works with hundreds of Xs (although very slow). Oct 2007 update contains latest functionality. | 14 Oct 2007 |
| PValue.xla | Added a workaround to an Excel 2007 refresh issue -- old PValue.xla will not display the picture in Excel 2007. This new version, 29 Apr 2008, works with all versions of Excel. | 29 Apr 2008 |
Answers
| Add-in | Description | Date |
| MonteCarloAns.doc | A better answer for Question 5 in the Q&A in MonteCarlo.xls. | 23 Mar 2006 |
Book Errata
Typos.doc: A list of typos and mistakes in the text. 3 Aug 2008
Last Update: 20 September 2008