Description of this paper

stats problems with solution fall 2014

Description

solution


Question

Question;InstructionsYou need to understand how to send your assignments (deliverables) to your instructor. The tabs (bottom of each sheet) in this document contain all of the deliverables expected of you.If you need help along the way, look for these special cells that have a red indicator Read mein the corner. It looks like the "Read me" box to the right:Simply slide your cursor over the red-cornered cell and you will get more information.The format for all of the deliverables is the same:The 'assignment objective' is in black font.The next segment is in green font. These are your instructions for that assignment.The blue font is the data (where applicable) for completing each the assignment.SoftwareWe are using Excel software for the projects. You may use other software to complete your projects, but please 'report' your answers in the Excel format described below.You may complete your assignments with any version of Excel software.All assignments can easily be completed with a basic copy of Excel.There is also an Add-In feature which is available for Excel that can be helpful, although it is not required. The Add-In feature comes free with each Excel package, although it may not be currently loaded into your copy.Following are the simple instruction for loading the Excel Add-ins for both Excel 2003 and Excel 2007. (Slide your cursor over the red-cornered cells to read)Excel 2003Excel 2007Excel Novice - Please readProject TimelineDeliverables include:Project charter (target week 3 or sooner)Baseline sigma (week 4 or sooner)Histogram (week 5 or sooner)Expected variation (week 6 or sooner)t test (week 7 or sooner)Chi square (week 9 or sooner)ANOVA (week 11 or sooner)DOE (week 12 or sooner)Scatter diagram (week 13 or sooner)Control chart (XmR) (14 or sooner)Pp Ppk (week 15 or sooner)How to submit an AssignmentIn response to customers like you, we have added a peach-colored box for each deliverable. We have done this to make it clear (and consistent) the areas of the project that will be reviewed to your instructor.Project:Deliverable:Student last name:Manufacturing ProjectImprove phase - gen. sol.JohnsonWhat is the control chart telling you?There is a point out of control atsubgroup #15. I would try to figureout why that happened. We wouldalso recalculate the control limitsbecause there is evidence theprocess has changed.ofExample bleara deliveWhat is the average of subgroup 1?What is the average of subgroup 2?What is the average of subgroup 3?What is the average of subgroup 4?What is the average of subgroup 5?What is the average of subgroup 6?What is the average of subgroup 7?What is the average of subgroup 8?2234232225232927Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COMMUNICATE2. CLASS ROSTER3. Click on your instructor's email envelope icon4. Type "Check My Work - Specific assignment" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.Read this!This spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your Excel software.If you see Data Analysis already listed under the Tools tab, you are set. If you do not see Data Analysisfollow the instructions in the Green tab.Excel 2003 instructionsExcel 2003 or earlier versions of Excel exampleThis spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your 2007 Excel software.If you see Data Analysis already listed under the DATA tab, you are set. If you do not see Data Analysisfollow the instructions in the Green tab.Excel 2007 instructionsExcel 2007 exampleManufacturing ProjectLovell Levelers, Inc. is a major provider of specialized partsfor the automotive industry. LLIs biggest customer, Specific Motorswas not a delighted customer this month. In fact, lastMonday, the executive vice president of Specific Motors headquarters,Phyllis Kendall was diverted from a return trip from Singaporeto drop in unexpectedly at the LLI plant. There was nothingroutine about this visit. She made it explicitly clear thatSpecific Motors was disappointed with the level of quality relativeto the leveler plates. In particular, she was disappointed with thecurrent average of rejects at the rate of 1,350 defects per millionopportunities (DPMO), and at LLI's cost of poor quality of just over $256,000per quarter. She said the industry standard is <50 DPMO andif we do not get the level of quality to the industry standard (as aminimum) within the next six months, LLI should not expectto keep the business next year.The student will be a Black Belt working for LLI. The specifics about their company:CEOBill LovellGMMary NicholsSponsorJohn HoppsFinanceCindy JenkinsProcess ownerLeroy MillerMaster BBDennis KensManufacturingMitch FreeseDesign EngineerAl NelsonQualityDebbie JudsonThe deadline for completing all project deliverables is 7 days prior to the end of the courseObjective:The Black Belt team did a pareto analysis of the data and determined that three factors were causingover 95% of the problem with the leveler plates. Those factors are,the length of the plates, the width of the plates, and the thickness of the plates.You need to know if the data from these three 'product parameters' are normally distributed.Instructions for you:1. Construct three (3) histograms for the three data sets.2. Interpret each of the histograms to determine whether the variables are random or normallydistributed.Data:Length10.6710.7410.6810.7210.6610.6910.7010.7210.6910.6810.7210.7010.7010.7310.7510.7310.6910.6810.7010.7710.7210.6910.6610.6910.6310.6810.7310.7410.6510.6910.7010.7210.7510.7110.72Upper SpecLower SpecTargetWidth1110.510.757.667.457.557.517.577.557.537.537.567.527.587.557.537.567.587.557.557.547.577.547.557.557.567.547.567.567.557.547.557.567.577.547.557.547.557.537.547.55Thickness0.5510.5460.5460.5540.5460.5420.5450.5380.5520.5470.5460.5450.5460.5480.5460.5430.5480.5450.5530.5390.5490.5410.5430.5450.5490.5460.5450.5400.5410.5450.5470.5430.5450.5460.547Histograms in Excel 2003Histograms in Excel 2007More on Bin Ranges0.560.540.55How to submit an AssignmentTarget Assignment Date - Submit in Week 5 or earlierYOU DO NOT NEED TO SEND THE ACTUAL HISTOGRAMSProject:ManufacturingDeliverable:HistogramStudent last name:MerriweatherIs 'length' normally distributed?Is 'width' normally distributed?Is 'thickness' normally distributed?YesYesNoYOU DO NOT NEED TO SEND THE ACTUAL HISTOGRAMSTo send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COMMUNICATE2. CLASS ROSTER3. Click on your instructor's email envelope icon4. Type "Check My Work - HISTOGRAM" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.Objective:Although many things have been learned to this point and we have made progress, but we are not quite there.Earlier in the project the team determined that thickness was the main problem relating to the high leveldefects in the leveler plates. The analysis has been completed. Now, we want to IMPROVE the process.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 thickness is not capable. From that list, theteam has reduced it down to five factors they want to include in an experiment. They suspectinteractions, so they conclude a full factorial will be required. They refer to the resolution matrix (found in yourreading materials and in the Fractional Factorial Designs Lecture) and they find they canlearn about the effects of those five factors in 32 experiments.The factors for the experiment were Depth, Temp, Pressure, R.P.M. and Time.Instructions for you:From the factorial experiment (below) calculate the interactions to determine confounding.1. Fill in the interaction columns. (shaded in peach color) You will need to dothis to answer #1 in the peach-colored area below.2. Is the design below a resolution III, IV, V or Full Factorial (no resolution)?3. The design below is a design that an consultant is recommending. Unfortunately, you learn some bad news.Your management has set your budget only allowing for 8 runs because the trials cost $600 a piece.The team has determined it cannot live with main factors being confounded with other main factors or withtwo-factor interactions.What would you recommend? Big Hint: One of the factors MAYbe dropped from the study - for economic reasons. (please provideyour answer in the peach-colored area below) You do not have to determine which factor to drop.4. Using the resolution matrix found in your online textbook,what resolution would your recommendation be?5. Based on your new recommendation, what are you giving up? Explain (briefly in the peach area)"I'm lost"Data:FactorDepthTempPressureR.P.M.Time(-)85140850440030(+)1501552500480045I try to enter + or - and it does not work.Trial1234567891011121314151617181920212223242526272829303132Factor Factor Factor Factor Factor A X B A X C A X D A X E B X C B X D B X E C X D C X E D X ECABDE++++Entering ++or - does++not workHow to submit an AssignmentTarget Assignment Date - Submit in Week 12 or earlierYOU DO NOT NEED TO SUBMIT THE DESIGNED EXPERIMENTProject:ManufacturingDeliverable:DOE Design ChoiceStudent last name:Merriweather1. What is the sign (+ or -) for the AxC interaction for the 4th trial?2. What is the resolution as shown above? (III, IV, or V, or Full):::"I'm lost"III3. What is your recommendation?Your recommendation here4. What would the new resolution be? (III, IV, or V):::5. What would you be giving up?What confounding will you see?VPlease describe what you would be giving up basedupon your recommendation.YOU DO NOT NEED TO SUBMIT THE DESIGNED EXPERIMENTTo send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COMMUNICATE2. CLASS ROSTER3. Click on your instructor's email envelope icon4. Type "Check My Work - DOE" in the SUBJECT box.5. Click once inside of the message box6. 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 ofalignment. 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 completing all project deliverablesis 7 days prior to the end of the course.

 

Paper#61309 | Written in 18-Jul-2015

Price : $35
SiteLock