gage-r-r-with-anova-xbarr-analysis.xls - This spreadsheet...

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

View Full Document Right Arrow Icon
This spreadsheet is provided "as is" without warranties of any kind, either expressed or implied. When to use this spreadsheet 1) This spreadsheet allows the user to perform a complete Gage Repeatability and Reproducibility (GR&R) study. Both Analysis of Variance (ANOVA) and Xbar/Range calculations are performed. Up to three operators, ten parts and three trials can be accommodated. The GR&R is reported in terms of percent of study variation and percent of tolerance. The percentage of equipment variation, appraiser variation, part variation, and the number of distinct categories that can be distinguished are also displayed. Instructions for Data Entry 1) Generally the coloring of the cells indicate their use. White cells are for data entry, yellow cells provide instruction, turquoise cells are headings and light green cells display data that can't / shouldn't be changed. 2) Enter the part number and / or name, the characteristic of the part being measured, the tolerance specification, the gage name, the gage number, the gage type, the name of the person conducting the study, the upper specification limit and the lower specification limit. Both upper and lower specification limits are required. 3) Determine the number of parts and the number of appraisers to be used. Conduct the study and enter the data in the appropriate rows. The spreadsheet will count the number of parts and appraisers automatically. Reading the Results 1) The GR&R results are displayed as a percentage of part variation and percentage of tolerance. If no tolerance is entered, the Percent of Tolerance report will display "Enter Tol" in the data fields. Be sure to enter a value for the upper and lower specification, including zero, to ensure a proper result. 2) The percentage of equipment variation, appraiser variation, part variation, and the number of distinct categories that can be distinguished are displayed. Generally, an acceptable gage will have lower values for the equipment and the appraiser and higher values for the parts. In most industries, a GR&R less than 10% of the tolerance is considered acceptable while a GR&R greater than 30% is unacceptable. A GR&R between 10% and 30% should be investigated for improvement. The Number of Distinct Categories should be 5 or greater. 3) The Graphical Summary provides a full graphical analysis of the data. An Xbar and R chart is shown as well as Multi-vari charts showing Part Variation, Operator Variation and Part - Operator Interaction. A bar chart summarizes the total Gage R&R, Repeatability and Reproducibility for % Contribution, % Study Variation and % Tolerance. Guidance for using the Xbar and R charts follows: Xbar Chart : The area between the control limits represents the measurement uncertainty and so at least half of the points should be outside the control limits.
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
Image of page 2
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