Using the Widget Production dataset below, develop a control chart (in Excel) and identify all anomalies (ie Runs, Trends, and Exceeding Control Points).

For the following four (4) Customers determine Cp (Process Capability) and Cpk (Process Capability with Correction for Noncertrality).

Customer Specifications:

	Customer 1	Customer 2	Customer 3	Customer 4
Upper Specification Limit	209	259	289	300
Lower Specification Limit	89	39	9	2

 

Process Dataset:

Date	Number of Widgets Produced
10/8/2001	180
10/9/2001	175
10/10/2001	177
10/11/2001	210
10/12/2001	200
10/15/2001	188
10/16/2001	202
10/17/2001	179
10/18/2001	207
10/19/2001	161
10/24/2001	166
10/25/2001	172
10/26/2001	181
10/29/2001	183
10/30/2001	189
10/31/2001	192
11/1/2001	188
11/2/2001	201
11/5/2001	182
11/6/2001	203
11/7/2001	80
11/8/2001	193
11/9/2001	178
11/12/2001	186
11/13/2001	210
11/14/2001	225
11/15/2001	185
11/16/2001	230
11/19/2001	208
11/20/2001	214
11/21/2001	278
11/26/2001	224
11/27/2001	249
11/28/2001	226
11/29/2001	230
11/30/2001	199
12/3/2001	189
12/4/2001	202
12/5/2001	195
12/6/2001	197