Question: QUESTION 23 (10 points) - P-Charts & C-Charts Based on two separate data files TOM3010_OM_HW3_Question23_Data-?Chart.xlsx, you need to construct one p-chart and one C-chart with

QUESTION 23 (10 points) - P-Charts & C-Charts

QUESTION 23 (10 points) - P-Charts & C-Charts Based on two separate data files "TOM3010_OM_HW3_Question23_Data-?Chart.xlsx", you need to construct one p-chart and one C-chart with the following guideline: Only present control charts and mini tables. Points will be deducted if you print out full table. Charts must have titles and labels. Numbers in mini tables must show 3 decimal places. (a)[5] You need to print out one P-chart. Proportions are kept with 3 decimals. The vertical axis should have: Min = -0.02; Max = 0.16; and Major Unit = 0.02. The horizontal axis has 60 points. Besides, present the following mini table (not full table). Give interpretations of the chart. p-bar (value, 3 decimals) Table 23.1 s-pbar (value, 3 decimals) (mini table) UCL-P (equation & value) LCL-P (equation & value) (b)[5] You need to print out one C-chart. The vertical axis should have: Min = -2; Max = 12; and Major Unit = 2. The horizontal axis has 60 points for 60 sampled units (60 customers). Besides, present the following mini table (not full table). Give interpretations of the chart. C-bar (value & unit) Table 23.2 UCL-C (equation, value & unit) (mini table) LCL-C (equation, value & unit) QUESTION 23 (10 points) - P-Charts & C-Charts Based on two separate data files "TOM3010_OM_HW3_Question23_Data-?Chart.xlsx", you need to construct one p-chart and one C-chart with the following guideline: Only present control charts and mini tables. Points will be deducted if you print out full table. Charts must have titles and labels. Numbers in mini tables must show 3 decimal places. (a)[5] You need to print out one P-chart. Proportions are kept with 3 decimals. The vertical axis should have: Min = -0.02; Max = 0.16; and Major Unit = 0.02. The horizontal axis has 60 points. Besides, present the following mini table (not full table). Give interpretations of the chart. p-bar (value, 3 decimals) Table 23.1 s-pbar (value, 3 decimals) (mini table) UCL-P (equation & value) LCL-P (equation & value) (b)[5] You need to print out one C-chart. The vertical axis should have: Min = -2; Max = 12; and Major Unit = 2. The horizontal axis has 60 points for 60 sampled units (60 customers). Besides, present the following mini table (not full table). Give interpretations of the chart. C-bar (value & unit) Table 23.2 UCL-C (equation, value & unit) (mini table) LCL-C (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 General Management Questions!