Mouse Behavioral Testing

Mouse Behavioral Testing
Douglas Wahlsten
Several chapters in the book refer to utilities written for Microsoft Excel that prepare data sheets or do complex calculations. The utilities are grouped under the respective chapters. Although the files can be accessed without having the book close at hand, they will be much easier to utilize correctly with the aid of the book. The utilities were created with the version of Excel in Office 2007 that uses the xlsx file type, then saved in the xls format. They should run correctly with Excel from Office 2003, 2007 or 2010. Each sheet of a utility is protected with a password so that the user can enter new values into only certain cells. Other cells are locked and formulas are hidden. For most utilities, the cells that can be altered are yellow, except in the Design utilities where several colors are shown. Automatic recalculation is turned OFF, and the user needs to press F9 Recalculate to update any spreadsheet. Many of the utilities already have values entered and results calculated. The user can then enter new values and recalculate to obtain new results. Boxes 4.2, 4.3 and 5.2 in the text provide rules for usage and additional tips about adapting the utilities to different situations. For Utilies in Chapter 4, enter values for all factors on the Design sheet, press F9 Recalculate, then copy the results in Full list to another sheet for use, using the Values only option when pasting. For Chapter 5, results for sample size estimation are compared with those from Cohen (1988) in the spreadsheet Comparisons using the method explained in the document Accuracy.