No Special Requirements for this Submission File. You may use the space to the right to place your calcualtions. Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 Question 11 Question 12 Question 13 Question 14 Question 15 Question 16 Question 17 Question 18 Question 19 Question 20 Question 21 Question 22 Question 23 Question 24 Question 25 Question 26 Question 27 Question 28 Question 29 Question 30 Answers MBA 6300 online Homework Assignment #7 - Statistical Quality Control Instructions: The homework must be placed in the Assignment Submittal link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions, for the assignment, will be released in Bb the morning after the due date for access by students. Total points for the assignment is 110. Note: There is no partial credit given; either the answer is correct or incorrect. Please place your answers in the Excel File provided by the Instructor. Question 1: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) Question 2: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) Question 3: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) Question 4: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) Question 5: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) Question 6: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) Question 7: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a pchart with data gathered from 30 subgroups of size 25 that had a total of 84 non conforming units. (2.5 points) Question 8: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 25 subgroups of size 30 that had a total of 102 non conforming units. (2.5 points) Dr. Mike's MBA 6300 Homework #7 Page 1 Question 9: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 20 subgroups of size 35 that had a total of 67 non conforming units. (2.5 points) Question 10: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 25 samples that had a total of 70 nonconforming units. (2.5 points) Question 11: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 35 samples that had a total of 88 nonconforming units. (2.5 points) Question 12: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a cchart with data gathered from 30 samples that had a total of 75 nonconforming units. (2.5 points) Scenario: A manufacturer of automobile glass employs a constant quality control technique where the thickness of glass is checked periodically by taking a sample of 5 units and measuring the thickness. The results of one shift's quality control inspections are shown in the table below. Sample 1 2 3 4 5 6 7 8 9 10 Thickness 4, 3, 4, 2, 4 5, 3, 5, 4, 2 3, 3, 3, 3, 4 4, 5, 5, 4, 5 1, 7, 6, 1, 1 4, 5, 2, 5, 4 3, 5, 4, 4, 5 2, 4, 4, 4, 3 5, 4, 3, 2, 5 4, 4, 4, 4, 4 Sample 11 12 13 14 15 16 17 18 19 20 Thickness 1, 6, 4, 4, 2 3, 3, 4, 5, 4 2, 7, 2, 7, 5 3, 2, 5, 4, 2 3, 3, 3, 2, 1 4, 4, 4, 5, 3 5, 3, 4, 4, 3 4, 4, 5, 3, 3 1, 4, 3, 3, 3 4, 4, 3, 5, 4 Question 13: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) Question 14: Using the data contained in the scenario calculate the Lower Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) Question 15: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) Question 16: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) Dr. Mike's MBA 6300 Homework #7 Page 2 Question 17: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) Question 18: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) Scenario: A canning company packages canned soup for a major soup manufacturer for distribution to regional wholesalers. The company processes 5,000 cans of soup each day using an automated packaging machine that is programmed to fill each can with 74.0 0.1 ounces net weight of soup. The company's quality assurance process consists of randomly selecting five cans from the production line each hour and carefully weighing them. Sample observations for a 24hour production run are reflected in the table below. Hour 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Sample 1 74.030 73.995 73.988 74.002 73.992 74.009 73.995 73.985 74.008 73.998 73.994 74.004 73.983 74.006 74.012 74.000 73.994 74.006 72.755 74.000 73.982 74.004 74.010 74.015 73.982 Sample 2 74.002 73.992 74.024 73.996 74.007 73.994 74.006 74.003 73.995 74.000 73.998 74.000 74.002 73.967 74.014 73.984 74.012 73.001 74.002 74.010 74.001 73.999 73.989 74.008 73.984 Sample 3 74.019 74.001 74.021 73.993 74.015 73.997 73.994 73.993 74.009 73.990 73.994 74.007 73.998 73.994 73.998 74.005 73.065 74.018 74.003 74.013 74.015 73.990 73.990 73.993 73.995 Sample 4 73.992 74.011 74.005 74.015 73.989 73.985 74.000 74.015 74.005 74.007 73.995 74.000 73.997 74.000 73.999 72.856 74.005 74.003 74.005 74.020 74.005 74.006 74.009 74.000 74.017 Sample 5 74.008 74.004 74.002 74.009 74.014 73.993 74.005 73.988 74.004 73.995 73.990 73.996 74.012 73.984 72.996 73.996 74.007 74.000 73.997 74.003 73.996 74.009 74.014 74.010 74.013 Question 19: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (5 points) Dr. Mike's MBA 6300 Homework #7 Page 3 Question 20: Using the data contained in the scenario calculate the Lower Control Limits for an Xbar chart that reflect a 99.7% confidence level. (5 points) Question 21: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) Question 22: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) Question 23: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) Question 24: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) Scenario: The manager of the customer service hotline for an internet service provider has been approached by the President of the company regarding a perceived increase in the number of customer complaints regarding the lack of timely technical assistance being provided by hotline technicians. In order to evaluate the validity of the President's concerns he decided to survey customers regarding their satisfaction with the timeliness of the technical assistance they received. Surveys were conducted during a thirtyday period with one hundred sixty (160) randomly selected customers participating in the survey each day. The number of customers surveyed who expressed dissatisfaction with the timeliness of the technical assistance they received is summarized in the following table. Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 No. Complaints 22 29 25 17 20 16 32 13 31 29 15 15 28 23 27 Day 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Dr. Mike's MBA 6300 Homework #7 Page 4 No. Complaints 15 17 17 19 22 23 27 29 38 21 24 22 24 23 31 Question 25: Using the data contained in the scenario calculate the Upper Control Limit for the number of complaints that reflect a 99.7% confidence level. (5 points) Question 26: Using the data contained in the scenario calculate the Lower Control Limit for the number of complaints that reflect a 99.7%confidence level. (5 points) Question 27: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the number of complaints, which samples are out of control? (5 points) Question 28: Using the data contained in the scenario calculate the Upper Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) Question 29: Using the data contained in the scenario calculate the Lower Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) Question 30: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the proportion of complaints, which samples are out of control? (5 points) Dr. Mike's MBA 6300 Homework #7 Page 5 \f\f\f\f\f\f\f\fMBA 6300 online Homework Assignment #7 - Statistical Quality Control Instructions: The homework must be placed in the Assignment Submittal link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions, for the assignment, will be released in Bb the morning after the due date for access by students. Total points for the assignment is 110. Note: There is no partial credit given; either the answer is correct or incorrect. Please place your answers in the Excel File provided by the Instructor. Question 1: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) (1.4658, 0.5630) Question 2: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) (1.6548, 0.0000) Question 3: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) (2.2887, 1.2300) Question 4: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) (2.1964, 0.0000) Question 5: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) (2.4329, 1.2241) Question 6: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) (2.2155, 0.0000) Question 7: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a pchart with data gathered from 30 subgroups of size 25 that had a total of 84 non conforming units. (2.5 points) (0.2381, 0.0000) Question 8: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 25 subgroups of size 30 that had a total of 102 non conforming units. (2.5 points) (0.3238, 0.0000) Dr. Mike's MBA 6300 Homework #7 Page 1 Question 9: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 20 subgroups of size 35 that had a total of 67 non conforming units. (2.5 points) (0.2449, 0.0000) Question 10: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 25 samples that had a total of 70 nonconforming units. (2.5 points) (7.8200, 0.0000) Question 11: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 35 samples that had a total of 88 nonconforming units. (2.5 points) (7.2712, 0.0000) Question 12: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a cchart with data gathered from 30 samples that had a total of 75 nonconforming units. (2.5 points) (5.6623, 0.0000) Scenario: A manufacturer of automobile glass employs a constant quality control technique where the thickness of glass is checked periodically by taking a sample of 5 units and measuring the thickness. The results of one shift's quality control inspections are shown in the table below. Sample 1 2 3 4 5 6 7 8 9 10 Thickness 4, 3, 4, 2, 4 5, 3, 5, 4, 2 3, 3, 3, 3, 4 4, 5, 5, 4, 5 1, 7, 6, 1, 1 4, 5, 2, 5, 4 3, 5, 4, 4, 5 2, 4, 4, 4, 3 5, 4, 3, 2, 5 4, 4, 4, 4, 4 Sample 11 12 13 14 15 16 17 18 19 20 Thickness 1, 6, 4, 4, 2 3, 3, 4, 5, 4 2, 7, 2, 7, 5 3, 2, 5, 4, 2 3, 3, 3, 2, 1 4, 4, 4, 5, 3 5, 3, 4, 4, 3 4, 4, 5, 3, 3 1, 4, 3, 3, 3 4, 4, 3, 5, 4 Question 13: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) 5.1414 Question 14: Using the data contained in the scenario calculate the Lower Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) 2.1987 Question 15: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) None Question 16: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) 5.3933 Dr. Mike's MBA 6300 Homework #7 Page 2 Question 17: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) 0.0000 Question 18: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) None Scenario: A canning company packages canned soup for a major soup manufacturer for distribution to regional wholesalers. The company processes 5,000 cans of soup each day using an automated packaging machine that is programmed to fill each can with 74.0 0.1 ounces net weight of soup. The company's quality assurance process consists of randomly selecting five cans from the production line each hour and carefully weighing them. Sample observations for a 24hour production run are reflected in the table below. Hour 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Sample 1 74.030 73.995 73.988 74.002 73.992 74.009 73.995 73.985 74.008 73.998 73.994 74.004 73.983 74.006 74.012 74.000 73.994 74.006 72.755 74.000 73.982 74.004 74.010 74.015 73.982 Sample 2 74.002 73.992 74.024 73.996 74.007 73.994 74.006 74.003 73.995 74.000 73.998 74.000 74.002 73.967 74.014 73.984 74.012 73.001 74.002 74.010 74.001 73.999 73.989 74.008 73.984 Sample 3 74.019 74.001 74.021 73.993 74.015 73.997 73.994 73.993 74.009 73.990 73.994 74.007 73.998 73.994 73.998 74.005 73.065 74.018 74.003 74.013 74.015 73.990 73.990 73.993 73.995 Sample 4 73.992 74.011 74.005 74.015 73.989 73.985 74.000 74.015 74.005 74.007 73.995 74.000 73.997 74.000 73.999 72.856 74.005 74.003 74.005 74.020 74.005 74.006 74.009 74.000 74.017 Sample 5 74.008 74.004 74.002 74.009 74.014 73.993 74.005 73.988 74.004 73.995 73.990 73.996 74.012 73.984 72.996 73.996 74.007 74.000 73.997 74.003 73.996 74.009 74.014 74.010 74.013 Question 19: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (5 points) 74.0939 Dr. Mike's MBA 6300 Homework #7 Page 3 Question 20: Using the data contained in the scenario calculate the Lower Control Limits for an Xbar chart that reflect a 99.7% confidence level. (5 points) 73.8234 Question 21: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) Sample 15,16,17, 18 and 19 Question 22: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) 0.4958 Question 23: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) 0.0000 Question 24: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) Sample 15, 16, 17, 18 and 19 Scenario: The manager of the customer service hotline for an internet service provider has been approached by the President of the company regarding a perceived increase in the number of customer complaints regarding the lack of timely technical assistance being provided by hotline technicians. In order to evaluate the validity of the President's concerns he decided to survey customers regarding their satisfaction with the timeliness of the technical assistance they received. Surveys were conducted during a thirtyday period with one hundred sixty (160) randomly selected customers participating in the survey each day. The number of customers surveyed who expressed dissatisfaction with the timeliness of the technical assistance they received is summarized in the following table. Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 No. Complaints 22 29 25 17 20 16 32 13 31 29 15 15 28 23 Day 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Dr. Mike's MBA 6300 Homework #7 Page 4 No. Complaints 15 17 17 19 22 23 27 29 38 21 24 22 24 23 Day 15 No. Complaints 27 Day 30 No. Complaints 31 Question 25: Using the data contained in the scenario calculate the Upper Control Limit for the number of complaints that reflect a 99.7% confidence level. (5 points) 37.5625 Question 26: Using the data contained in the scenario calculate the Lower Control Limit for the number of complaints that reflect a 99.7%confidence level. (5 points) 8.7042 Question 27: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the number of complaints, which samples are out of control? (5 points) Sample 24 Question 28: Using the data contained in the scenario calculate the Upper Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) 0.2280 Question 29: Using the data contained in the scenario calculate the Lower Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) 0.0612 Question 30: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the proportion of complaints, which samples are out of control? (5 points) Sample 24 Dr. Mike's MBA 6300 Homework #7 Page 5 MBA 6300 online Homework Assignment #7 - Statistical Quality Control Instructions: The homework must be placed in the Assignment Submittal link in Bb by midnight of the date shown in the Course Roadmap and Syllabus. The Instructor does not allow late submissions therefore a score of zero (0) will be recorded for the assignment if submitted after midnight Eastern Time of the due date. Solutions, for the assignment, will be released in Bb the morning after the due date for access by students. Total points for the assignment is 110. Note: There is no partial credit given; either the answer is correct or incorrect. Please place your answers in the Excel File provided by the Instructor. Question 1: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) (1.4658, 0.5630) Xdouble bar = 25.36/25 = 1.0144 Rbar = 19.56/25 = 0.7824; Sample size = 5 so A2 = 0.577 Upper limit = Xdouble bar+A2* Rbar = 1.0144+0.577*0.7824 = 1.4658 Lower limit = Xdouble barA2* Rbar = 1.01440.577*0.7824 = 0.5630 Question 2: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 25 subgroups of size 5. The sum of Xbar is 25.36 and the sum of R is 19.56. (2.5 points) (1.6548, 0.0000) Question 3: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) (2.2887, 1.2300) Question 4: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 30 subgroups of size 6. The sum of Xbar is 52.78 and the sum of R is 32.88. (2.5 points) (2.1964, 0.0000) Question 5: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an Xbar Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) (2.4329, 1.2241) Question 6: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for an R Chart that had 20 subgroups of size 5. The sum of Xbar is 36.57 and the sum of R is 20.95. (2.5 points) (2.2155, 0.0000) Question 7: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a pchart with data gathered from 30 subgroups of size 25 that had a total of 84 non conforming units. (2.5 points) (0.2381, 0.0000) Dr. Mike's MBA 6300 Homework #7 Page 1 Question 8: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 25 subgroups of size 30 that had a total of 102 non conforming units. (2.5 points) (0.3238, 0.0000) Question 9: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a pchart with data gathered from 20 subgroups of size 35 that had a total of 67 non conforming units. (2.5 points) (0.2449, 0.0000) Question 10: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 25 samples that had a total of 70 nonconforming units. (2.5 points) (7.8200, 0.0000) Question 11: Use the following data to calculate UCL and LCL (at the 99.7% confidence level) for a cchart with data gathered from 35 samples that had a total of 88 nonconforming units. (2.5 points) (7.2712, 0.0000) Question 12: Use the following data to calculate UCL and LCL (at the 95.5% confidence level) for a cchart with data gathered from 30 samples that had a total of 75 nonconforming units. (2.5 points) (5.6623, 0.0000) Scenario: A manufacturer of automobile glass employs a constant quality control technique where the thickness of glass is checked periodically by taking a sample of 5 units and measuring the thickness. The results of one shift's quality control inspections are shown in the table below. Sample 1 2 3 4 5 6 7 8 9 10 Thickness 4, 3, 4, 2, 4 5, 3, 5, 4, 2 3, 3, 3, 3, 4 4, 5, 5, 4, 5 1, 7, 6, 1, 1 4, 5, 2, 5, 4 3, 5, 4, 4, 5 2, 4, 4, 4, 3 5, 4, 3, 2, 5 4, 4, 4, 4, 4 Sample 11 12 13 14 15 16 17 18 19 20 Thickness 1, 6, 4, 4, 2 3, 3, 4, 5, 4 2, 7, 2, 7, 5 3, 2, 5, 4, 2 3, 3, 3, 2, 1 4, 4, 4, 5, 3 5, 3, 4, 4, 3 4, 4, 5, 3, 3 1, 4, 3, 3, 3 4, 4, 3, 5, 4 Question 13: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) 5.1414 Question 14: Using the data contained in the scenario calculate the Lower Control Limit for an Xbar chart that reflect a 99.7% confidence level. (2.5 points) 2.1987 Question 15: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) None Dr. Mike's MBA 6300 Homework #7 Page 2 Question 16: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) 5.3933 Question 17: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (2.5 points) 0.0000 Question 18: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) None Scenario: A canning company packages canned soup for a major soup manufacturer for distribution to regional wholesalers. The company processes 5,000 cans of soup each day using an automated packaging machine that is programmed to fill each can with 74.0 0.1 ounces net weight of soup. The company's quality assurance process consists of randomly selecting five cans from the production line each hour and carefully weighing them. Sample observations for a 24hour production run are reflected in the table below. Hour 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Sample 1 74.030 73.995 73.988 74.002 73.992 74.009 73.995 73.985 74.008 73.998 73.994 74.004 73.983 74.006 74.012 74.000 73.994 74.006 72.755 74.000 73.982 74.004 74.010 74.015 73.982 Sample 2 74.002 73.992 74.024 73.996 74.007 73.994 74.006 74.003 73.995 74.000 73.998 74.000 74.002 73.967 74.014 73.984 74.012 73.001 74.002 74.010 74.001 73.999 73.989 74.008 73.984 Sample 3 74.019 74.001 74.021 73.993 74.015 73.997 73.994 73.993 74.009 73.990 73.994 74.007 73.998 73.994 73.998 74.005 73.065 74.018 74.003 74.013 74.015 73.990 73.990 73.993 73.995 Sample 4 73.992 74.011 74.005 74.015 73.989 73.985 74.000 74.015 74.005 74.007 73.995 74.000 73.997 74.000 73.999 72.856 74.005 74.003 74.005 74.020 74.005 74.006 74.009 74.000 74.017 Dr. Mike's MBA 6300 Homework #7 Page 3 Sample 5 74.008 74.004 74.002 74.009 74.014 73.993 74.005 73.988 74.004 73.995 73.990 73.996 74.012 73.984 72.996 73.996 74.007 74.000 73.997 74.003 73.996 74.009 74.014 74.010 74.013 Question 19: Using the data contained in the scenario calculate the Upper Control Limit for an Xbar chart that reflect a 99.7% confidence level. (5 points) 74.0939 Question 20: Using the data contained in the scenario calculate the Lower Control Limits for an Xbar chart that reflect a 99.7% confidence level. (5 points) 73.8234 Question 21: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an Xbar chart, which samples are out of control? (5 points) Sample 15,16,17, 18 and 19 Question 22: Using the data contained in the scenario calculate the Upper Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) 0.4958 Question 23: Using the data contained in the scenario calculate the Lower Control Limit for an R chart that reflect 99.97% level of confidence. (5 points) 0.0000 Question 24: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for an R chart, which samples are out of control? (5 points) Sample 15, 16, 17, 18 and 19 Scenario: The manager of the customer service hotline for an internet service provider has been approached by the President of the company regarding a perceived increase in the number of customer complaints regarding the lack of timely technical assistance being provided by hotline technicians. In order to evaluate the validity of the President's concerns he decided to survey customers regarding their satisfaction with the timeliness of the technical assistance they received. Surveys were conducted during a thirtyday period with one hundred sixty (160) randomly selected customers participating in the survey each day. The number of customers surveyed who expressed dissatisfaction with the timeliness of the technical assistance they received is summarized in the following table. Day 1 2 3 4 5 6 7 8 9 10 11 No. Complaints 22 29 25 17 20 16 32 13 31 29 15 Day 16 17 18 19 20 21 22 23 24 25 26 Dr. Mike's MBA 6300 Homework #7 Page 4 No. Complaints 15 17 17 19 22 23 27 29 38 21 24 Day 12 13 14 15 No. Complaints 15 28 23 27 Day 27 28 29 30 No. Complaints 22 24 23 31 Question 25: Using the data contained in the scenario calculate the Upper Control Limit for the number of complaints that reflect a 99.7% confidence level. (5 points) 37.5625 Question 26: Using the data contained in the scenario calculate the Lower Control Limit for the number of complaints that reflect a 99.7%confidence level. (5 points) 8.7042 Question 27: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the number of complaints, which samples are out of control? (5 points) Sample 24 Question 28: Using the data contained in the scenario calculate the Upper Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) 0.2280 Question 29: Using the data contained in the scenario calculate the Lower Control Limit for the proportion of complaints that reflect 99.7% level of confidence. (5 points) 0.0612 Question 30: Using the data contained in the scenario and the calculated the Upper and Lower Control Limits for the proportion of complaints, which samples are out of control? (5 points) Sample 24 Dr. Mike's MBA 6300 Homework #7 Page 5 \f\f\f