Capability Ratio & Capability Index
please show formulas in excel
XYZ Company produces a specific part that has a design target of 2.3 inches with tolerances of + 0.6 inch. The production process that manufactures these parts has a mean of 1.96 inches and a standard deviation of 0.095 inch. (1) Compute the process capability ratio and process capability index; (2) Determine whether the overall capability of the process meets the design specifications.
