Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
Calculate Cp and Cpk with Excel, "Quality engineering"
This is case study to calculate Cp and Cpk It's for an intro to quality engineering class
Please Read it very carefully.
In the Excel file there is the case and the numbers plus questions about the process. There are several parts to it. Along with the white boards it contains all the information you should need to answer it well, It is an Excel file and you can use Excel's capabilities to make calculations easier, although it is important that I can see your logic and approach as well. Hand drawn control charts are fine, and ensure the key values asked for are written. There is a partial credit even if there are math errors provided that the approach is good.
Note: that there is more than one way to calculate Cp and Cpk and they may give slightly different numbers - either method is OK but show your working clearly.
if you hand draw anything (which you will unless you are really good at Excel) you will need to scan it of course there is a lot of app on any phone nowadays
I will attache the Excel file
Thank you.