A quality engineer took 40 samples of 100 transistors each f

A quality engineer took 40 samples of 100 transistors each from the output of an assembly line. Each transistor was tested and the number of defectives in each sample is recorded in the table below.
Sample / Number Defective     Sample / Number Defective
1 3                                               21 1
2 2                                               22 2
3 1                                              23 2
4 4                                              24 3
5 0                                             25 4
6 2                                              26 1
7 0                                             27 2
8 5                                           28 4
9 1                                         29 0
10 2 30 4
11 2 31 3
12 1                                    32 2
13 3                                    33 4
14 3                                 34 2
15 4                                   35 1
16 5    36 1
17 3    37 3
18 3    38 4
19 1                                       39 4
20 8 40 2
1. Determine the control chart limits for a p-chart then draw and label the control chart.
2. What does the chart tell you about this process?

Solution

Can you please provide the excel chart for this. I am trying to read the data from the given question but its not properly arranged.