QUESTION 22 (10 points) Xbar-Charts & R-Charts Based on a data sample in file "TOM3010 OM_HW3 Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guideline Background, equations, lookups and Excel examples are in Module 05 -Quality Management. Charts must have titles and labels. Points will be deducted if you print out full data (a)[5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min 35; Max 70; and Major Unit-5. The horizontal axis has 60 points. Besides the chart, present the following mini table (not full data). Give interpretations of the chart results. x-2bar SD(all parts value & unit) (value & unit value& unit) equation, value & unit equation, value & unit TABLE 22.1 (mini table) ISE(Xbar UCL-Xbar LCL-Xbar (b)[5] You need to print out one R-chart. The R-chart should have the vertical axis format as Min 0; Max 80; and Major Units 10, The horizontal axis has 60 points. Besides the chart, present the following mini table (not full data). Give interpretations of the chart results R-bar D4 D3 value & unit) value (value equation, value & unit) equation, value & unit) TABLE 22.2 (mini table) UCL-R LCL-R QUESTION 22 (10 points) Xbar-Charts & R-Charts Based on a data sample in file "TOM3010 OM_HW3 Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guideline Background, equations, lookups and Excel examples are in Module 05 -Quality Management. Charts must have titles and labels. Points will be deducted if you print out full data (a)[5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min 35; Max 70; and Major Unit-5. The horizontal axis has 60 points. Besides the chart, present the following mini table (not full data). Give interpretations of the chart results. x-2bar SD(all parts value & unit) (value & unit value& unit) equation, value & unit equation, value & unit TABLE 22.1 (mini table) ISE(Xbar UCL-Xbar LCL-Xbar (b)[5] You need to print out one R-chart. The R-chart should have the vertical axis format as Min 0; Max 80; and Major Units 10, The horizontal axis has 60 points. Besides the chart, present the following mini table (not full data). Give interpretations of the chart results R-bar D4 D3 value & unit) value (value equation, value & unit) equation, value & unit) TABLE 22.2 (mini table) UCL-R LCL-R