please use this data to answer the questions and please provide EXCEL formulas

Problem 1: Use the data that is given below to answer the question that follow. An automated sampling and quality control system experienced 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 measurements 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. Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 OBSERVATIONS WITHIN SAMPLES 1 2 3 4 5 6 1.224 1.260 1.272 1.209 1.252 1.276 1.299 1.211 1.260 1.213 1.221 1.227 24 1.24 282 1.27 1.220 1.277 1.252 1.281 1.229 1.206 1.204 1.254 1.219 1.296 1.241 1.276 1.293 1.234 1.256 1.257 1.210 1.236 1.227 1.239 1.249 1.260 1.242 1.215 1.271 1.201 1.296 1.243 1.205 1.216 1.268 1.249 1.282 1.297 1.249 1.259 1.276 1.285 1.282 1.276 1.247 1.284 1.293 1.200 1.201 1.246 1.284 1.200 1.230 1.271 1.287 1.256 1.232 1.294 1.217 1.293 1.254 1.231 1.246 1.279 1.289 1.267 1.220 1.238 1.254 1.267 1.259 1.204 1.271 1.213 1.209 1.299 1.228 1.226 1.261 1.244 1.265 1.240 1.263 1.278 1.227 1.275 1.264 1.247 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 1.243 1.258 1.260 1.220 1.242 1.264 1.207 1.293 1.210 1.297 1.215 1.211 1.267 1.241 1.278 1.278 1.292 1.229 1.262 1.237 1.297 1.244 1.274 1.286 1.292 1.266 1.294 1.224 1.256 1.265 1.225 1.216 1.238 1.241 1.228 1.293 1.270 1.209 1.266 1.218 1.274 1.244 1.270 1.259 1.201 1.238 1.274 1.285 1.249 1.276 1.265 1.249 1.237 1.298 1.253 1.268 1.298 1.230 1.218 1.273 1.256 1.276 1.228 1.201 1.283 1.260 1.235 1.245 1.260 1.203 1.234 1.233 1.292 1.298 1.277 1.299 1.222 1.257 1.289 1.271 1.289 1.224 1.202 1.287 1.277 1.283 1.217 1.247 1.295 1.223 1.240 1.261 1.285 1.215 1.204 1.287 1.253 1.244 1.246 1.290 1.285 1.300 1.203 1.227 1.233 1.295 1.247 1.281 1.206 1.250 1.213 1.285 1.228 1.253 1.219 1.280 1.251 1.270 1.257 1.263 1.256 1.227 1.235 1.253 1.210 1.298 1.215 1.232 1.250 1.248 1.220 1.279 1.206 1.2941 1.224 1.216 1.239 1.234 1.204 1.259 1.234 1.291 1.286 1.225 1.2011 1.280 1.202 1.222 1.280 1.217 1.248 1.283 1.250 1.226 1.215 1.285 1.221 1.261 1.289 1.212 1.251 1.211 1.2311 1.255 1.270 1.206 1.266 1.254 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 63 69 70 71 72 1.270 1.233 1.269 1.217 1.276 1.243 1.263 1.249 1.299 1.225 1.288 1.253 1.291 1.262 1.396 1.283 1.261 1.255 1.209 1.267 1.200 1.221 1.298 1.271| 1.221 1.214 1.264 1.212 1.215 1.278 1.243 1.293 1.221 1.255 1.232 1.262 1.250 1.289 1.229 1.274 1.254 1.225|| 1.235 1.243 1.298 1.230 1.228 1.200 1.239 1.291 1.286 1.226 1.217 1.271 1.253 1.221 1.2341 1.216 1.286 1.248 1.273 1.210 1.265 1.256 1.267 1.216 1.251 1.203 1.235 1.249 1.220 1.204 1.209 1.283 1.200 1.297 1.243 1.213 1.266 1.262 1.240 1.280 1.2811 1.283 1.242 1.222 1.204 1.236 1.256 1.275 1.203 1.202 1.277 1.224 1.261 1.225 1.203 1.254 1.257 1.300 1.266 1.210 1.216 1.288 1.206 1.209 1.230 1.242 1.219 1.268 1.2341 1.207 1.205 1.201 1.2241 1.211 1.214 1.217 1.242 1.241 1.264 1.259 1.286 1.211 1.238 1.238 1.273 1.245 1.200 1.249 1.214 1.232 1.247 1.205 1.250 1.229 1.264 1.204 1.280 1.237 1.207 1.246 1.287 1.288 1.251 1.249 1.211 1.203 1.211 1.292 1.233 1.219 1.257 1.203 1.228 1.2101 1.267 1.210 1.295 1.207 1.210 1.202 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