Question: 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 guidelines: Background, equations, lookups

Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to constructone Xbar-chart and one R-chart with the following guidelines: Background, equations, lookupsand Excel examples (with videos) are in Module 05. Charts must havetitles, labels, and clear presentation of different lines. (a)[5] You need to

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 guidelines: Background, equations, lookups and Excel examples (with videos) are in Module 05. Charts must have titles, labels, and clear presentation of different lines. (a)[5] You need to have 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 (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. Table 22.1 (first 2 Excel columns) x-2bar (value & unit) SD(all parts) (value & unit) SE(Xbar) (value & unit) (equation, value & unit) (equation, value & unit) UCL-Xbar LCL-Xbar (b)[5] You need to have one R-chart. The R-chart should have the vertical axis format as: Min = 0; Max = 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you show the big table of full data). Give interpretations of the chart results: the process is in control or out of control, and why. Table 22.2 (first 2 Excel columns) R-bar (value & unit) D4 (value) D3 (value) UCL-R (equation, value & unit) LCL-R (equation, value & unit)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!