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
12 Votes
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

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here