PLEASE USE EXCEL FORMULAS--- THANK YOU! CORRECT ANSWER WILL RECEIVE THUMBS UP

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. | 9 Sample 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 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 1.244 1.258 1.216 1.244 1.282 1.271 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 1.243 1.256 1.298 1.277 1.228 1.234 1.258 1.265 1.230 1.283 1.253 1.291 1.260 1.225 1.218 1.217 1.219 1.286 1.220 1.216 1.273 1.247 1.280 1.225 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 1.242 1.264 1.207 1.293 1.210 1.297 1.215 1.211 1.267 1.241 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.270 1.233 1.269 1.217 1.276 1.243 1.263 1.249 1.299 1.225 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.212 1.215 1.278 1.243 1.293 1.221 1.255 1.232 1.262 1.250 1.256 1.276 1.228 1.201 1.283 1.260 1.235 1.245 1.260 1.203 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.253 1.221 1.234 1.216 1.286 1.248 1.273 1.210 1.265 1.256 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.280 1.281 1.283 1.242 1.222 1.204 1.236 1.256 1.275 1.203 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.294 1.224 1.216 1.239 1.234 1.204 1.259 1.219 1.268 1.234 1.207 1.205 1.201 1.224 1.211 1.214 1.217 1.201 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.231 1.255 1.270 1.206 1.266 1.254 1.229 1.264 1.204 1.280 1.237 1.207 1.246 1.287 1.288 1.251 56 57 58 59 60 61 62 63 64 65 66 67 68 1.288 1.253 1.291 1.262 1.296 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.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.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.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.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.249 1.211 1.203 1.211 1.292 1.233 1.219 1.257 1.203 1.228 1.210 1.267 1.210 1.295 1.207 1.210 1.202 69 70 71 72 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