****Please dont copy other people work*****Please Show the work in excel with the formula.

Quality Control Assignment 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 D5, this is what I want to see 7035.0 7035.0 1234 2345 3456 Be sure to show all of your work. or 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 8 9 10 11 12 13 14 OBSERVATIONS WITHIN SAMPLES 1 2 3 4 5 6 1.224 1.2601 1.272 1.209 1.252 1.276 1.299 1.211 1.2601 1.213 1.221 1.227 1.244 1.258 1.216 1.244 1.282 1.271 . 1.220 1.2771 1.252 1.281 1.229 1.206 1.204 1.254 1.2191 1.296 1.241 1.276 001 1.293 1.234 1.256 1.257 4200 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.2171 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.2631 1.278 1.227 1.275 1.2641 1.247 15 16 17 B D E F G H 1 J K L M N O 1.275 1.277 1.283 1.217 1.247 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 56 57 58 59 60 61 62 63 64 65 66 67 68 17 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 46 47 48 49 50 51 52 53 54 1.263 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.278 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.2121 1.215 1.278 1.243 1.293 1.221 1.255 1.232 1.262 1.227 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.253 1.221 1.234 1.216 1.286 1.248 1.273 1.2101 1.265 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.264 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.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.247 1.234 1.291 1.286 1.225 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.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.224 1.211 1.214 A B D E F G H J J K L M N o P Q 1.292 1.243 1.2951 67 53 1.249 1.232 1.210 1.256 1.211 1.287 68 54 1.299 1.262 1.265 1.275 1.214 1.288 69 55 1.225 1.250 1.256 1.203 1.217 1.251 70 56 1.288 1.289 1.267 1.202 1.242 1.249 71 57 1.253 1.229 1.216 1.277 1.241 1.211 72 58 1.291 1.274 1.251 1.224 1.264 1.203 73 59 1.262 1.254 1.203 1.261 1.259 1.211 74 60 1.296 1.225 1.235 1.225 1.286 75 61 1.283 1.235 1.249 1.203 1.211 1.233 76 62 1.261 1.220 1.254 1.238 1.219 77 63 1.255 1.298 1.204 1.257 1.238 1.257 78 64 1.209 1.230 1.209 1.300 1.273 1.203 79 65 1.267 1.228 1.283 1.266 1.245 1.228 80 66 1.200 1.200 1.200 1.210 1.200 1.210 81 67 1.221 1.239 1.297 1.216 1.249 1.267 82 68 1.298 1.291 1.243 1.288 1.214 1.210 83 69 1.271 1.286 1.213 1.206 1.232 84 70 1.221 1.226 1.266 1.209 1.247 1.207 85 71 1.214 1.217 1.262 1.230 1.205 1.210 86 72 1.264 1.271 1.240 1.242 1.250 1.202 87 88 89 90 Question Determine the correct control charts to use, then calculate the data needed for each 91 control chart, then create and show the control charts below. 92 Question Evaluate each control chart (in the propor order) using the four factors to check identified 93 in the lecture notes to determine if the process is in control 94 Question : If the process is not in control, specifically when did it go out of control? 95 96 97 Grading Rubric 98 R-bar Points Points 99 D3 o Question Possible Earned Comments 100 D4 2 1 45 0 101 X-bar 2 45 0 o A2 0.48 3 10 0 103 TOTAL 100 0 104 102 B D E F G H 1.277 . TZ 13 14 Sample 15 1 16 2 17 3 18 4 19 5 20 6 21 7 22 8 23 9 24 10 25 11 26 12 27 13 28 14 29 15 30 16 31 17 32 18 33 19 34 20 35 21 36 22 37 23 38 24 39 25 40 26 41 27 42 28 43 29 44 30 45 31 46 32 47 33 48 34 49 35 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.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 1.242 1.238 1.256 1.295 1.251 1.201 1.264 1.241 1.276 1.223 1.270 1.280 1.207 1.228 1.228 1.240 1.257 1.202 1.293 1.293 1.201 1.261 1.263 1.222 1.210 1.270 1.283 1.285 1.256 1.280 1.297 1.209 1.260 1.215 1.227 1.217 1.215 1.266 1.235 1.204 1.235 1.248 1.211 1.218 1.245 1.287 1.253 1.283 1.267 1.274 1.260 1.253 1.210 1.250 1.241 1.244 1.203 1.244 1.298 1.226 1.278 1.270 1.234 1.246 1.215 1.215 1.278 1.259 1.233 1.290 1.232 1.285 1.292 1.201 1.292 1.285 1.250 1.221 1.229 1.238 1.298 1.300 1.248 1.261 A B C D II E F G H 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 9 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 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.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.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.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.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.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.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.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.248 1.2201 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.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.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 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 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 Sheet1 Sheet2 Sheet3 +