4. Solve Problem 8-45. The data is file "C08 Problem 8-45.xlsx".

Sample	Number Defective
1	3
2	4
3	6
4	4
5	7
6	11
7	12
8	9
9	4
10	5
11	9
12	10
13	3
14	4
15	3
16	5
17	5
18	6
19	7
20	15
21	13
22	12
23	16
24	11
25	17
26	11
27	9
28	6
29	5
30	8

a. Construct an np-chart for the Dennis Manufacturing Company using the data in the dataset and the np-chart Excel template. The data represent the number of defective parts found in 30 samples, each of size 50.

b. Interpret the results.

Covert the Excel results to PDF and submit as attachment.