Please show me how in excel..........Completed forms from a particular department of an insurance company were sampled daily to check the performance quality of the department. To establish a tentative norm for the department, a sample of 100 units was collected each day for 15 days, with the following results: (Show all your work) Sample/ Sample Size /# of Incorrect Forms 1) 100/4, 2) 100/3, 3) 100/5, 4) 100/0, 5) 100,2, 6) 100/8, 7) 100/1, 8) 100/3, 9) 100/4, 10) 100/2, 11) 100/7, 12) 100/2, 13) 100/1, 14) 100/3, 15) 100/1

a) Calculate the centerline, sample standard deviation, and control limits for a p-chart using a 95% confidence interval (Use z = 1.96. You can also see this z-score for a 95% confidence interval in the chart attached below. The first column in the chart gives you up to the first decimal place of the z-value, and as you move right in the chart, you get the second decimal place of the z-value. If you look at the values listed under z, and look at the row corresponding to -1.9, then you can see that under the column corresponding to .06, the value mentioned is 0.0250. This means that the probability to the left of the value -1.96 on a standard normal distribution is 0.0250, or 2.5%. Similarly, the probability to the right of the value 1.96 on that distribution will be 0.0250, or 2.5%, by symmetry. Meaning that the probability lying between -1.96 and 1.96, on a standard normal distribution is = 1 0.0250 0.0250 = 0.95, or 95%). (10pts) b) Construct the p-chart using the data, and the calculations you did in part (a). (Recall that a p-chart plots the sample number (1,2,,15) on the horizontal axis, and the corresponding proportion of defects in that sample on the vertical axis. It does not matter whether you use a program to do this, or do it by hand. Either way, please mark the units on the axes. You are not required to draw it to scale, but if there are points outside the control limits, those points should be correctly identifiable from your chart, and so should the points lying inside the control limits.) (10pts) c) What is your interpretation of the p-chart that you just created? (5pts)