Excel Online Activity: p-Chart Automated sorting machines in a post office must read the ZIP code on letters and divert the letters to the proper carrier routes. Over a month's time, * - 25 samples of n - 100 letters were chosen, and the number of errors was recorded. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Questions 1. What is the average fraction nonconforming for the group of K sample? Round your answer to three decimal places 2. What is the standard deviation? Do not round intermediate calculations. Round your answer to five decimal places. 3. What is the lower controllimit, LCL Do not round intermediate calculations. Round your answer to three decimal places. 4. What is the upper control limit, UCL? Do not round intermediate calculations. Round your answer to three decimal places. 5. Choose the correct graph for the p-Chart Neal B 10 General 01 28 F G H 1 M N o 0 UCLP Fraction Nonconforming LCLD CL UCLP INA A 1 D 1 p-Chart 2 3 Samples 100 4 Number of samples Formulas 25 Average ip-bar) ANA 6 Standard Deviation ANIA LCLP 8 MNIA 9 INA 10 Number Standard 11 Sample Nonconforming Devilion 12 0 13 2 14 3 15 4 16 5 5 18 7 0 19 8 6 20 3 10 11 0 12 24 13 1 25 14 1 26 15 2 27 16 26 17 29 18 30 10 6 29 ANAR Standard Devin NA UNA NA WNA INA ANA ANA NA ANIA NA NA ANA NA WA MNA NA ONA RNA UNA Fraction Nonconforming LCLP CL UCLD WNA NANA NA NA ANANIA F ANA PANA ANA TARDA F NA NA PANA PANA - ANA PANA NA WA ANA NA PANANA F ANA NANA NA F NA PANAMA NA NA ANA PANANA NA ANA PANA ANA NA ANANA NA NA PADA ANA PANA NA NAFANA PANA UNA PAWA WA TAA WNA NANNA PANA WNA NA PONARA A PONANA NA NA UNA FINANA NA PA ONA NA NA F ANA N/A WNA MNA NA NNA F #NA WNIA ANA NA WNIA F WNA ONA 19 20 21 22 23 24 25 26 22 28 29 30 31 WNA INA ONIA 5 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 3 2 0 2 1 1 2 2 1 3 6 1 5 2 1 ONIA NA MNA ANA UNA NNIA N/A NA WNA IN/A ANIA #NA WNIA FINANA NA NA NAMNA ANAANIA NA ONA NA PONIA PANIA NA NA ONA NA NA NA WANNA ONA ANAPONA NA NIA NA NA WATANIA NA NA NA NANNA PANA ONA NA NA ANAMNIA PANA NA NA NA PONA NA NA NANA NA ANA NA NA WNANIA NA NA PANANA F NNIA ANA WNA MN/A ANA ANA ANIA #N/A MNIA WNIA 33 34 35 36 4 38 Use the area below to draw a line chart for p-Chart. 39 40 41 42 43