Fujiyama Electronics wants to construct x - and s-charts for circuit boards that are purchased from an outside supplier. A critical dimension is the distance between two holes on the board that are supposed to be 5 cm apart. Use the data in the data file.

Sample	Observations
1	4.92	4.26	4.94	4.29
2	4.65	5.54	5.00	5.42
3	5.77	5.26	4.76	4.79
4	6.25	4.88	5.66	4.44
5	5.27	5.41	6.02	4.91
6	5.22	5.38	5.08	4.65
7	5.47	4.68	4.56	4.70
8	5.71	4.54	4.17	4.87
9	5.24	5.58	4.72	5.41
10	4.42	5.18	4.79	4.73
11	5.14	4.26	4.71	5.48
12	4.92	5.78	5.50	5.05
13	5.79	3.83	4.30	4.78
14	4.92	4.80	4.75	5.59
15	5.68	5.74	4.65	5.20
16	5.43	4.81	5.27	4.96
17	4.79	6.04	4.47	5.18
18	5.03	4.66	5.25	4.46
19	4.30	5.47	4.27	4.34
20	6.07	4.97	5.51	5.02
21	5.11	4.90	5.91	4.66
22	4.50	5.24	4.86	4.35
23	4.91	4.79	5.74	5.03
24	4.65	4.71	4.81	5.32
25	4.70	5.50	6.04	4.30
26	5.87	5.30	5.78	5.07
27	4.41	4.75	4.95	5.11
28	4.92	5.47	4.72	5.02
29	5.68	4.97	4.79	4.66
30	5.43	4.90	4.71	4.35

a. Find the centerlines and control limits using Excel template. Round to three decimal places.

b. Manually calculate the control limits of X-bar and s charts.

c. Use the X-bar&s Excel template to construct x - and s-charts. Covert the Excel results to PDF and submit as attachment.

d. What conclusions do you reach concerning the state of the process? Is it under control? Why or why not?

Covert the Excel results (calculations and control charts) to PDF and submit as attachment.