You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B5 through DS, this is what I want to see: 7035.0 or 7035.0 123423453456 Be sure to show all of your work. Problem 1: Use the data that is given below to answer the question that follow. An automated sampling and quality control system experiencod a systems failure. You job is to evaluate the data collected over the past 6 hours to detemine if the process being measured was in control the entire time. Six measuremente were taken in each sample, and seventy two samples total were gathered. The measurements are the diameter of a hold that drilled in a piece of aluminum. Question Determine the correct control charts to use, then calculate the data needed for each control chart, then create and show the control charts below. Question Evaluate each control chart (in the propor order) using the four factors to check identified in the lecture notes to determine if the process is in control Question If the process is not in control, specifically when did it go out of control