An Interactive Spreadsheet-based Tool to Support Teaching Design of Experiments

S. T. Enns - enns@ucalgary.ca
Department of Mechanical and Manufacturing Engineering, University of Calgary, Calgary, Canada, T2N 1N4

Abstract

This paper describes an interactive spreadsheet-based tool that can be used to generate data representative of the type that might be obtained running a structured set of experiments. The purpose of this tool is to help the user experience the iterative nature of design and analysis of experiments. The tool supports quick and simple generation of data for one and two-factor problems. The underlying relationships are based on queuing approximations for a single-stage batch production environment. Factor levels are related to product lot sizes and the response is assumed to be average lot flowtimes. Variability due to replication is emulated by sampling from a statistical distribution. Statistical software packages can be used to generate linear or quadratic models from the results generated. Analysis can include the examination of main and interaction effects or the optimization of lot sizes to minimize flowtimes.

Key words
design of experiments, central composite design (CCD), response surface methods

History
Received: July 5, 2005; accepted: January 23, 2006. This paper was with the authors 3 months for 2 revisions.

Download the PDF
10.1287/ited.8.2.55

Supplementary Materials
DOE_Tool

Citation Information
Enns, S. T. 2008. An interactive spreadsheet-based tool to support teaching design of experiments. INFORMS Trans. Ed. 8(2) 55-64. Available online at http://ite.pubs.informs.org/.

DOI: 10.1287/ited.1080.0008