show work with cell referencing
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, \begin{tabular}{ll|l|l|l} if I asked you the sum of cells BS through D5, this is what I want to see: 7035.0 or & 7035.0 \end{tabular} 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 aulomated sampling and qualify control system experienced a systems falure. You job is to evaluate the data colected over the post 6 hours to detemine if the process being measured was in control the entire time. Sux measurements were taken in each samplo, and seventy two samples total were gathered. The measurements are the diameter of a hold that driled in a plece of aluminum. 11 12 13 14 15 18 17 10 10 20 21 22 23 24 25 20 27 28 20 30 31 22 33 34 35 30 \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & RVAT & ONS & WITHIN & SAMP & 8s \\ \hline Sample & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline 1 & 1.224 & 1.260 & 1272 & 1200 & 1.257 & 1.276 \\ \hline 2 & 1.200 & 1211 & 1.260 & 1.213 & 1.221 & 1227 \\ \hline 3 & 1.244 & 1250 & 1216 & 1.244 & 1.202 & 1271 \\ \hline 4 & 1.220 & 1277 & 1.252 & 1.281 & 1.220 & 1.206 \\ \hline 5 & 1.204 & 1254 & 1210 & 1.206 & 1.241 & 1276 \\ \hline 6 & 1293 & 1234 & 1256 & 1257 & 1.210 & 1236 \\ \hline 7 & 1.227 & 1239 & 1240 & 1,200 & 1.242 & 1215 \\ \hline 6 & 1.271 & 1201 & & 1.243 & 1.205 & 1216 \\ \hline 9 & 1.260 & 1240 & 1282 & 1.207 & 1.249 & 1250 \\ \hline 10 & 1270 & 1.205 & 1202 & 1,276 & 1.247 & 1.204 \\ \hline 11 & 1.203 & 1200 & 1201 & 1.746 & 1.784 & 1200 \\ \hline 12 & 1.230 & 1271 & 1.287 & 1256 & 1.232 & 1294 \\ \hline 12 & 1.217 & 1.293 & 1.254 & 1.231 & 1.246 & 1279 \\ \hline 14 & 1.280 & 1267 & 1220 & 1.235 & 1,254 & 1.267 \\ \hline 15 & 1.259 & 1204 & 1.271 & 1.213 & 1.709 & 1.290 \\ \hline 16 & 1.220 & 1226 & 1.261 & 1.244 & 1.265 & 1.240 \\ \hline 17 & 1.263 & 1.270 & 1.227 & 1.275 & 1.264 & 1247 \\ \hline 18 & 1.243 & 1256 & 1294 & 1.277 & 1.228 & 1734 \\ \hline 10 & 1.256 & 1.265 & 1230 & 1283 & 1.753 & 1.201 \\ \hline 20 & 1260 & 1225 & 1218 & 1217 & 1.219 & 1.286 \\ \hline 21 & 1220 & 1216 & 1273 & 1.247 & 1.280 & 1.225 \\ \hline 22 & 1.242 & 1230 & 1256 & 1.205 & 1.251 & 1.201 \\ \hline \end{tabular} 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? 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, \begin{tabular}{ll|l|l|l} if I asked you the sum of cells BS through D5, this is what I want to see: 7035.0 or & 7035.0 \end{tabular} 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 aulomated sampling and qualify control system experienced a systems falure. You job is to evaluate the data colected over the post 6 hours to detemine if the process being measured was in control the entire time. Sux measurements were taken in each samplo, and seventy two samples total were gathered. The measurements are the diameter of a hold that driled in a plece of aluminum. 11 12 13 14 15 18 17 10 10 20 21 22 23 24 25 20 27 28 20 30 31 22 33 34 35 30 \begin{tabular}{|c|c|c|c|c|c|c|} \hline & & RVAT & ONS & WITHIN & SAMP & 8s \\ \hline Sample & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline 1 & 1.224 & 1.260 & 1272 & 1200 & 1.257 & 1.276 \\ \hline 2 & 1.200 & 1211 & 1.260 & 1.213 & 1.221 & 1227 \\ \hline 3 & 1.244 & 1250 & 1216 & 1.244 & 1.202 & 1271 \\ \hline 4 & 1.220 & 1277 & 1.252 & 1.281 & 1.220 & 1.206 \\ \hline 5 & 1.204 & 1254 & 1210 & 1.206 & 1.241 & 1276 \\ \hline 6 & 1293 & 1234 & 1256 & 1257 & 1.210 & 1236 \\ \hline 7 & 1.227 & 1239 & 1240 & 1,200 & 1.242 & 1215 \\ \hline 6 & 1.271 & 1201 & & 1.243 & 1.205 & 1216 \\ \hline 9 & 1.260 & 1240 & 1282 & 1.207 & 1.249 & 1250 \\ \hline 10 & 1270 & 1.205 & 1202 & 1,276 & 1.247 & 1.204 \\ \hline 11 & 1.203 & 1200 & 1201 & 1.746 & 1.784 & 1200 \\ \hline 12 & 1.230 & 1271 & 1.287 & 1256 & 1.232 & 1294 \\ \hline 12 & 1.217 & 1.293 & 1.254 & 1.231 & 1.246 & 1279 \\ \hline 14 & 1.280 & 1267 & 1220 & 1.235 & 1,254 & 1.267 \\ \hline 15 & 1.259 & 1204 & 1.271 & 1.213 & 1.709 & 1.290 \\ \hline 16 & 1.220 & 1226 & 1.261 & 1.244 & 1.265 & 1.240 \\ \hline 17 & 1.263 & 1.270 & 1.227 & 1.275 & 1.264 & 1247 \\ \hline 18 & 1.243 & 1256 & 1294 & 1.277 & 1.228 & 1734 \\ \hline 10 & 1.256 & 1.265 & 1230 & 1283 & 1.753 & 1.201 \\ \hline 20 & 1260 & 1225 & 1218 & 1217 & 1.219 & 1.286 \\ \hline 21 & 1220 & 1216 & 1273 & 1.247 & 1.280 & 1.225 \\ \hline 22 & 1.242 & 1230 & 1256 & 1.205 & 1.251 & 1.201 \\ \hline \end{tabular} 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