Quality Control

Part 2:Show your work and explain your process for determining the solution for each of these problems on a word document with the solution given below the problem. If Excel was used, please indicate that as well on the word document. A word document and/or the Excel Workbook (if used) should be submitted to the Dropbox with labels on the worksheets to indicate which problem is being evaluated.All answers should be clearly indicated. Written explanation, reasoning, and rationale should use complete sentences. A venture capitalist has just given you several million dollars to develop your dream product! Explain in detail what this product is and why people would buy it. (Think Steve Jobs and the iPhone – did people really think we needed “smartphones” back in 2007?)Now your dream product has gone into production and the manager is asking you, as the statistical expert, to use statistical methods to ensure quality control. See example and CA Starter video in this module’s Livebinder.Construct a quality control chart and compute upper and lower control limit bounds.You will generate a random dataset of N samples of defective proportions by completing the following steps:You will start with a random number by combining the last 2 digits of the year in which you were born plus the day of the month in which you were born. For example, if you were born October 3, 1990, your number would be 90 + 3 = 93. (If your number exceeds 100, subtract 100 from the total.) Call this X and it will seed your random number generation. (I was born on 10/02/1986)Choose a number of samples, N. (N should be between 5 and 10 samples.)In Excel, type =RAND()*X in a cell. Repeat N times. This will generate the proportion of defective products (out of 100) for your N samples.Use Excel to create a p-chart for a sample size, 100, and the number of samples, N.  See video in Livebinder for creating the p-chart.What is your Lower Control Limit (LCL) and Upper Control Limit (UCL).Achieve goals through planning and prioritization.Is the product in control? If not in control, what sample(s) was outside of the limits, ie below LCL or above UCL?What measures could be taken now to address the data points that out of control?What recommendations would you suggest to optimize quality in future production?MM305M6 Competency Assessment RubricCriteriaMetNot yet metInterpret the features of a quality control chart.  [Construct a quality control chart.]  [Compute upper and lower control limit bounds.]  Apply qualities of the normal distribution to control measures.  Apply probabilities concepts to quality control.Analyze if a process is in control.Total   The criterion statements in Bold are the minimum requirement to show competent performance on the course outcome; all Bold criteria must be met to pass this course outcome.   A “Met” mark for Bold criterion is awarded for certification in the associated lesson(s). The criterion statements in [Brackets] represent mastery achievement. A predefined number of mastery criteria must be achieved to earn an A grade, indicating mastery of the course outcome.  A “Met” mark for [Brackets] criterion is awarded by demonstrating competent performance in part 2 of the assessment.. For the written portion, students are to submit a word document and/or Excel workbook(s) that clearly demonstrate the student is able to solve each problem appropriately.  All problems and work must be clearly labeled on the word document and/or Excel workbook(s) submitted.  Standard English with appropriate punctuation and grammar should be used. CLA and Grade Criteria ChartCriteriaCLA ScoreGradePoints Meets all bold criterion and at least 1 mastery criterion5A1,000 Meets at all bold criterion and no mastery criterion4B850 Meets 3 bold criterion3(not yet competent) F at term end0 Meets 2 of the bold criterion2(not yet competent) F at term end0 Meets 1 of the bold criterion 1(not yet competent) F at term end0 Meets fewer than 1 of the bold criterion 0(not yet competent) F at term end0 No work submitted.N/A(not yet competent) F at term end0   


Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper