PLEASE ANSWER STEP BY STEP USING EXCEL

We are conducting quality assurance inspections for a local manufacturer. Suppose that 20 samples of 75 items are inspected with a go/no-go decision. The results of our inspections are in the table below. Calculate the upper & lower control limits and then create a p-chart. Identify any instances where the process is out of control.

Sample # Defective

1 3

2 1

3 0

4 5

5 2

6 5

7 3

8 6

9 1

10 4

11 0

12 2

13 1

14 3

15 4

16 9

17 1

18 2

19 8

20 2