Daily inspections results for the model 4116 electrical screwdriver assembly line, during the month of May, are given in the table below.

DateNumber Inpected Number Non-conforming

1-May 500 5

2-May 550 6

3-May 700 8

4-May 620 13

5-May 700 7

8-May 550 8

9-May 650 7

10-May 600 6

11-May 470 9

12-May 450 16

15-May 590 7

16-May 550 8

17-May 530 7

18-May 530 10

19-May 650 3

22-May 680 8

23-May 450 2

24-May 500 18

25-May 400 3

26-May 550 8

29-May 600 10

30-May 700 4

31-May 660 9

1-Jun 450 8

2-Jun 500 6

a) Plot apchart for this process.

b) Assuming that out of control points are assignable, prepare the revisedpchart for the following weeks in the month of June (tip: to calculate the new control limits use the closest multiple of 10 to the average number of inspection).

Please solve using excel