Hello I have a professional project it should be perfectly done using MINITAB
I will be uploading the Instructions and the data below please go through them deeply and carefully ̅
INSTRUCTIONS:
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.xlsxand answerquestions 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? (5points)f)Observe the control charts (a) –(d), Is there anynotableincreasingor decreasingtrend? Brieflydiscussyour understandingof the trends (5points)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).xlsxand indicate which test fails. (12 points)b)Construct 𝑛𝑝Chart using data in HW1 data 2 (npchart).xlsxand indicate which tests fail. (14 points)c)Construct 𝑢Chart using data in HW1 data 2 (uchart).xlsxand indicate which test fails. (12 points)d)Construct 𝑐Chart using data in HW1 data 2 (cchart).xlsx and indicate which test fails. (12 points)
Data
9.34
5.25
5.67
8.84
8.23
5.2
8.04
7.14
7.61
8.43
7.43
7.3
7.44
5.62
7.34
7.33
9.95
7.45
6.29
8.07
8.6
8.83
9.34
6.93
8.58
8.12
6.84
8.12
8.65
8.4
9.27
9.82
7.13
9.09
5.11
8.15
8
6.34
9.6
7.48
7.73
7.98
8.23
8.48
8.73
8.98
9.23
9.48
5.49
9.71
5.9
8.59
6.21
9.48
7.67
5.79
6.55
6.61
8.53
5.67
9.7
6.49
7.07
5.81
8.57
9.29
6.74
6.54
7.22
7.15
8
6.26
7.46
5.55
9.57
8.76
6.48
5.1
8.33
5.55
6.04
9.55
9.15
9.44
7.5
7.41
6.75
6.25
7.93
6.93
6.34
7.71
9.3
6.3
5.52
6.71
5.99
7.67
7.85
6.33
Size of sample_pchart
Number of defective products_pchart
220
15
216
25
236
19
211
15
249
14
229
3
201
18
226
12
236
4
211
6
228
8
201
13
210
21
236
8
226
2
242
26
216
30
234
2
206
1
214
11
231
6
236
29
223
10
233
28
219
14
233
13
229
5
222
8
249
1
244
9
Size of sample_uchart
Number of defects_uchart
2000
15
2000
24
2000
24
2000
17
2000
21
2000
21
2000
21
2000
23
2000
28
2000
17
2000
40
2000
27
2000
28
2000
10
2000
39
2000
26
2000
20
2000
16
2000
31
2000
50
2000
12
2000
24
2000
34
2000
75
2000
27
2000
21
Sample_cchart
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Number of defects_cchart
15
24
24
17
21
21
21
23
28
17
40
27
28
10
39
26
20
16
31
50
12
24
34
75
27
21
Size of sample_npchart
Number of defective products_npchart
500
14
500
13
500
23
500
5
500
16
500
13
500
10
500
12
500
24
500
15
500
10
500
7
500
20
500
22
500
17
500
9
500
15
500
15
500
22
500
31
500
12
500
16
500
24
500
17
500
23
500
14
500
20
500
21
500
20
500
17
EIN6935 LEAN Six Sigma Homework 1 Due: June 6 (11:59 pm), 2021
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? (5 points)
f) Observe the control charts (a) – (d), Is there any notable increasing or decreasing trend? Briefly
discuss your understanding of the trends (5 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)
jasmine9am@gmail.com