Question: Please show how to do this in excel! An automated sampling and quality control system experienced a systems failure. You job is to evaluate the

Please show how to do this in excel!

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 3 4 5 6 7 1.200 8 9 10 11 12 13 14 15 16 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 OBSERVATIONS WITHIN SAMPLES 1 2 3 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.2851 1.282 1.276 1.247 1.284 1.293 1.200 1.201 1.246 1.284 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 1.262 1.274 1.277 1.203 1.220 1.289 1.237 1.285 1.299 1.227 1.279 1.212 1.297 1.249 1.222 1.233 1.206 1.251 1.244 1.276 1.257 1.295 1.294 1.211 1.274 1.265 1.289 1.247 1.224 1.231 1.286 1.249 1.271 1.281 1.216 1.255 1.292 1.237 1.289 1.206 1.239 1.270 1.266 1.298 1.224 1.250 1.234 1.206 1.294 1.253 1.202 1.213 1.204 1.266 1.224 1.268 1.287 1.285 1.259 1.254 1.270 1.212 1.253 1.280 1.219 1.229 1.233 1.2151 1.221 1.281 1.268 1.264 1.269 1.278 1.234 1.283 1.234 1.204 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.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.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.216 1.286 1.248 1.273 1.210 1.265 1.256 1.2671 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.2401 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.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.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.2101 1.202 Question 1 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 3 If the process is not in control, specifically when did it go out of control? R-bar D3 D4 X-bar A2 Grading Rubric Points Points 0 Question Possible Earned Comments 2 1 45 0 2 45 0 0.48 3 10 TOTAL 100 OOO O

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Henry Coupe, the manager of a metropolitan branch office of the state department of motor vehicles, attempted to analyze the drivers license-renewal operations. He had to perform several steps. After...

****Please dont copy other people work*****Please Show the work in excel with the formula. Q HQ84BBTB98a28 D E F H 1 J K L M N N O P 1 Quality Control Assignment 2 3 You must do the necessary...

****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...

I desperately need help! Please give me step by step instructions of what to enter into each cell as a formula. Thank you! N B B C D D E F G H I J K M 1 Quality Control Assignment 2 3 You must do the...

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...

Please do in Excel if possible and show equations:) Much Appreciated G H T J K L M N O B C DEF An automated sampling and quality control system experienced a systems failure. You job is to evaluate...

1 Quality Control Assignment 2 3 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. 4 When look at the answer cell,...

D E E F G H j K L M N 0 Q R A B 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...

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...

3 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. 4 When look at the answer cell, I want to see a number, when I...

Please include calculations 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 detenine if the process...

Find the area of the region that lies inside both of the circles r = 2 sin ( and r = sin ( + cos (?

"Let's eat: A fast-food restaurant chain has 594 outlets in the United States. The following table categorizes them by city population size and location, and presents the number of restaurants in...

WRITE THE CORRECT LETTER OR NUMBER IN THE SPACE PROVIDED. ( 1 1 . ) The Golden Eagle Corporation uses the indirect method for preparation ofits Statement of Cash Flows. The statement includes the...

Managerial Accounting (ACCO 504): I will appreciate your help! K L N B C D E F G H J M A Exercise 25-4 Name: Section: Score: _0% Key Code: [Key code here] Instructions Answers are entered in the...