SPC Charting $/$ Capability

For the data provided in a separate spreadsheet $[$Valve Assembly Clearance$],$ please complete

the following:

Determine centerlines and control limits for both the X $-$bar and R charts $[$ show your work

Plot the data on the chart with centerline and control limits drawn appropriately

Are there any out$-$of$-$control conditions? If so$,$ indicate where they are and the reason why

they are out of control.

Calculate the process capability indices Cp and Cpk $-$ Is the process capable? Why or

why not

If the process is normal, what is the fraction out$-$of$-$specifications $[$ assuming the

specifications are $1\mathrm{.}75+-0\mathrm{.}05mm$

$\backslash$table$[[$ABC Company,Customer:,Part Name $/$ Number: Valve P$362-3,$Specs.: $1\mathrm{.}75+-0\mathrm{.}05mm$