An Introduction to Gage R & R - Simplified Gauge Verification
I understand the basic premise that Gage R&R helps determine the magnitude of the variation in a measurement system as well as the sources of this variation. I also see that while the sources of variation can be numerous, three of these sources are fundamental: part-to-part variation, repeatability and reproducibility. What I am struggling with are the Excel formulas that are required to chart the specific steps in the verification process. The directions below require Excel formula operations that I am not successful with. Please help me to understand the exact Excel process to chart the activities below.
Suppose in the manufacturing process, a part needs to be 2.5 inches. Due to the random errors, it cannot be 2.5 inches exactly. Here are readings from three inspectors in a verification test. Find the % of gauge error. How does the gauge verification improve the performance of a manufacturing process?
Data from three Inspectors
Master Part Diameter Reading =2.5 in.
....Max= 2.55 in.
....Min = 2.35 in.
Reading Diameter Dimension
Inspector A 1 2.51
Inspector B 1 2.50
Inspector C 1 2.52
Provide a report with your analysis. Answer questions with clarity and show the detailed steps for calculation. Use Excel for the calculations. Upload your Excel file into Additional Files.
This solution provides an examination of 3 inspectors inspection results. The expected value is 2.5, but the manufacturing process doesn't allow each item to be manufactured at 2.5. The upper control limit and lower control limit are used to compare the observed manufacturing parts.