DMAIC - GRR Template - Copy - Copy (2).xlsx

DMAIC - GRR Template - Copy - Copy (2).xlsx - Gage R&R...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Gage R&R Part Number Average & Range Method 1 2 3 4 5 6 7 Operator 1 Trial 1 112.0000 111.0000 70.0000 100.0000 114.0000 Enter your data here-> Trial2 114.0000 106.0000 73.0000 97.0000 130.0000 Trial3 116.0000 116.0000 76.0000 107.0000 128.0000 Trial4 Trial 5 Total 342 333 219 304 372 Average-Appraiser 1 114 111 73 101.33333 124 Range1 4 10 6 10 16 Operator 2 Trial 1 111.0000 118.0000 83.0000 99.0000 111.0000 Enter your data here-> Trial2 112.0000 107.0000 83.0000 99.0000 108.0000 Trial3 110.0000 109.0000 87.0000 102.0000 106.0000 Trial4 Trial 5 Total 333 334 253 300 325 Average-Appraiser 2 111 111.3333333 84.33333333 100 108.3333333333 Range2 2 11 4 3 5 Operator 3 Trial 1 104.0000 113.0000 102.0000 114.0000 132.0000 Enter your data here-> Trial2 109.0000 122.0000 86.0000 108.0000 130.0000 Trial3 106.0000 121.0000 85.0000 105.0000 128.0000 Trial4 Trial 5 Total 319 356 273 327 390 Average-Appraiser 3 106.3333333 118.6666667 91 109 130 Range3 5 9 17 9 4 Range Average 7.6667 Constants XDiff 8.0000 5 Trials 4 Trials 3 Trials 2 Trials # Trials 3 UCL 19.7800 2.11 2.28 2.58 3.27 D4 2.58 LCL 0.0000 0 0 0 0 D3 0 Repeatability(EV) 12.9797 0.577 0.729 1.023 1.88 A2 1.023 Reproducibility(AV) 2.5062 0.4299 0.4857 0.5908 0.8862 K1 1.693 Gage Capability(R&R) 13.2194 0.7071 0.5231 K2 0.5231 Spec Tolerance 0.0100 2 Ops 3 Operators Acceptability(%) 1321.94 % Using % Using AIAG - Automotive Industry Action Group Formula TV Tolerance Equipment Variation (Repeatability) 12.9797 4.524512699 %EV 64.2% 778780%
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Appraiser Variation (Reproducibility) 2.50621 %AV 12.4% 150373% R&R (Gage Capability) 13.2194 %R&R 65.3% 793165%
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern