As mentioned in the last deliverable, one part of the CONTROL phase

I am on my last question. I only need the Pk and Ppk completed with explanation.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 all of the assignable causes and the process is now stable. Your team decided to use a Pp/Ppk study. Reflected in the data below is last month’s wait times under the new, stable process. You need to use this data in your Pp/Ppk study. You also need to construct a histogram as a part of your capability study to ensure that the process variation is still acting normal. By the way–finish this deliverable correctly and make all required corrections to the other assignments and you are finished with the project. Congratulations!!!! Instructions for you: 1. Construct a histogram from the data below. 2. Is the processes approximately normally distributed? Histograms in Excel 20033. Calculate Pp and Ppk. Note: The upper and lower specifications are listed to the right of the data. You will need these to do Histograms in Excel 2007 the calculations. 4. Based on the commonly accepted criteria covered in this course, More on Bin Ranges are the processes acceptable? Pp, Ppk formulas Use Excel 2003 to find mean and Standard Deviation Use Excel 2007 to find mean and Standard Deviation Data: Data: Wait times 7 11 9 8 6 12 9 9 8 13 11 7 7 10 14 8 8 10 9 9 15 9 9 6 10 9 Upper spec is 30 minutes 7 9 8 5 How to submit an Assignment YOU DO NOT NEED TO INCLUDE YOUR HISTOGRAM IN THIS ASSIGNMENT Project: Healthcare 2016 Deliverable: Pp Ppk Student last name: Your last name here Pp (round final result to 6 decimal places): Ppk (round final result to 6 decimal places): Is the process acceptable? What is the basis for your decision? Yes or No, and Why HINT! I am on my last question and only need Pk and Ppk. Can you help?