Six Sigma Virtual Catapult with Excel
A wooden catapult has been widely used in Six Sigma education to illustrate multiple factor process variation and optimization. We will use a catapult simulator with 4 factors to practice: Process variation Linear regression Response surface analysis Process optimization This will be done using Microsoft Excel Analysis and Solver Download this Excel simulator Catapult.xlsx from One Drive Working Plan 1. What factors affect distance? 2. What values of these factors to achieve maximum distance? 3. Run a full factorial set of experiments with 4 central points 4. Can you detect curvature? Is this linear model valid? 5. Run response surface experiments to find a better model 6. What is the resulting formula to estimate distance as a function of factors? 7. What values give us the maximum distance? 8. Make 10 replicates to estimate the confidence iterval of the distance 9. Calculate the angle a to hit a target of 20 with maximum or minimum values of f, m and l Possible Facto