Attachment # 00001972 - homework.xlsx
homework.xlsx (26 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
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 can learn 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 do "I'm lost" this to answer #1 in the peach-colored area below.2. Is the initial design below a resolution III, IV, V or Full Factorial (no resolution)? 3. The initial 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. Big Hint: One of the factors MAY be dropped from the study for economic reasons. What specific experimental design would you recommend? (You do not need to decide which factor to drop at this point.)4. Using the resolution matrix found in your online textbook, what is the resolution for the design you're recommending?5. Based on your new recommendation, what will the confounding pattern be in your results?Data:Factor (-)(+)ADepthBTempCPressureDR.P.M.ETime I try to enter + or - and it does not work.A X BA X CA X DA X EB X CB X DB X EC X DC X E D X ETrial-+Entering + or - does not work1. 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)3. Given the teams goals and budget, what is your recommendation for the final design of this experiment? BE SPECIFIC AND USE THE CORRECT DESIGN NOTATION AND/OR TERMINOLOGY!!Type your SPECIFIC recommendation here and use the correct notation for the design you recommend.4. What would the new resolution be under your recommendation in #3 above? (III, IV, or V) :::5. What will the generic confounding pattern be for your final design? (NOT the design generators or alias sets!)Describe the GENERIC confounding pattern for this design resolution. HINT: We do not want the alias sets or design generators.Lovell Levelers just reported that Specific Motors is a satisfied customer. The leveler platequality is no longer an issue. In fact, they have not seen a single defect in six months!Phyllis Kendall made another surprise visit, but this time for a more pleasant reason.She presented each member of the team with a crisp, new $100 bill as a show of appreciation.But she also pointed out that we need to have a way to ensure that this problem will notcrop up again. The team is one step ahead of her and explained that the thickness of the leveler plates is being monitored and controlled with an on-going XmR (Individuals and Moving Range) chart so that any assignable causes of variation will be detected and addressed quickly.The parameters affecting the product thickness are also being monitored with a capability study.We want to make sure you can calculate control limits. You may construct the control chart by hand, or you may use a charting function in Excel. There are blank forms in theback of your notebook . Control Charts in Excel 2003Control Charts in Excel 20071. What is the upper control limit for the range?Help2. What is the upper control limit for the individuals?3. What is the lower control limit for the individuals?4. What would you do with the process? a. What would you recommend? b. Is the measurement system discriminate? "I have no idea about this one" c. Is thickness in statistical control?Thickness data for XMR control chart1a. Calculate R-barCalculating R-bar in Excel 2003Self check1b. Calculate the Calculating R-bar in Excel 2007upper control limit for the range"How do I do that?"2 & 3. Calculate the control limits for theindividualsCalculated R-Bar:ROUND YOUR FINAL RESULTS TO 6 DECIMAL PLACES.CheckUpper control limit for the range:Upper control limit for the individuals:Lower control limit for the individuals: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?Yes, there is adequate discrimination. Using a line chart, we can see more than 6 strata (13 in total, using 3 decimal place values). Is the Moving Range chart stable? Justify your answer using ALL of the tests for stability covered in the online textbook and virtual class on SPC. NOTE: IF YOU SAY THE CHART IS UNSTABLE, SPECIFY WHICH TEST(S) IT FAILS AND WHERE ON THE CHART IT FAILS BY REFERENCING THE SPECIFIC DATA POINTS THAT FAIL BY NUMBER (NOT VALUE).Is the Individuals chart stable? Justify your answer using ALL of the tests for stability covered in the online textbook and virtual class on SPC. NOTE: IF YOU SAY THE CHART IS UNSTABLE, SPECIFY WHICH TEST(S) IT FAILS AND WHERE ON THE CHART IT FAILS BY REFERENCING THE SPECIFIC DATA POINTS THAT FAIL BY NUMBER (NOT VALUE).Based upon what the control chart is telling you, what would you do next?
Six Sigma Questions - Statistics

Six Sigma Questions - Statistics

Question # 00027084 Posted By: snughollow Updated on: 09/29/2014 12:52 PM Due on: 10/02/2014
Subject Statistics Topic General Statistics Tutorials:
Question
Dot Image

i need the answers in the peach boxes on both tabs. One is for an XmR graph and one is Design of Experiments
Dot Image
Attachments
homework.xlsx (26 KB)
Tutorials for this Question
  1. neil2103
    Tutorial # 00026532 Posted By: neil2103 Posted on: 09/29/2014 04:33 PM
    Puchased By: 3
    Tutorial Preview
    The solution of Six Sigma Questions - Statistics...
      Get the Solution
    Attachments
    Sol.xls (604 KB)
Whatsapp Lisa