In a study to isolate both gauge repeatability and reproducibility, two operators used the same gauge to measure 10 parts three times each.

The data are given in the attached Excel sheet.

a. Estimate gauge repeatability and reproducibility. b. Estimate the standard deviation of the measurement system error. c. If the specifications are at 50+/-10, what is the P/T ratio? Is the measurement system capable?

Use Excel for this assignment

Data:

Operator	Replication	Reading
1	1	50
1	2	49
1	3	50
1	1	52
1	2	52
1	3	51
1	1	53
1	2	50
1	3	50
1	1	49
1	2	51
1	3	50
1	1	48
1	2	49
1	3	48
1	1	52
1	2	50
1	3	50
1	1	51
1	2	51
1	3	51
1	1	52
1	2	50
1	3	49
1	1	50
1	2	51
1	3	50
1	1	47
1	2	46
1	3	49
2	1	50
2	2	48
2	3	51
2	1	51
2	2	51
2	3	51
2	1	54
2	2	52
2	3	51
2	1	48
2	2	50
2	3	51
2	1	48
2	2	49
2	3	48
2	1	52
2	2	50
2	3	50
2	1	51
2	2	50
2	3	50
2	1	53
2	2	48
2	3	50
2	1	51
2	2	48
2	3	49
2	1	46
2	2	47
2	3	48