ABSTRACT
All of the designs described in chapter 5 can be subjected to randomization tests within Microsoft Excel using the same general procedures. We suggest that you begin by copying all of the files in the Excel subdirectory on the companion CD-ROM to a convenient directory. The files are Excel workbooks with .xls extensions (design1.xls to design8unique. xls). Each workbook comprises a macro that contains the commands necessary to run a randomization test and a data worksheet with the example data from chapter 5 entered. To run a macro, the workbook first has to be opened in Excel. It will be necessary to respond to the warning about macro viruses by clicking on the Enable Macros button. Opening the workbook will result in the example data being displayed in the worksheet (Sheet 1). The next step is to edit the worksheet so that it contains your own data, remaining in conformity with the worksheet specifications given in chapter 5. To edit a worksheet, simply replace the numerical entries in all columns with your own values, making sure that you leave the labels in the first row unchanged. Some of the macros require an initially empty column and some cells of the worksheet to be named, but column names have already been inserted where they are needed (labeled both in Designs 3 and 4, and arrange in Designs 5 and 5a) and the cell numbers are automatically adjusted for your own data by Excel, so you do not need to worry about these extra names. When you have entered your own data in the worksheet, you may wish to use File>Save As to store it under a new name. Then, when you close the workbook, you can say you don’t wish to save the changes you made, and you will still have the original example data and macro under the original name.
