please show all work in excel and minitab

please show all the formulas!!

5. (15 points) The overall length of the skew used in a knee replacement device is monitored using an appropriate control chart. The table presented in the Excel file test 3, worksheet Q5 gives the length for 14 samples of size 4. (a) Set the appropriate control chart. If necessary, revise your control limits, assuming that any samples that plot outside the control limits can be eliminated. (b) The specifications limits are 18.50 +0.50. What conclusions can you draw about the ability of the process to operate within these limits. Estimate the percent of defective items that will be produced. (c) Estimate the process capability ratios that you consider be appropriate to draw conclusions about the capability of this process. Write your conclusion. BE E C D Observation 2 3 1 4 x 13 A 1 Sample 2 3 1 4 2 5 3 6 4 7 5 un co 16 16 15 14 18 15 16 16 15 17 20 14 16 16 12 16 14 8 6 16 15 15 9 7 16 17 15 14 16 13 11 18 10 11 15 15 13 16 14 17 13 14 15 15 16 14 12 cao=an 13 14 16 16 13 13 16 15 21 14 14 13 17 14 15 13 15 11 16 17 10