San Jose City College Statistical Process Control Worksheet

Test1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Viscosity
2838
2785
3058
3064
2996
2882
2878
2920
3050
2870
3174
3102
2762
2975
2719
2861
2797
3078
2964
2805
time
953
945
972
945
975
970
959
973
940
936
985
973
955
950
948
957
940
933
965
973
949
941
966
966
934
937
946
952
935
941
937
946
954
935
941
933
960
968
959
956
959
939
948
958
963
973
949
942
965
962
948
937
955
927
940
962
963
943
950
938
958
955
947
941
938
945
963
967
969
981
952
931
928
937
950
970
933
960
934
927
check No. time
moving range of window size = 2
1
953
N/A
2
945
8
3
972
27
4
945
27
5
975
30
6
970
5
7
959
11
8
973
14
9
940
33
10
936
4
11
985
49
12
973
12
13
955
18
14
950
5
15
948
2
16
957
9
17
940
17
18
933
7
19
965
32
20
973
8
21
949
24
22
941
8
23
966
25
24
966
0
25
934
32
26
937
3
27
946
9
28
952
6
29
935
17
30
941
6
31
937
4
32
946
9
33
954
8
34
935
19
35
941
6
36
933
8
37
960
27
38
968
8
39
959
9
40
956
3
41
959
3
42
939
20
43
948
9
44
958
10
45
963
5
Process Parameters
mean
950
s.d.
12.16447
EWMA Parameters
L
2.7
lambda
0.1
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
average
973
949
942
965
962
948
937
955
927
940
962
963
943
950
938
958
955
947
941
938
945
963
967
969
981
952
931
928
937
950
970
933
960
934
927
951.375
10
24
7
23
3
14
11
18
28
13
22
1
20
7
12
20
3
8
6
3
7
18
4
2
12
29
21
3
9
13
20
37
27
26
7
13.72151899 d2(size=2)
12.16446719 sigma
12.1644671874
1.128
EWMA Chart LCL
CL
UCL
946.7155939
CL
945.5812835
LCL
944.8422273
944.3135736
943.9189611
943.6171839
943.3828254
943.1989123
943.0535112
942.9379305
942.8456787
942.7718179
942.7125393
942.6648748
942.6264925
942.5955486
942.5705785
942.5504142
942.5341209
942.5209494
942.5102975
942.5016805
942.494708
942.489065
942.4844973
942.4807995
942.4778056
942.4753815
942.4734184
942.4718288
942.4705414
942.4694988
942.4686544
942.4679705
942.4674165
942.4669679
942.4666045
942.4663102
942.4660718
942.4658787
942.4657223
942.4655956
942.465493
942.4654099
942.4653426
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
UCL
953.2844
954.4187
955.1578
955.6864
956.081
956.3828
956.6172
956.8011
956.9465
957.0621
957.1543
957.2282
957.2875
957.3351
957.3735
957.4045
957.4294
957.4496
957.4659
957.4791
957.4897
957.4983
957.5053
957.5109
957.5155
957.5192
957.5222
957.5246
957.5266
957.5282
957.5295
957.5305
957.5313
957.532
957.5326
957.533
957.5334
957.5337
957.5339
957.5341
957.5343
957.5344
957.5345
957.5346
957.5347
Plotted Point
950
950.3
949.77
951.993
951.2937
953.66433
955.297897
955.6681073
957.4012966
955.6611669
953.6950502
956.8255452
958.4429907
958.0986916
957.2888225
956.3599402
956.4239462
954.7815516
952.6033964
953.8430568
955.7587511
955.082876
953.6745884
954.9071295
956.0164166
953.8147749
952.1332974
951.5199677
951.5679709
949.9111738
949.0200564
947.8180508
947.6362457
948.2726212
946.945359
946.3508231
945.0157408
946.5141667
948.6627501
949.6964751
950.3268276
951.1941448
949.9747303
949.7772573
950.5995316
951.8395784
960
955
950
945
940
935
930
1 4 7 10 13 16 19 22
Series1
942.465288
942.4652438
942.4652081
942.4651791
942.4651556
942.4651366
942.4651212
942.4651087
942.4650986
942.4650904
942.4650838
942.4650784
942.4650741
942.4650706
942.4650677
942.4650654
942.4650635
942.465062
942.4650608
942.4650598
942.465059
942.4650583
942.4650578
942.4650574
942.465057
942.4650567
942.4650565
942.4650563
942.4650562
942.4650561
942.465056
942.4650559
942.4650558
942.4650558
942.4650557
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
950
957.5347
957.5348
957.5348
957.5348
957.5348
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
957.5349
953.9556206
953.4600585
952.3140527
953.5826474
954.4243827
953.7819444
952.1037499
952.393375
949.8540375
948.8686337
950.1817703
951.4635933
950.617234
950.5555106
949.2999595
950.1699636
950.6529672
950.2876705
949.3589034
948.2230131
947.9007118
949.4106406
951.1695765
952.9526189
955.757357
955.3816213
952.9434592
950.4491133
949.1042019
949.1937817
951.2744036
949.4469632
950.5022669
948.8520402
946.6668362
Chart Title
19 22 25 28 31 34 37 40 43 46 49 52 55 58 61 64 67 70 73 76 79
Series1
Series2
Series3
Series4
ISE 131 HW #3
HW 3.1: Exercise 5.30 (Part b and c) on page 227; the data table Table 5E.10 has been
entered into a companion Excel file and posted on this site. Use moving-window size of 2.
For Part (b), do the following two parts:
Part (b.1): Use Excel to do the following: (i) estimate the unknown mean and standard
deviation of the viscosity, (ii) calculate the centerline and the upper and lower control limits
for each of the two charts and (iii) plot the control charts, including the control limits and
the observed values (of viscosity and moving range) for all relevant time periods. Submit
your Excel results.
Part (b.2): Use Minitab to do (i), (ii) and (iii) of Part (b). Submit your Minitab results.
Make sure that your Minitab results contain estimates of the mean and standard deviation,
by taking advantage of the Storage tab of “I-MR Options.”
For Part (c), do it with Excel first, and verify your answer with your Minitab’s results
already obtained in Part (b.2).
HW 3.2: Exercise 5.31 on page 227. Note that this problem calls for monitoring of process
and do not change the control limits calculated in Exercise 5.30. (All data corrected in this
“monitoring stage” can be viewed as “suspects” because the process is no longer carefully
watched over from all possible aspects (as in the “construction stage” of Exercise 5.30) but
is monitored only with control charts. Use Excel to solve this problem.
HW3.3: Exercise 5.34 on page 228.
Part (1): Solve this problem (Part a and Part b) using Excel. For Part (b), plot the control
chart, including the control limits and the observed values for all relevant time periods.
Submit your Excel solution.
Part (2): Solve this problem using Minitab and verify the answer you obtained in Part (a).
There is no need to submit your Minitab solution.
For your convenience, the data contained in Table 5E.12 have been entered into a
companion Excel file and has been posted on this site.
HW 3.4: Exercise 5.38 on page 228.
Part (1): Solve this problem using Excel. Submit your Excel solution.
Part (2): Solve this problem using Minitab and verify the answer you obtained in Part (a).
There is no need to submit your Minitab solution.
ISE 131 HW #3
HW 3.1: Exercise 5.30 (Part b and c) on page 227; the data table Table 5E.10 has been
entered into a companion Excel file and posted on this site. Use moving-window size of 2.
For Part (b), do the following two parts:
Part (b.1): Use Excel to do the following: (i) estimate the unknown mean and standard
deviation of the viscosity, (ii) calculate the centerline and the upper and lower control limits
for each of the two charts and (iii) plot the control charts, including the control limits and
the observed values (of viscosity and moving range) for all relevant time periods. Submit
your Excel results.
Part (b.2): Use Minitab to do (i), (ii) and (iii) of Part (b). Submit your Minitab results.
Make sure that your Minitab results contain estimates of the mean and standard deviation,
by taking advantage of the Storage tab of “I-MR Options.”
For Part (c), do it with Excel first, and verify your answer with your Minitab’s results
already obtained in Part (b.2).
HW 3.2: Exercise 5.31 on page 227. Note that this problem calls for monitoring of process
and do not change the control limits calculated in Exercise 5.30. (All data corrected in this
“monitoring stage” can be viewed as “suspects” because the process is no longer carefully
watched over from all possible aspects (as in the “construction stage” of Exercise 5.30) but
is monitored only with control charts. Use Excel to solve this problem.
HW3.3: Exercise 5.34 on page 228.
Part (1): Solve this problem (Part a and Part b) using Excel. For Part (b), plot the control
chart, including the control limits and the observed values for all relevant time periods.
Submit your Excel solution.
Part (2): Solve this problem using Minitab and verify the answer you obtained in Part (a).
There is no need to submit your Minitab solution.
For your convenience, the data contained in Table 5E.12 have been entered into a
companion Excel file and has been posted on this site.
HW 3.4: Exercise 5.38 on page 228.
Part (1): Solve this problem using Excel. Submit your Excel solution.
Part (2): Solve this problem using Minitab and verify the answer you obtained in Part (a).
There is no need to submit your Minitab solution.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, how can I help?