Objective: So far, so good. The process has been in control for the past four months. Phyllis isn't as well versed in Six Sigma as the team is, and it is her nature to question everything. So she has asked for a capability study to be performed on two key process factors that affect leveler thickness and wants to see this for the past 35 days of production. You are on the spot, but confident. You pull up the past 35 day's worth of data and you calculate Pp and Ppk for each of these factors. Is Phyllis going to be happy or is she going to be more skeptical? That is the 'question of the day.' Crunch the numbers--and you will find out. By the way--finish this deliverable correctly AND MAKE ALL OF THE CORRECTIONS REQUIRED ON THE PREVIOUS ASSIGNMENTS and you are finished with the project! Congratulations!!! Instructions for you: "Is it possible for me to do a selfcheck?" Instructions for you: 1. Construct histograms for each of the parameters. Note: The first parameter 'thickness' is the product parameter. The second parameter is thought to affect thickness. 2. Are the processes approximately normally distributed? 3. Calculate Pp and Ppk for each. Note: The upper and lower specifications are listed at the bottom of each column. You will need these to do the calculations. 4. Are the processes acceptable? "I'm lost" "Can I do this with the Data Analysis Toolpak in Excel 2003?" "Can I do this with the Data Analysis Toolpak in Excel 2007?" Data: Data: Thicknes s 0.548 0.550 0.552 0.554 0.552 0.547 0.547 0.552 0.549 0.548 0.549 0.549 0.550 0.551 0.549 0.550 0.551 0.550 0.550 0.553 0.548 0.552 0.551 0.550 0.549 0.551 0.551 0.550 0.551 0.550 0.549 0.550 0.551 0.549 0.550 Thicknes s Upper Spe 0.5600 Lower Spe 0.5400 R.P.M. 4400 4400 4400 4400 4450 4450 4450 4450 4450 4450 4450 4450 4450 4500 4500 4500 4550 4600 4650 4650 4650 4700 4700 4700 4700 4700 4700 4700 4700 4700 4700 4750 4750 4750 4800 R.P.M. 8000 2000 How to submit an Assignment Target Assignment Date - Submit in Week 14 or earlier YOU DO NOT NEED TO CREATE CONTROL CHARTS TO COMPLETE THIS ASSIGNMENT!! DO NOT SEND THE ACTUAL HISTOGRAMS UNLESS YOUR INSTRUCTOR ASKS YOU TO. Project: Manufacturing 2015 Deliverable: Pp Ppk Your LAST name here Student last name: INSTRUCTIONS: (1) IF YOU SAY THE DISTRIBUTION IS NOT APPROXIMATELY NORMAL, GIVE THE CORRECT NAME FOR THE PATTERN YOU SEE IN YOUR HISTOGRAM. (2) BASE YOUR DECISION ON ACCEPTABILITY ON THE ASSUMPTIONS AND CRITERIA FOR Pp and Ppk DISCUSSED IN THE RECORDED LECTURES AND VIRTUAL CLASSES ON CAPABILITY. YOU DO NOT NEED TO CREATE CONTROL CHARTS FOR THIS ASSIGNMENT!! ThicknessPp (use 6 decimal places) Ppk (use 6 decimal places) Is this distribution approximately Normal Yes or No If it's not normal, what is the shape? Yes or No Is this process acceptable? Explain your decision on acceptability. Check HINT! HINT! HINT! Round your Pp and Ppk results to 6 decimal places. R.P.M. Pp (use 6 decimal places) Ppk (use 6 decimal places) Is this distribution approximately Normal Yes or No If it's not normal, what is the shape? Yes or No Is this process acceptable? Explain your decision on acceptability. 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 - Pp, Ppk" 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. Procrastinators: The deadline for having all project deliverables 100% correct is 7 days prior to the end of the course. Check HINT! HINT! HINT! v4.1a (1-17-02) Labels Enter/Paste Your Data In The Columns STEP #2 Enter Upper/Lower Spec. Limits USL LSL 0.5600 Temp 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 115 140 Press 145 146 146 147 148 148 148 149 149 149 150 150 150 150 150 150 150 150 151 151 151 151 151 153 149 152 148 147 150 151 151 151 152 152 154 160 1300 1400 1500 1500 1500 1500 1500 1400 1800 1600 1600 1600 1600 1600 1600 1600 1600 1600 1600 1800 1800 1400 1400 1700 1700 1700 1700 1700 1700 1700 1800 1800 1900 1900 1900 2600 0.125 dim. 0.121 0.122 0.122 0.123 0.123 0.124 0.124 0.124 0.125 0.125 0.125 0.125 0.125 0.128 0.128 0.125 0.129 0.126 0.126 0.126 0.126 0.126 0.126 0.126 0.127 0.127 0.127 0.127 0.127 0.127 0.127 0.128 0.128 0.129 0.130 0.23 dim. 0.229 0.230 0.230 0.231 0.231 0.231 0.231 0.231 0.231 0.231 0.231 0.231 0.230 0.230 0.234 0.233 0.235 0.229 0.234 0.232 0.232 0.232 0.232 0.232 0.232 0.232 0.232 0.232 0.233 0.233 0.233 0.233 0.234 0.234 0.235 R.P.M. Data 9 HB 4400 4400 4400 4400 4450 4450 4450 4450 4450 4450 4450 4450 4450 4500 4500 4500 4550 4600 4650 4650 4650 4700 4700 4700 4700 4700 4700 4700 4700 4700 4700 4750 4750 4750 4800 8000 Data 10 Data 11 Data 12 Data 13 Data 14 Data 15 Data 16 Data 17 Data 18 Data 19 Data 20 400 402 404 404 406 406 406 408 408 408 410 410 410 410 410 411 410 410 409 409 410 412 412 412 412 412 412 412 412 414 414 414 414 416 418 0.1350 0.2400 0.5400 0.55400 0.54700 100 115.00000 115.00000 140 154.00000 145.00000 900 1900.00000 1300.00000 0.1150 0.13000 0.12100 0.2200 0.23500 0.22900 2000 4800.00000 4400.00000 300 418.00000 400.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.55009 0.00700 115.00000 0.00000 149.71429 9.00000 1628.57143 600.00000 0.12583 0.00900 0.23189 0.00600 4580.00000 400.00000 409.91429 18.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 #DIV/0! 0.00000 Std. Dev. 0.00161 0.00000 0.93263 94.80440 0.00086 0.00118 21.98224 0.99771 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 Max. Min. Aver. Range 500 Cp 2.07 #DIV/0! 3.57 2.99 3.86 2.84 45.49 33.41 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cpk 2.05 #DIV/0! 3.47 2.56 3.54 2.30 39.12 30.10 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Std. Dev. 0.00158 0.00000 2.00839 154.48478 0.00209 0.00155 132.39868 3.81461 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Pp 2.11 #DIV/0! 8.74 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! (within) Long-Term Statistics Time 0.548 0.550 0.552 0.554 0.552 0.547 0.547 0.552 0.549 0.548 0.549 0.549 0.550 0.551 0.549 0.550 0.551 0.550 0.550 0.553 0.548 0.552 0.551 0.550 0.549 0.551 0.551 0.550 0.551 0.550 0.549 0.550 0.551 0.549 0.550 STEP #1 Short-Term Statistics Thickness (overall) 1.66 1.83 1.59 2.15 7.55 Ppk STEP #3 2.09 #DIV/0! 1.61 1.57 1.46 1.75 6.50 7.87 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Yield 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! (optional) Choose Sample Sub-Group Sizes. If Unsure... Leave At Default Value "1". Changing Sub-Groups Sizes Only Affects "Short-Term" Statistics www.statisticalsolutions.net Thi ck ness 12 Ti m e 40 35 10 30 8 25 20 6 15 4 10 2 5 0 0 Tem p 12 Pr ess 14 12 10 10 8 8 6 6 4 4 2 2 0 0 0.125 di m . 16 14 12 10 8 6 4 2 0 0.23 di m . 20 R.P .M. 35 18 30 16 25 14 12 20 10 15 8 10 6 4 5 2 0 0 HB 30 Data 9 1 1 25 1 20 1 1 15 1 0 10 0 5 0 0 0 0 Data 10 1 1 1 1 1 1 0 0 0 0 0 Data 11 Data 12 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 Data 13 Data 14 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 Data 15 1 1 1 1 1 1 0 0 0 0 0 Data 16 Data 17 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 Data 18 Data 19 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 Data 20 1 1 1 1 1 1 0 0 0 0 0 Statistics Calculations corruption of the sensitive formula's that are built-in. Protection If necessary, protection can be disabled. DATA ENTRY Short-term statistics account for "TIME". Data should be entered into columns in the order of manufacture sequence. If the data is not entered in this fashion the "short-term" statistics may not be valid. SHORT-TERM FORMULA'S The formula's used to calculate the short-term standard deviations are consistent with most retail statistical software packages and are as follows: Email for questions and bugs www.statisticalsolutions.net LONG-TERM FORMULA Standard Deviation S= c4 and d2 are derived from Table "J" found in most statistical textbooks. Objective: So far, so good. The process has been in control for the past four months. Phyllis isn't as well versed in Six Sigma as the team is, and it is her nature to question everything. So she has asked for a capability study to be performed on two key process factors that affect leveler thickness and wants to see this for the past 35 days of production. You are on the spot, but confident. You pull up the past 35 day's worth of data and you calculate Pp and Ppk for each of these factors. Is Phyllis going to be happy or is she going to be more skeptical? That is the 'question of the day.' Crunch the numbers--and you will find out. By the way--finish this deliverable correctly AND MAKE ALL OF THE CORRECTIONS REQUIRED ON THE PREVIOUS ASSIGNMENTS and you are finished with the project! Congratulations!!! Instructions for you: "Is it possible for me to do a selfcheck?" Instructions for you: 1. Construct histograms for each of the parameters. Note: The first parameter 'thickness' is the product parameter. The second parameter is thought to affect thickness. 2. Are the processes approximately normally distributed? 3. Calculate Pp and Ppk for each. Note: The upper and lower specifications are listed at the bottom of each column. You will need these to do the calculations. 4. Are the processes acceptable? "I'm lost" "Can I do this with the Data Analysis Toolpak in Excel 2003?" "Can I do this with the Data Analysis Toolpak in Excel 2007?" Data: Data: Thickness R.P.M. 0.548 4400 0.550 4400 0.552 4400 0.554 4400 0.552 4450 0.547 4450 0.547 4450 0.552 4450 0.549 4450 0.548 4450 0.549 4450 0.549 4450 0.550 4450 0.551 4500 0.549 4500 0.550 4500 0.551 4550 0.550 4600 0.550 4650 0.553 4650 0.548 4650 0.552 4700 0.551 4700 0.550 4700 0.549 4700 0.551 4700 0.551 4700 0.550 4700 0.551 4700 0.550 4700 0.549 4700 0.550 4750 0.551 4750 0.549 4750 0.550 4800 4 9 4400 4450 2 3 0.547 0.55 19.253 160300.000 0.0015560284 0.550 4580.000 Thickness R.P.M. Upper Specs 0.5600 8000 Lower Specs 0.5400 2000 How to submit an Assignment 130.494 3 1 1 3 10 3 1 4500 4550 4600 4650 4700 4750 4800 7 9 6 4 1 1 0.549 0.55 0.55 0.55 0.55 0.55 Target Assignment Date - Submit in Week 14 or earlier YOU DO NOT NEED TO CREATE CONTROL CHARTS TO COMPLETE THIS ASSIGNMENT!! DO NOT SEND THE ACTUAL HISTOGRAMS UNLESS YOUR INSTRUCTOR ASKS YOU TO. Project: Manufacturing 2015 Deliverable: Pp Ppk YEISER Student last name: INSTRUCTIONS: (1) IF YOU SAY THE DISTRIBUTION IS NOT APPROXIMATELY NORMAL, GIVE THE CORRECT NAME FOR THE PATTERN YOU SEE IN YOUR HISTOGRAM. (2) BASE YOUR DECISION ON ACCEPTABILITY ON THE ASSUMPTIONS AND CRITERIA FOR Pp and Ppk DISCUSSED IN THE RECORDED LECTURES AND VIRTUAL CLASSES ON CAPABILITY. YOU DO NOT NEED TO CREATE CONTROL CHARTS FOR THIS ASSIGNMENT!! Thickness Pp (use 6 decimal places) Ppk (use 6 decimal places) 2.141860 2.142207 YES Is this distribution approximately Normal? Bimodal If it's not normal, what is the shape? YES Is this process acceptable? Explain your decision on acceptability. Check HINT! HINT! It is acceptable because it meets the criteria of normally distributed and is above 1.5 HINT! 7.663188 Check Round your Pp and Ppk results to 6 decimal places. R.P.M. Pp (use 6 decimal places) Ppk (use 6 decimal places) 6.590341 NO Is this distribution approximately Normal? If it's not normal, what is the shape? HINT! Yes Is this process acceptable? Explain your decision on acceptability. Although the histogram is not HINT! normally distributed, all of the responses are well within limits / acceptable levels. 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 - Pp, Ppk" 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. Procrastinators: The deadline for having all project deliverables 100% correct is 7 days prior to the end of the course. HINT