A gauge repeatability and reproducibility study was made at Precision Parts, Inc., using three operators, taking three trials each on identical parts. The data can be found in the Excel file "R-R assignment.x/sx". The part specification for the collar that was measured was 12 1 inches.

Analyze the data.

Do you see any problems after analyzing the data? If so, what should be done?

This spreadsheet is designed for up to three operators, three trials, and ten parts. Enter data ONLY in yellow shaded cells.

Number of operators

Number of trials

Number of parts

Data

Part #

Upper specification limit

Lower specification limit

Average

Range

3

9

Operator 1

Trial

1

1

2

3

4

5

6

7

8

10

12

11

13

9

11

9

11

2

13

11

10

9

13

13

13

12

13

10

Average

Repeatability (Equipment Variatioh) - EV

Reproducibility (Appraiser Variation) - AV

Repeatability and Reproducibility - R&R

Part Variation - PV

Total Variation - TV

Upper control limit for individual ranges

Note: any ranges beyond ths limit may be the result of assignable causes. Identify and correct. Discard values and recompute statistics.

10

12

10

13

9

11

9

13

Operator 2

Trial

1

9.0

12.0

12.0

13,0

13.0

13.0

90

10,0

9,0

2

13.0

9.0

13.0

12,0

12.0

12,0

11,0

13.0

13,0

3

12.0

11.0

11.0

9,0

10.0

12,0

11,0

13.0

10.0

Average range

Range of operator averages

Range of part averages

Average

Range

Operator 3

Trial

1

10,0

12,0

10.0

9,0

10,01

9,0

9,0

13,0

9,0

Variance Ratios

EV

AV

R&R

PV

2

12,0

9.0

13.01

9,0

12.0

13,0

9,01

12,0

12,0

Part

Average

3

12,0

9,0

12,0

9,0

12,0

9,0

13.0

12,0

9,0

Average

Range

Number of Trials

2

3

D4

3,27

2,58

Number of Operators

2

3

Number of Parts

2

3

4

5

6

7

8

9

10

K1

4,56

3,05

K2

3,35

2,70

K3

3,65

2,70

2,30

2,08

1,93

1,82

1,74

1,67

1,62