Please help solve this problem in Excel and also with the formulas visible. I want to be able to follow the solution to understand how it is done. Thank you!

Acme Systems, Inc. produces a very large volume of plastic rods on a regular basis. These rods require an extremely accurate diameter. Thus, the Quality Control manager wants to know if the production process is producing rods at a consistent diameter. 300 rods have been sampled each day for 10 days. Defects have been recorded. Develop a p control chart for the proportion of defects across the 10 days. Assume Z = 3. Do any of the rods appear to be out of control? Comment on your findings.

Day	Defects
1	15
2	21
3	13
4	11
5	7
6	25
7	7
8	13
9	14
10	9