While testing the voltage of a component used in a microcomputer for the Hertz Company, the data listed were obtained.

1. Construct x-bar chart and R chart of these data. Determine whether the process is in control. If not, eliminate any assignable causes and calculate revised limits (UCL and LCL).

2. If the upper specification limitwas set atUSL=475, and the lower specification limit LSL = 325. Calculate the process capability and determine if the process if capable.

Submit Excel Spreadsheet with your analysis. 

Hertz data:

                                                                                                       

Samples	Data 1	Data 2	Data 3
1	414	388	402
2	408	382	406
3	396	402	392
4	390	398	362
5	398	442	436
6	400	400	414
7	444	390	410
8	430	372	362
9	376	398	382
10	342	400	402
11	400	402	384
12	408	414	388
13	382	430	400
14	402	409	400
15	399	424	413
16	460	375	445
17	404	420	437
18	375	380	410
19	391	392	414
20	394	399	380
21	396	416	400
22	370	411	403
23	418	450	451
24	398	398	415
25	428	406	390