slove it in excel

A B C D E F G . Q1) One of New England Air's top competitive priorities is on-time arrivals. Quality VP Clair Bond decided to personally monitor New England Air's performance. Each week for the past 30 weeks, Bond checked a random sample of 100 flight arrivals for on-time performance. The table that follows contains the number of flights that did not meet New England Air's definition of "on time": a) Using a 95% confidence level, plot the overall percentage of late flights (p) and the upper and lower control limits on a control chart. 1 b) Assume that the airline industry's upper and lower control limits for flights that are not on time are .1000 and .0400, respectively. Draw them on your control chart. 2 3 4 c) Plot the percentage of late flights in each sample. Do all samples fall within New England Air's control limits? When one falls outside the control limits, what should be done? 5 6 d) What can Clair Bond report about the quality of service? 7 8 9 20 or the Sample (week) Late Flights 2. 1 2 4 eet New 3 10 4. 4 5 1 d the 6 1 7 13 8 9 at are not 9 11 10 0 11 3 ew England one? 12 4 13 2 14 2 15 8 8 16 2 17 3 18 19 NWY 20 21 3 22 7 23 4 24 3 25 2 26 2 27 28 1 29 3 30 4