IF IT IS POSSIBLE PLEASE SEND ME AN EXCEL FILE.

Consider the data and establish (X bar) and R charts with the appropriate trial control limits. Revise these trial limits as necessary to produce a set of control charts for monitoring future production. Suppose that the new data in the following table:

(a) Plot these new observations on the control chart. What conclusions can you draw about process stability?

(b) Use all 25 observations to revise the control limits for (X bar) and R charts. What conclusions can you draw now about the process?

Sample Number	x1	x2	x3	x4	x5
1	1	9	6	9	6
2	9	4	3	0	3
3	0	9	0	3	2
4	1	1	0	2	1
5	-3	0	-1	0	-4
6	-7	2	0	0	2
7	-3	-1	-1	0	-2
8	0	-2	-3	-3	-2
9	2	0	-1	-3	-1
10	0	2	-1	-1	2
11	-3	-2	-1	-1	2
12	-16	2	0	-4	-1
13	-6	-3	0	0	-8
14	-3	-5	5	0	5
15	-1	-1	-1	2	-1

Sample Number (NEW)	x1	x2	x3	x4	x5
16	2	10	9	6	5
17	1	9	5	9	4
18	0	9	8	2	5
19	-3	0	5	1	4
20	2	10	9	3	1
21	-5	4	0	6	-1
22	0	2	-5	4	6
23	10	0	3	1	5
24	-1	2	5	6	-3
25	0	-1	2	5	-2