All you need to do is paste your group of samples into a worksheet in the
workbook with the macro. IT MUST BE IN A COLUMN!!!! Then, push the button!
You will be asked for the first and last cell of your data. This is as simple as "A1" in the first message box, then "A92" in the second message box.
The macro will ask you how many samples you want to pick each time. Then, you will be asked how many repetitions you want to perform. The macro will do the rest! You need to be sure that you have the Data Analysis add-in installed in your Excel.
I have succeeded in changing the macro to accept any data set you want to give it! The macro now finds the range of your bootstrapped set, and lets you know what it is. At this point, it gives you the range, and you tell it the increments you want to calculate. If you have a range of 0 to 10, you can use 0.25, or 0.5. If you have a range of 0 to 1000, it might be better to use 50 or 100. All this will affect is the appearance of your graph...
Have fun!
Description of the macro.
Download the macro.
Back to the program list.
This page was last updated on: August 28, 2002 by David G. Cox