AutoSave On LSSBB Healthcare Project (t-test) - Saved . Search sebastian alt SA X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert LO Arial 10 AA . = ab Wrap Text Number Ex AY O Delete ~ Paste BIU~ E GEE Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Ideas Sensitivity Formatting Table Styles ~ Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity L82 X V A B C D E F H J K L M N 0 P Q R S T U V W 29 Average wait times (in minutes) in order of occurrence 10 17 1a. Calculate R-bar Calculating R-bar in Excel 2003 or earlier 29 Calculating R-bar in Excel 2007 or later 39 Self check 55 64 1b. Calculate the 28 upper control limit for the range "How do I do that?" Self Check 2 & 3. Calculate the control limits for the individuals "How do I do that?" Self check Ba eurs to ravious the umake 14 virtual class for more information on CDC and mazeur mont discrimination hafora you submit thiel . .. Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) Ready + 80% 77'F Sunny ADD (x 12:37 PM Type here to search O m W 12/11/2021AutoSave On LSSBB Healthcare Project (t-test) - Saved . Search sebastian alt SA X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert LO Arial 10 AA . = ab Wrap Text Number Ex AY O Delete * Paste E CE Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Ideas Sensitivity BIU~ Formatting Table Styles Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity L82 X V A B C D E F G H J K L M N O P Q R 1 Objective: 2 The team changed the process so that returning patients were processed ahead of the first-time patients. 3 This dramatically decreased the overall wait times because the returning patients were already in the system. The team also learned how to improve the process through the use of designed experiments. There were other improvements made through the 6 use of other Six Sigma tools and techniques (aside from your project deliverables) and now the 7 wait times are acceptable. Now, you want to ensure that they are staying that way and you want 8 to practice "prevention" versus "detection." Part of your CONTROL strategy is to employ 9 the use of an on-going capability study to ensure 'the plates are still spinning'--so-to-speak. 10 And, the next deliverable will do that, but prior to performing a capability study, one 11 must make sure the process is in statistical control. This is good, because the team 12 decided to use a control chart as part of the CONTROL phase anyhow, so this will 13 work out fine. In fact, let's do one now...just to make sure we are in statistical control. 14 15 Instructions for you: 16 Using the data below, create an XmR chart for average resolution times. Use the chart to 17 answer the following questions and type those responses in the peach colored box below. 18 19 1. What is the upper control limit for the range? Control Charts in Excel 2003 or earlier 20 2. What is the upper control limit for the individuals? Control Charts in Excel 2007 or later 21 3. What is the lower control limit for the individuals? Help 22 4. What would you do with the process? 23 a. What would you recommend? 24 b. Is the measurement system discriminate? "I have no idea about this one" 25 c. Is resolution time in statistical control? "I have no idea about this one' 26 Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) (+ Ready + 100% 12:39 PM Type here to search O W 77'F Sunny ADD (x 12/11/2021AutoSave On LSSBB Healthcare Project (t-test) - Saved . Search sebastian alt SA X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert LO Arial 10 AA . = ab Wrap Text Number Ex AY O Delete ~ Paste E CEE Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Ideas Sensitivity BIU~ Formatting Table Styles Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity 182 X V A B C D E F G H J K L M N O P 1 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 6 all of the assignable causes and the process is now stable. 7 8 Your team decided to use a Pp/Ppk study. Reflected in the data below is last 9 month's wait times under the new, stable process. You need to use this data in your Pp/Ppk study. 10 You also need to construct a histogram as a part of your capability study to ensure 11 that the process variation is still acting normal. By the way--finish this deliverable correctly and make all 12 required corrections to the other assignments and you are finished with the project. 13 Congratulations! 14 15 Instructions for you: 16 1. Construct a histogram from the data below. 17 2. Is the processes random, or normally distributed? Histograms in Excel 2003 or earlier 18 3. Calculate Pp and Ppk. Note: The upper and lower specifications 19 are listed below the data. You will need these to do Histograms in Excel 2007 or later 20 the calculations. 21 4. Are the processes acceptable? More on Bin Ranges 22 23 "I'm lost" Pp, Ppk formulas 24 25 Use Excel 2003 or earlier to find mean and Standard Deviation Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) (+ Ready + 100% 12:39 PM Type here to search O W 77'F Sunny ADD (x 12/11/2021LSSBB Healthcare Project (t-test) - Saved . sebastian alt SA X AutoSave On Search Help Share Comments File Home Insert Page Layout Formulas Data Review View Insert X Ex AY O Arial 10 ~ A A . = ab Wrap Text Number LO Delete ~ Conditional Format as Cell Sort & Find & Ideas Sensitivity Paste BIU ~ E GEE Merge & Center $ ~ % " Formatting Table Styles ~ [Format Filter * Select v Styles Cells Editing Ideas Sensitivity Clipboard Font Alignment Number 182 X V P Q R T U W X Y Z AA B AC AD AE Al E C D E F G H K L M 29 Data: 30 Average Talk times Data: [contiguous 2 33 34 35 36 37 38 39 40 41 42 43 58 59 60 61 62 63 Upper Specification Limit 30 Minutes 64 Lower Specification Limit None Minutes 65 Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) (+ D + 60% Ready 12:40 PM 77'F Sunny ~ 90 0 / (x. Type here to search O W 12/11/2021AutoSave On LSSBB Healthcare Project (t-test) - Saved . Search sebastian alt SA X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert LO Arial 10 ~ A A . = ab Wrap Text Number Ex AY O Delete ~ Paste BIU ~ E CEE Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Ideas Sensitivity Formatting Table Styles Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity 182 X V A C D E F H J K L M N 0 P R S 62 63 Upper Specification Limit 30 Minutes 64 Lower Specification Limit None Minutes 65 66 67 TARGET ASSIGNMENT DATE - Submit in Week 15 or earlier 68 69 YOU DO NOT NEED TO INCLUDE YOUR HISTOGRAM IN THIS ASSIGNMENT 70 Project Healthcare 71 Deliverable: Pp Ppk 72 Student last name: Alt 73 74 Pp (round final result to 6 decimal places): 1.818000 HINT! 75 Ppk (round final result to 6 decimal places): 1.062500 Check 76 77 Is the process reasonably normally distributed? yes 78 79 Is the process acceptable? What is | No. Although the Pp has an acceptable HINT! 80 the basis for your decision? index, the Ppk has an insufficient one. It 81 would be much better if both indexes 82 83 84 DO NOT SEND ANY EXTRA ATTACHMENTS UNLESS YOUR INSTRUCTOR SPECIFICALLY ASKS YOU TO! 85 86 Please 'hand-in' your assignments throughout the course. 87 DO NOT SAVE THEM FOR THE END 88 The deadline for having all project deliverables 100% correct 89 is 7 days prior to the end of the course. Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) + Ready + 90% 12:40 PM Type here to search O W 77'F Sunny ADD(x 12/11/2021AutoSave on LSSBB Healthcare Project (t-test) - Saved . Search sebastian alt SA X File Home Insert Page Layout Formulas Data Review View Help Share Comments X Insert LO Arial 10 AA . = ab Wrap Text Number Ex AY O Delete * Paste BIU ~ E CEE Merge & Center $ ~ % " Conditional Format as Cell Sort & Find & Ideas Sensitivity Formatting Table Styles Format Filter * Select v Clipboard Font Alignment Number Styles Cells Editing Ideas Sensitivity L82 X V A B C D E F G H K M N 0 P Q R 60 61 Be sure to review the week 11 virtual class for more information on SPC and measurement discrimination before you submit this! 62 63 TARGET ASSIGNMENT DATE - Submit in Week 14 or earlier 64 65 YOU DO NOT HAVE TO SUBMIT THE CONTROL CHART. JUST ANSWER THE QUESTIONS. 66 Project: Healthcare 67 Deliverable: XmR Chart 68 Student last name: Alt 69 70 Upper control limit for the range: 44.913546 Help 71 Upper control limit for the individuals: ROUND ALL RESULTS Check 64.941264 Help Check 0 6 DECIMAL PLACES. 72 Lower control limit for the individuals: 0.000000 Check 73 74 Is there adequate discrimination? Explain your answer: Which chart 75 did you use and exactly how many strata are there on that chart? System is discriminate. There are 23 points Help Check 76 How many should there be? under the UCL which is greater than the required 6. 4 strat. XmR Chart. 17 78 Is the process stable or unstable? 79 If the process is unstable, what process would you follow to determine what is causing the instability? 80 HINT 81 Stable. But if unstable we need to identify the points or sample due to which the process 82 became unstable. 83 84 85 . . . Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) Control (XmR Chart) Control (Pp Ppk) + Ready + 100% 12:35 PM Type here to search O W 77'F Sunny ^ DOD (x . 12/11/2021LSSBB Healthcare Project (t-test) - Saved . sebastian alt SA X AutoSave On Search Share Comments File Home Insert Page Layout Formulas Data Review View Help Insert X Ex AY O Arial 10 AA . = Number LO ab Wrap Text Delete ~ Sort & Find & Ideas Sensitivity Paste BIU ~ E GEE Merge & Center $ ~ % " Conditional Format as Cell Formatting Table Styles ~ Format Filter * Select v Number Styles Cells Editing Ideas Sensitivity Clipboard Font Alignment J44 X V D E F G H J K L M N O P Q R S A A B C Leave Number in for without treatment per specific treatment day 14 incidents 15 172 4 Scatter diagrams in Excel 2003 or earlier 16 132 6 17 130 2 Scatter diagrams in Excel 2007 or later 18 206 4 19 199 6 Correlation Coefficient - Excel 2003 or earlie 20 223 4 21 201 8 Correlation Coefficient - Excel 2007 or later 22 169 7 23 135 24 200 25 189 26 110 27 203 28 189 29 224 30 197 4 Chart Title 31 188 8 32 125 33 199 CO N 34 194 35 207 36 Measure (Baseline Sigma) Analyze (Pareto Chart) Analyze (Expected Variation) Analyze (T Test) Improve (Scatter Diagram) Improve (DOE) . . . (+ . .. + 100% Ready 12:23 PM Type here to search O 77'F Sunny ~ 9 0 0 / (). 12/13/2021