Please answer this question and not just post an old one! Thank you!

H Video Excel Online Structured Activity: P chart The CeeJay Lightbulb Co. makes 40-watt light bulbs, and it has decided to begin monitoring is quality using a chart. 5o, over the past thirty days, it has collected and tested 200 bulbs cach day. 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 THI Open spreadsheet Questions 1. What is the mean fraction defective for all samples collected? Round your answer to three decimal places 2. What is the sample standard deviation? Do not round intermediate caloitations. Round your answer to three decimal places 3. What is the lower controllimit, LCI? Do not round intermediate calculations. If your answer is zero, entero Round your answer to three decimal places. 4. What is the upper controllimit, UCL Do not round intermediate calculations. If your answer is zero, enter O. Round your answer to three decimal places. > F3 Jx c D E G H Formula Average (p-bar Standard Deviation LCLP UCLP Standard Deviation Mean UCLP NO NOONG B 1 P-chart 2 3 Sample size 200 4 Number of samples 30 5 6 7 Fraction 9 Day Defective LCLP 10 1 0.02 11 2 0.00 12 3 0.03 13 4 0.01 14 5 0.03 15 6 0.04 16 7 0.02 17 8 0.02 18 9 0.02 19 10 0.02 20 11 0.02 21 12 0.01 22 13 0.03 23 14 0.03 24 15 0.01 25 16 0.00 26 17 0.00 27 18 0.03 28 19 0.01 29 20 0.02 30 21 0.01 31 22 0.04 32 23 0.03 33 24 0.03 34 25 0.04 35 26 0.03 36 27 0.00 37 28 0.02 38 29 0.03 59 30 0.03 10 11 Use the area below to draw a line chart for P-chart. 2 LCLP #N/A #N/A #N/A #N/A #N/A #NA #N/A #N/A #NA #N/A #N/A #N/A #UA #N/A #NJA #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A O o Con UN NNNNNNNN