Counting Bolts Case Study
The Statistics Library hosted by the Dept of Statistics at Carnegie Mellon University has an interesting case study submitted by W. Robert Stephenson, Iowa State University.
The case study is about counting and packaging bolts. Too few bolts per package causes complaints; too many increases costs.
A spinning plate forces bolts to the edge where they are counted by a sensor.
There are several adjustments on the machine that affect its operation.
- SPEED1 that controls the speed of rotation
- TOTAL number of bolts counted
- SPEED2 the speed of rotation for the last few bolts, the number of bolts to be counted
- NUMBER2 of bolts to be counted at this speedSENSsitivity of the electronic eye
- (SENS)TIME, in seconds, it takes to count the bolts.
- T20BOLT is the time to count 20 bolts.
The question is:
What settings result in the fastest counting of 20 bolts?
The data (slightly rearranged) looks like this:
We could attempt to use ANOVA or DOE, but the easiest way to do this is by selecting D:H and running a Multivari chart:
From this chart, it's easy to see that the fastest time with the least variation comes from a combination of Speed1=4, Speed2=2, Number2=1, Sensor=8.
Other Charts Included in QI Macros for Excel
Isn't it Time to Upgrade Your Excel Charting Skills?
Stop trying to make your spreadsheets easy to read. Nobody wants to read your spreadsheet!
And stop using primitive line, pie and bar charts.
Isn't it time to graduate to Smart Charts: Control Charts, Pareto charts and Histograms?

Spreadsheets

Primitive Charts

Smart Charts
Stop Struggling with Excel Charts!
Start creating Smart Charts in just minutes.
Download a free 30-day trial. Get Smart Charts for Excel now!