please solve part A,B,C using my data given. the other photos are example answers but diffrent data. please show in excel thank you!!

One of Nen England Airs top competitwe prieritios is on-tme artivas. Quality ve Clair Bond decided to personally montor New England Alr's pertormance. Each week for the past 30 weeks, Bor checknd a randomi sample of 100 fight arevals for on-time perlormance. Cick the soon to view the tabie that contains the number of nights thet did not meet New England Air's definition of on tive. a) The overall fraction of late fights is (enter your response as a real number rounded to two decimsl places.) Using a 95% conddence level, the upper and lower control limits are: Upper contro: limit (UULp)= (enter your ressonse as a fraction between 0 and 1, rounded to four decinar piaces). Data table One of New England Air's top competitive prionities is on-time arrivals. Quality V.P. Clair Bond decided to personally monitor New England Air's performance. Each week for the past 30 weeks, Bond checked a random samplo of 100 fight arrivals for on-time performance. Click the icon to view the table that contains the number of flights that did not meet New England Airs definition of on time. a. Find the overall percentage of late fights. p=NumberofsamplesSamplesizeTotalnumberofLateflights=30100120=0.04 ) (Enter your response as a real number rounded to two decimal places.) Calculate the standard deviation of the process population. p^=np(1p)=1000.040.96=0.0196(Enteryourresponseasarealnumberroundedtofourdecimalpplaces.) Using a 95% confidence level, find the upper and lower control limits. Recall that upper and lower control limits can be set by using the following formulas, where z=1.96 for 95% confidence level. Upper control limit (UCLp)=p+1.96p^ Lower control limit (LLLp)=p1.96pp^ Compute UCLP and LCLp. UCLp=0.04+1.960.0196=0.0784 (Enter your response as a real number rounded to four decimal places.) LCLp=0.041.960.0196=0.0016 ' (Enter your response as a reat number rounded to four decimat places.) a. Assume that the airine industry's upper and lower control limits for fights that are not on time are 0.1000 and 0.0400, respectively. Drars them on the control chart Choose the correct chart bolow. c. Plot the percentage of late fights in each sample. Do all samples fall within airlines control limits? When one falls outside the control limits, what should be done? Calculate the percentages of late flights, (n/100), in each sample. Complete the table (enter your responses as real numbers rounded to two decimal piaces.) Do all samples fall within New England Air's control limits? No Yes Note that the control chart above indicate that the quality requirements of the airlines are more stringent than those of the airline industry as a whole. Recall that if a point on the control chart falls outside of the 1.960. control limits, then we are 95% sure the process has assignable variations. This is the theory behind control charts. When one falls outside the control limis, what should be done? A. Find new control limits, so that each sample falls within new limits. B. An invebtigation, leading to corrective action, should be done. C. Nothing should be done