You may wish to back up your data file before doing the bootstrap as each bootstrapped sample overwrites the original data. The bootstrapping may be done in the EXCEL spreadsheet as follows:
- Ensure that you only enter complete cases in the spreadsheet in columns A and B
- Firstly highlight the cells cell AO3 which contains the percentage bend correlation in the spreadsheet
- Go to Add-ins and click on 'bootstrap' in the far left corner which opens up the bootstrap macro written by Barreto and Howland.
- A dialogue box should appear: prompting you to insert the original sample which are the cells in columns A and B containing the two sets of data to be correlated
- Next choose the same block of cells containing the data as above to represent the space where the bootstrap samples are written
- Highlight cell AO3 which contians the percentage bend correlation and enter this in the box corresponding to the cell to be tracked
- You can keep the 1000 as the default number of bootstrap samples. (Wilcoxon's R programs uses 599 bootstrap samples). You can also ask for all the raw bootstrap values to be outputted.
- Click the 'Proceed' button
- The results of each computation of the cell you selected in step one (the percentage bend) for each bootstrap sample are outputted in a sheet called 'Bootraw'. These can be used to obtain endpoints for a 95% confidence interval for the correlation using, for example, the percentile function by typing in a couple of cells commands of form: PERCENTILE(A2:A1001,0.025) and PERCENTILE(A2:A1001,0.975) in the outputted 'Bootraw' spreadsheet.