https://widener.instructure.com/courses/28935/pages/week-5-learning-resourcesWatch videos on link...

Question

https://widener.instructure.com/courses/28935/pages/week-5-learning-resourcesWatch videos on link attached above and attachments to complete a control chart using Excel.Control Chart Assignment

1. Data for cycle time in minutes is given in “Control Chart Assignment Data.xlsx”. Use Data Set A. The data contains: 36 daily sample means (X-bar) of cycle time. With this data construct a control chart (note: there are a variety of possible control charts; for this assignment use an X-bar Chart) using 2 times the standard deviation as the control limits (if you Google Control Charts, you will find references to 3 times standard deviations – in this example, 2 works much better and is why we are directing you to use 2). Analyze the control chart and discuss whether or not the process is “under control”. Observe the data and discuss if it suggests the existence of any other problems.

2. Data Set B pertains to a period after a process improvement project was completed. Develop a control chart for this data similar to what you developed for Data Set A. Considering this data in comparison to Data Set A, was the project successful? Justify your answer as thoroughly as possible.

Note: The control charts should be constructed in Excel and the discussion should be submitted in a Word file. Please submit both files.

control-chart-assignment-0u1sjbav.docx how-to-create-a-control-chart-in-excel-4n5cofap.docx control-chart-assignment-data-pispdv1n.xlsx bus665week-5study-test-monitor-statistical-process-control-rj1mhqrk.pptx

P · Accepted Answer

Data A Sample # Daily X-bar Mean UCL LCL # Special Orders 1 23 38.05556 71.00901 5.102106 0 2 43 38.05556 71.00901 5.102106 2 3 23 38.05556 71.00901 5.102106 0 4 35 38.05556 71.00901 5.102106 1 5 28 38.05556 71.00901 5.102106 1 6 39 38.05556 71.00901 5.102106 2 7 30 38.05556 71.00901 5.102106 2 8 89 38.05556 71.00901 5.102106 5 9 25 38.05556 71.00901 5.102106 1 10 27 38.05556 71.00901 5.102106 1 11 29 38.05556 71.00901 5.102106 2 12 28 38.05556 71.00901 5.102106 2 13 33 38.05556 71.00901 5.102106 0 14 35 38.05556 71.00901 5.102106 3 15 36 38.05556 71.00901 5.102106 2 16 38 38.05556 71.00901 5.102106 1 17 42 38.05556 71.00901 5.102106 0 18 34 38.05556 71.00901 5.102106 0 19 32 38.05556 71.00901 5.102106 0 20 30 38.05556 71.00901 5.102106 0 21 28 38.05556 71.00901 5.102106 0 22 45 38.05556 71.00901 5.102106 3 23 32 38.05556 71.00901 5.102106 2 24 28 38.05556 71.00901 5.102106 0 25 29 38.05556 71.00901 5.102106 0 26 39 38.05556 71.00901 5.102106 2 27 88 38.05556 71.00901 5.102106 6 28 34 38.05556 71.00901 5.102106 1 29 28 38.05556 71.00901 5.102106 0 30 39 38.05556 71.00901 5.102106 2 31 37 38.05556 71.00901 5.102106 1 32 36 38.05556 71.00901 5.102106 1 33 42 38.05556 71.00901 5.102106 2 34 40 38.05556 71.00901 5.102106 2 35 37 38.05556 71.00901 5.102106 1 36 89 38.05556 71.00901 5.102106 5 MEAN 38.05556 ST. DEVIATION 16.47673 UCL 71.00901 LCL 5.102106 From the Chart it was observed that Panel A: one point falls outside of the control limit and it should be investigated in detail to determine the cause of its fall outside -------->UNSTABLE- special cause variation is present Panel B:

https://widener.instructure.com/courses/28935/pages/week-5-learning-resourcesWatch videos on link attached above and attachments to complete a control chart using Excel. Control Chart Assignment 1....

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment