Description
Please submit ONE MS Word or PDF file which includes all of your solutions to CANVAS.
Problem 1. Construct control charts as required using data in file HW1 data 1.xlsx and answer questions below. (50 points)
(a) Construct an Individual Control Chart (I Chart). (10 points)
(b) Construct 𝑥̅Control Chart with a subgroup size of two. (10 points)
(c) Construct 𝑥̅Control Chart with a subgroup size of five. (10 points)
(d) Construct 𝑥̅Control Chart with a subgroup size of 10. (10 points)
(e) Observe the control charts (a) – (d), what is your conclusion about the control charts with the subgroup size increasing? (10 points)
Problem 2. Construct control charts as required using data in file HW1 data 2(xxx).xlsx. Perform all tests for special cases with the default value of K and answer the questions below. (50 points)
(a) Construct 𝑝 Chart using data in HW1 data 2 (pchart).xlsx and indicate which test fails. (12 points)
(b) Construct 𝑛𝑝 Chart using data in HW1 data 2 (npchart).xlsx and indicate which tests fail. (14 points)
(c) Construct 𝑢 Chart using data in HW1 data 2 (uchart).xlsx and indicate which test fails. (12 points)
(d) Construct 𝑐 Chart using data in HW1 data 2 (cchart).xlsx and indicate which test fails. (12 points)
please follow the instruction in the question. I will upload the excel files that have the required data.
please provide the excel sheets that you will work on along with the pdf or WORD that will have the final answer.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
i have attached compressed folder with minitab file and separate word document.
Lean Six Sigma Problems
Problem 1 –
(a) Construct an Individual Control Chart (I Chart).
Individual Control Chart
Individual Value
5
UCL=4.693
4
_
X=3.034
3
2
LCL=1.374
1
1
11
21
31
41
51
61
71
81
91
Observation
UCL=2.039
Moving Range
2.0
1.5
1.0
__
MR=0.624
0.5
0.0
LCL=0
1
11
21
31
41
51
61
71
81
91
Observation
(b) Construct 𝑥̅Control Chart with a subgroup size of two.
Xbar Control Chart Sub group size 2
UCL=4.135
Sample Mean
4.0
3.5
__
X=3.034
3.0
2.5
2.0
LCL=...