Spreadsheet Tn-State Bank is investigating the processing time for loan applications. Samples were taken for 25 random days from four branches. These data can be found in the table below Day Branch 1 Branch 2 Branch 3 Branch 4 4 5 6 2 9 10 11 12 13 19 12 22 24 11 26 15 10 24 22 17 22 11 13 14 23 18 17 14 19 24 12 10 8 23 12 25 22 21 31 21 24 21 35 34 24 25 31 20 24 12 8 11 15 11 10 26 18 9 22 21 17 Day 14 15 16 17 18 19 20 21 22 23 24 25 Branch 1 9 12 26 207 7 28 27 12 20 18 B Branch 2 23 11 13 12 20 15 26 16 11 13 21 13 Branch 24 20 15 18 31 20 34 14 33 20 30 43 Branch 10 20 27 23 10 8 11 18 16 21 19 6 What is the overall mean? Do not round Intermediate calculations Hound your answer to three decimal places What is the werage range? Do not round intermediate calculations, Round your answer to three decimal places Compute the control tinuts for and charts. Use the control chart factors in Appendix to answer the questions. Do not round intermediate calculations. If your answer er, enter "0". Round your answers to three decimal places For the chart LCU Uch mework Quality Control and SPC what is the over meanr o not rouna intermediate caiculations. Hound your answer to three decimal places What is the average range? Do not round intermediate calculations, Round your answer to three decimal places Compute the control limits for - and R-charts. Use the control chart factors in Appendix to answer the questions. Do not round intermediate calculations. If your answer is zero, enter "o". Round your answers to three decimal places For the chart LCU ULY For the chart LCL UCLA Choose the correct graph for the chart