The use of a pen-size optimization workbook for experiment research design using the Visual Basic for Applications in Excel for poultry

Researchers often seem to choose the number of birds per pen and replications per treatment somewhat arbitrarily on the basis of cost, availability of animals, housing considerations, convenience, tradition, and so on. Statistical simulation, performed while designing an experiment, will provide a researcher with an objective estimate of the number of birds per pen and replicates needed for an experiment of known Type I and II errors. In most cases, the time for making power calculations should be before, not after, an experiment is conducted. Here we present a Microsoft Excel workbook to explore the statistical and economic ramifications of different combinations of birds per replicate and replicates per treatment for research with poultry.