Give solution on excel sheetP$-$Chart: A manufacturing process is monitored using a P$-$chart for the proportion of defective items in a sample of $50$ items taken every hour. The process has been in control for the past $20$ hours. The historical average proportion of defects is $2\%.$ During these $20$ hours, the proportions of defective items in each sample were as follows:

$]$

$[0\mathrm{.}02,0\mathrm{.}03,0\mathrm{.}03,0\mathrm{.}04,0\mathrm{.}02,0\mathrm{.}03$

a$.$ Calculate the centerline $($CL$)$ and the upper control limit $($UCL$)$ for the P$-$chart. b$.$ Using the data provided, determine if the process is currently in control. If not, which points $($if any$)$ are out of control?

C$-$Chart: A hospital laboratory conducts blood tests for glucose levels, and a Cchart is used to monitor the number of errors per day. The laboratory has been monitoring errors for $15$ consecutive days, and the daily counts of errors are as follows:

$2,1,3,0,2,1,0,1,3,0,2,1,1,0,2$

a$.$ Calculate the centerline $($CL$)$ and the upper control limit $($UCL$)$ for the C$-$chart. b$.$ Using the data provided, determine if the process is currently in control. If not, which days $($if any$)$ have excessive errors?