Objective: Your boss wants to know the limits of expected variation for the DSST resolution times. Assuming that the process is normally distributed, you know you can calculate/predict the limits of expected variation by calculating the mean and standard deviation for the data and then using the properties of the normal distribution to estimate the limits of the expected variation. Instructions for you: 1. Calculate the average for each. 2. Calculate the standard deviation for each. 3. From these calculations, determine the range of expected variation. Assume the data are normally distributed. Data: Average Resolution Times for last month (measured in contiguous hours) 24 27 18 31 22 27 17 23 17 22 17 28 24 17 14 21 26 23 17 31 18 27 22 27 17 40 22 18 17 18 Use Excel 2003 to find mean and Use Excel 2007 to find mean and 28 YOU DO NOT NEED TO SUBMIT A HISTOGRAM FOR THIS DELIVERABLE Project: MAM IT 2016 Deliverable: Expected Variation Student last name: Mean: Standard deviation: What is the lowest point of expected variation? What is the upper point of expected variation? How do I determine if it's approximately normal? ROUND ALL FINAL RESULTS TO 6 DECIMAL PLACES. Read this! To send each assignment to your instructor: Click-and-hold the LEFT mouse button at the TOP-LEFT corner of the peach-colored box, then while holding down on that button, drag to the LOWER-RIGHT corner of the box. This will highlight the entire peach-colored box. Release the mouse button. Do a CTRL-C. This will copy what has been highlighted. Go to your Villanova website and follow this sequence: 1. COURSE MENU 2. CLASS ROSTER 3. Click on your instructor's email envelope icon 4. Type "Check My Work - Expected Variation" in the SUBJECT box. 5. Click once inside of the message box 6. Do a CTRL-V. This will paste your deliverable into this box. Don't be concerned if after you paste it, the appearance of the text is out of alignment. It will straighten out after you hit SEND. 7. SEND Check your SENT ITEMS folder afterward to see how it straightened out. Please 'hand-in' your assignments throughout the course. DO NOT SAVE THEM FOR THE END. e/predict the limits ata and then using Use Excel 2003 to find mean and Standard Deviation Use Excel 2007 to find mean and Standard Deviation Expected variation How do I determine if it's approximately normal? ROUND ALL FINAL RESULTS TO 6 DECIMAL PLACES. Objective: Earlier, you have made some progress as a result of the stem-and-leaf diagram. The team changed the process so that first-time requesters were processed ahead of the otherwise (first-in-first-out) process. This dramatically decreased the overall average response times. Many of the problems submitted by newer users were easier to resolve than the problems submitted by the more seasoned workers. The team also learned how to improve the process through the use of designed experiments. There were other improvements made through the use of other Six Sigma tools and techniques (aside from your project deliverables) and now the wait times are acceptable. Now, you want to ensure that they are staying that way and you want to practice "prevention" versus "detection." Part of your CONTROL strategy is to employ the use of an on-going capability study to ensure 'the plates are still spinning'--so-to-speak. And, the next deliverable will do that, but prior to performing a capability study, one must make sure the process is in statistical control. This is good, because the team decided to use a control chart as part of the CONTROL phase anyhow, so this will work out fine. In fact, let's do one now...just to make sure we are in statistical control. Instructions for you: Answer the questions and type those responses in the peach colored box below. Data: Average resolution times (in contiguous hours) in order of occurrence 1 10 2 17 Control Chart in Excel 2003 3 29 4 39 Control Chart Excel 2007 5 55 6 64 Help 7 28 8 6 "Don't I need special software?" 9 5 10 3 11 39 12 46 13 35 14 30 15 6 16 32 17 33 18 11 19 20 20 13 21 9 22 14 23 12 24 30 25 56 YOU DO NOT HAVE TO SUBMIT THE CONTROL CHART. JUST ANSWER THE QUESTIONS. Project: MAM IT 2016 Deliverable: XmR Chart Student last name: Upper control limit for the range: Upper control limit for the individuals: Lower control limit for the individuals: ROUND ALL RESULTS TO 6 DECIMAL PLACES. Is there adequate discrimination? Explain your answer: Which chart did you use and exactly how many strata are there on that chart? How many should there be? If the process is unstable, what process would you follow to determine what is causing the instability? and now the nd you want ing the instability? Objective: As mentioned in the last deliverable, one part of the CONTROL phase of DMAIC is to to use the control chart to control and monitor the process behavior. We use a capability study to determine how the process is performing in reference to the specifications, once we have a stable and predictable process as determined by the control chart. Assume that you addressed all of the assignable causes and the process is now stable. Your team decided to use a Pp/Ppk study. Reflected in the data below is last month's wait times under the new, stable process. You need to use this data in your Pp/Ppk study. You also need to construct a histogram as a part of your capability study to ensure that the process variation is still acting normal. By the way--finish this deliverable correctly and make all required corrections to the other assignments and you are finished with the project. Congratulations!!!! Instructions for you: Examine the capability of this process. Use Excel 2003 to find mean and Standard Deviation Use Excel 2007 to find mean and Standard Deviation Data: Data: Average resolution times (contiguous hours) 2 11 9 8 6 12 9 9 8 13 11 7 7 10 14 4 8 10 2 11 9 8 6 12 9 9 8 13 11 7 7 10 14 4 8 10 9 9 15 9 9 6 10 9 9 15 9 9 6 10 9 7 9 8 Upper spec is 30 hours How to submit an Assignment 5 YOU DO NOT NEED TO INCLUDE YOUR HISTOGRAM IN THIS ASSIGNMENT Project: Deliverable: Student last name: MAM IT 2016 Pp Ppk Your last name here Pp (round final result to 6 decimal places Ppk (round final result to 6 decimal place Is the process acceptable? What is the basis for your decision? Yes or No and Why HINT! once we have ou addressed r Pp/Ppk study. orrectly and make all Pp, Ppk formulas and Standard Deviation and Standard Deviation Objective: Your boss wants to know the limits of expected variation for the DSST resolution times. Assuming that the process is normally distributed, you know you can calculate/predict the limits of expected variation by calculating the mean and standard deviation for the data and then using the properties of the normal distribution to estimate the limits of the expected variation. Instructions for you: 1. Calculate the average for each. 2. Calculate the standard deviation for each. 3. From these calculations, determine the range of expected variation. Assume the data are normally distributed. Data: Average Resolution Times for last month (measured in contiguous hours) 24 27 18 31 22 27 17 23 17 22 17 28 24 17 14 21 26 23 17 31 18 27 22 27 17 40 22 18 17 18 Use Excel 2003 to find mean and Use Excel 2007 to find mean and 28 YOU DO NOT NEED TO SUBMIT A HISTOGRAM FOR THIS DELIVERABLE Project: MAM IT 2016 Deliverable: Expected Variation Student last name: Mean: Standard deviation: What is the lowest point of expected variation? What is the upper point of expected variation? How do I determine if it's approximately normal? ROUND ALL FINAL RESULTS TO 6 DECIMAL PLACES. Read this! To send each assignment to your instructor: Click-and-hold the LEFT mouse button at the TOP-LEFT corner of the peach-colored box, then while holding down on that button, drag to the LOWER-RIGHT corner of the box. This will highlight the entire peach-colored box. Release the mouse button. Do a CTRL-C. This will copy what has been highlighted. Go to your Villanova website and follow this sequence: 1. COURSE MENU 2. CLASS ROSTER 3. Click on your instructor's email envelope icon 4. Type "Check My Work - Expected Variation" in the SUBJECT box. 5. Click once inside of the message box 6. Do a CTRL-V. This will paste your deliverable into this box. Don't be concerned if after you paste it, the appearance of the text is out of alignment. It will straighten out after you hit SEND. 7. SEND Check your SENT ITEMS folder afterward to see how it straightened out. Please 'hand-in' your assignments throughout the course. DO NOT SAVE THEM FOR THE END. e/predict the limits ata and then using Use Excel 2003 to find mean and Standard Deviation Use Excel 2007 to find mean and Standard Deviation Expected variation How do I determine if it's approximately normal? ROUND ALL FINAL RESULTS TO 6 DECIMAL PLACES. Objective: You recommend using a design of experiments approach to hopefully realize a breakthrough improvement. The team brainstorms a long list of possible reasons why the average resolution time is so long. From that list, the team has reduced it down to five factors they want to include in an experiment. They do not suspect any interactions, so they conclude a resolution III will be adequate. They refer to the resolution matrix (in Analyzing Fractional Factorial Designs lecture and the online textbook) and they find they can learn about the effects of those five factors in as little as eight experiments. Instructions for you: Estimate the main effects (the impact on the response from when going from the low level to the high level). Data: The factors for the experiment were: A B C D E Staff size Order of responding Method of responding Tracking software Operating system - level + level 8 FIFO In person Product A BHD 16 By priority Via web Product B JK-7 The design below was taken from Minitab. There are other software packages that provide the same information. There can also be found in Design of Experiments textbooks. Trial 1 2 3 4 5 6 7 8 Staff sz 1 -1 1 -1 -1 1 1 -1 Order 1 -1 1 -1 1 -1 -1 1 Method -1 -1 1 1 1 -1 1 -1 How to submit an Assignment YOU DO NOT NEED TO SEND IN THE MAIN EFFECTS PLOTS MAM IT 2016 Project: Deliverable: DOE Jeppesen Student last name: Software -1 1 1 1 -1 1 -1 -1 Op sys -1 1 -1 -1 1 1 -1 1 Results (Y) (average resolut 9 7 25 28 26 8 28 6 Staff size Staff size + Order Order + Method Method + Software Software + Op sys Op sys + Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here Actual value here ROUND YOUR FINAL RESULTS TO 2 DECIMAL PLACES. Which two factors are most significant and what are the optimum settings for these two factors? Read this! To send each assignment to your instructor: Click-and-hold the LEFT mouse button at the TOP-LEFT corner of the peach-colored box, then while holding down on that button, drag to the LOWER-RIGHT corner of the box. This will highlight the entire peach-colored box. Release the mouse button. Do a CTRL-C. This will copy what has been highlighted. Go to your Villanova website and follow this sequence: 1. COURSE MENU 2. CLASS ROSTER 3. Click on your instructor's email envelope icon 4. Type "Check My Work - DOE" in the SUBJECT box. 5. Click once inside of the message box 6. Do a CTRL-V. This will paste your deliverable into this box. Don't be concerned if after you paste it, the appearance of the text is out of alignment. It will straighten out after you hit SEND. 7. SEND Check your SENT ITEMS folder afterward to see how it straightened out. Please 'hand-in' your assignments throughout the course. DO NOT SAVE THEM FOR THE END. ution time is adequate. that provide the sults (Y) (average resolution - in contiguous hours Excel 2003 Tip Excel 2007 Tip Check