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....

1 answer below »
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.

Answered Same DayApr 04, 2022

Solution

P answered on Apr 05 2022
Data A
Sample #
Daily X-ba
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...
SOLUTION.PDF