Assignment 2 - Attribute RR - Excel Mahesh Sharma MS File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Cut Calibri - 11 - A A = al Wrap Text General EX AutoSum AY O Copy Fill Paste Format Painter BIULA Merge & Center ~ % " 00 0 Conditional Format as Cell Insert Delete Format Sort & Find & Formatting " Table . Styles Clear ~ Filter ~ Select Clipboard Font Alignment N Number Styles Cells Editing D8 X A B D E F G H QUAL8015 - ASSIGNMENT #3 - ATTRIBUTE RR 2 Group: Student Names: Question Answer Possible Score Achieved Score Feedback Explain how this attribute RR study was set up and 5 executed. 5 Perform the Attribute RR study in Excel. Paste the statistic 2 results below: (table only, do not paste the plots) 2 Perform the Attribute RR study in Minitab. Paste the 3statistic results below (all 4 tables): 2 agreement (All appraiser vs. Standard)? Is this Measurement System accepable, marginal acceptable or 4 not acceptable? Why? 6 What is the overall Measurement System kappa value and associated p-value? What do these statistics values mean? Explain the appraisers' repeatability results in detail. (percent agreement value and its meaning, kappa value and 10 6 p-value and their meaning) 9 Explain the appraisers' accuracy results in detail. (percent agreement value and its meaning, kappa value and p-value 11 7 and their meaning) 9 Is the % effective score (precision) different from the % effective score vs. standard (precision and accuracy)? If yes, why is there a difference? If not, why is there no 12 |difference? Provide detailed evidence. 4 measurement system? What corrective actions can you suggest for each possible root cause? (For example, make a list of all the percent agreements, kappa values and p- values for each operator from the different study result tables, and identify possible causes for low agreements along with recommended actions to improve the Data Assignment 3 + Ready Accessibility: Investigate 85% 5 .C Mostly clear Q T W J. P 2Assignment 2 - Attribute RR - Excel Mahesh Sharma MS File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Cut Calibri - 11 - A A = al Wrap Text General EX AutoSum AY O Copy Fill Paste Format Painter BIULA Merge & Center ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Formatting * Table . Styles Clear ~ Filter ~ Select ~ Clipboard Font Alignment N Number Styles Cells Editing D8 X Y fix A B D E G H Perform the Attribute RR study in Minitab. Paste the 7 3 statistic results below (all 4 tables): 2 agreement (All appraiser vs. Standard)? Is this Measurement System accepable, marginal acceptable or 1 not acceptable? Why 6 What is the overall Measurement System kappa value and 5 associated p-value? What do these statistics values mean? Explain the appraisers' repeatability results in detail. (percent agreement value and its meaning, kappa value and 10 6 p-value and their meaning) 9 Explain the appraisers' accuracy results in detail. (percent agreement value and its meaning, kappa value and p-value 11 and their meaning) 9 s the % effective score (precision) different from the % effective score vs. standard (precision and accuracy)? If yes, why is there a difference? If not, why is there no 12 B difference? Provide detailed evidence. 4 measurement system? What corrective actions can you suggest for each possible root cause? (For example, make a list of all the percent agreements, kappa values and p- values for each operator from the different study result tables, and identify possible causes for low agreements along with recommended actions to improve the 13 agreements) 6 Grammar/spelling: 0-1 (4), 1-5 (3), 5-10 (2) 10-15 (1), >15 16 10 (0) 17 11 References 18 19 52 20 21 Excell Attribute RR Minitab Attribute RR Results Data Assignment 3 + Ready * Accessibility: Investigate 85% 5 0 C T W X 2 Mostly clear Q PAssignment 2 Attribute RR - Word Mahesh Sharma MS X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want to do do Cut Calibri (Body) - 11 - A A Aa A AaBbCcDd AaBbCcDd AaBbCc AaBbCc Aa B Find my Copy AaBbCCD AaBbCcDd AaBbCcDd AaBbCcDd Bac Replace Paste Format Painter BI U~ abe X2 x AZA~ 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em.. Emphasis Intense E... Select Clipboard Font Paragraph Styles Editing Introduction The study was conducted the attribute R&R of the data. The 10 different parts are inspected for conformity to specifications. This was done 3 times for each appraiser. The total data gathered are 90. These are recorded and analyzed. These gathered data are analyzed through excel and Minitab. The following are the data: All operators All agree with operators Trial Trial Trial Trial Trial Trial Trial Trial |Trial and between agree with 3 2 3 3 each other standard Part Number Standard A-1 A-2 A-3 B-1 B-2 B-3 C-1 -2 C-3 Y/N YIN 1 F F F P P P P F P N N 2 F F F F F F F F N N 3 P P P P P P P P P Y Y 4 F F F P P P P F P N N F F F F P P F F P N N 6 P F F F F F F P F N N 7 P P P F F P P P P N N 8 F F F F F F F Y Y P UTI- 10 U Table 1. Inspection data Page 2 of 6 1196 words E English (Canada) * Accessibility: Investigate 00% 5 C Mostly clear Q T W P ENG 18:46 U 07-11-2022 12 IN