iSixSigma

The Douglass Index Can Keep Good Data from Going to Waste

In statistical process control, diligent technicians and auditors conduct detailed work to gather data for quality engineers, who then crunch the data into capability studies. Typically, the repeatability and reproducibility (R&R) rates for the data are first determined for the gauges used in the capability studies. The R&R studies are completed first to establish the credibility of the gauge prior to administering the capability study.

In a perfect world, firm R&R rates of 10 percent or lower would be recorded and the gauges would be applied in capability data collection. The lower R&R rate the better in a measuring system – as a rule of thumb, R&R rates less than 10 percent are ideal, and anything between 10 and 30 percent is acceptable. However, sometimes practitioners do not find a rate below 10 percent. For these cases, the author has developed the Douglass Index formula to connect a poor-to-marginal R&R of 10 to 30 percent to a marginal capability index (Cp) through a meaningful method of augmenting the former Cp to an improved Cp.

Using the Index

The equation involved in the Douglass Index is a bit more complex than a simple correlation between two numbers. It is, however, a meaningful method of determining if the data is exhausted and needs to be redrawn or if it is valid and can remain as is. Accordingly, the purpose of the Douglass Index is to ensure that the existing data has been fully analyzed before the need arises to draft new data. The most functional way to apply the formula is as follows.

Layout the study results of a given machine or cell into a simple chart (see example in Table 1). For a broader scope, layout the study results of an entire department. After all, it is more useful to analyze a facility’s capability status departmentally. Be sure to include the corresponding R&R rates on the grid.

Handpicked Content:   Calculating Process Efficiency in Transactional Projects

Table 1: Sample Study Results Matrix: North Annex

Feature StudiedCpR&R %
Cavity 11.988.1
Cavity 22.278.1
Gap2.204.4
Center2.396.3
Endplay1.77P
Bezel A2.213.8
Bezel B2.303.8
Inner left1.5821.0
Inner right1.7821.0
Air gap1.69P
Torque4.45P
E-Dim1.846.7
RPMs1.5228.0
Pressure stop1.8820.1
Rotate force1.699.8
Piston swage3.116.5
Socket stiffness1.8116.8
Voltage2.022.1
P = Pass attribute

As can be expected, studying a measurable item using a gauge that garners a high bias due to sensitivity typically yields a marginal-to-poor R&R rate. But these marginal R&R rates become an integral factor in the Douglass Index equation. The team can analyze the study results grid to identify incapable processes or capability failures.

For example, say a capability study with a desired target of 1.67 or greater has yielded a failing Cp of 1.54. The team would compare this to the Douglass Index conversion table to learn if the R&R rate is 25 percent or less. If so, the index converts the former failing Cp of 1.54 to an improved 1.67 (Table 2). The index contains conversions to a Cp of 1.33 or, for more critical requirements, to a Cp of 1.67.

Table 2: Douglass Index Conversion Table

R&R %Cp OldCp New
291.241.33
261.261.33
221.281.33
191.291.33
161.301.33
141.311.33
111.321.33
291.501.67
281.511.67
271.521.67
261.531.67
251.541.67
241.551.67
231.561.67
221.571.67
211.571.67
201.581.67
191.591.67
181.601.67
171.611.67
161.611.67
151.621.67
141.631.67
131.631.67
121.641.67
111.641.67
101.651.67
Handpicked Content:   How to Avoid Common Mistakes When Measuring Performance

The Formula That Makes It Work

Before consulting the table, it may help for practitioners to understand the logic behind the Douglass Index. The equation subtracts the square root of the sum of the squares of the gauge inaccuracy from the actual part variation. This effectively removes that which makes the part variation falsely larger and further allows researchers to confirm if the data is acceptable.

For example, an unacceptable Cp of 1.58 equates to 1.67 in the index table if the R&R is 21 percent or less. Following this scenario, the formula to determine this conversion functions as follows:

  • The process capability (reciprocal of the Cp x 100 percent) summates the sum of the squares (in other words, capability squared x R&R squared). The equipment variation is segregated by subtracting out the R&R factor.
  • The reciprocal of the marginal Cp of 1.58 is 0.633 x 100 percent = 63.3 percent machine capability.
  • The square of 63.3 is 4,006.
  • Take the square of the poor R&R of 21 to get 441 and subtract 441 from 4006 = 3565.
  • The square root of 3565 is 59.7÷100 = .597.
  • Finally the reciprocal of .597 reaches the improved Cp of 1.67.

The full equation looks like this:

1÷1.58 = 0.633 x 100% = 63.3% 63.3²= 4,006 21²=441 4006-441=3565 √3565=59.7 ÷100 = .597 1÷.597 = 1.67 Cp

One note of caution: Avoid applying this formula in new program launches, new machine trial runs or in critical areas. The Douglass Index is better applied in scenarios of annual study cycles, existing machine qualifiers, supplier product monitoring and machine re-certifications. Further, it should also be noted the formula assumes that targeting is not an issue if Cp and Cpk are equal.

Handpicked Content:   Calculate Capability Indices with Only One Specification

Finding Value

The Douglass Index can be valuable in saving both time and money. Savings can be reaped each time a Cp is saved through the conversion tables, thus eliminating the need for further study or re-study. This allows diligent technicians and auditors to return to the shop to collect data on the next assignment and avoid rework one a previous one.

Advertisement

Leave a Reply