Using the EXCEL spreadsheet to compute the HC4-based bootstrap estimate (estimate 2.3) of Ng and Wilcox (2010)

The spreadsheet on the previous page uses the recommended approach of Ng and Wilcox (2010) using their model 2.3 which they found controls for type I error when assumptions underlying regression analysis are relaxed. In particular it evaluates the t-statistic for the x by group interaction term over a series of bootstrap samples generated by a bootstrap macro which you need to add-in to EXCEL which you an download from [ http://www3.wabash.edu/econometrics/EconometricsBook/Basic%20Tools/ExcelAddIns/bootstrap.htm here.] Details of how to add this into SXCEL (only needs to be done once on your PC) are given on the website and in a MS Word document downlaoded from this website given [:FAQ/EXCELmed: here.] When correctly installed it should appear

This macro will only handle complete cases so copy and paste your complete cases into the green area of sheet 1 of the spreadsheet representing the outcome (Y), continuous variable (X) and group (C). The HC4 asymptotic t-test of Cribari-Neto (2004) should then be produced in the cells to the right of the data. Some numbers will appear in the yellow column of sheet1. This MS word file contains instructions on how to obtain the bootstrap HC4 estimate's p-value.