Process Capability Studies $(2$pts$)$

A$)$ The following sample of $100$ data points were recorded

$19\mathrm{.}00169451$ Process specification

$17\mathrm{.}83494596$ maximum $21\mathrm{.}00000$ minimum $15\mathrm{.}00000$

$21\mathrm{.}97119077$

$16\mathrm{.}71923121$

$21\mathrm{.}35932537$ Calculate the process capability indices, Cp and Cpk $($make sure to use formulas to calculate the answer, never type a literal answer in Excel$)$

$18\mathrm{.}90685039$

$19\mathrm{.}34451526$

$18\mathrm{.}35672733$ Cp $(\mathrm{.}3$ pt$)$

$17\mathrm{.}78013023$

$20\mathrm{.}89942913$ Cpk $(\mathrm{.}3$ pt$)$

$16\mathrm{.}60726361$

$18\mathrm{.}62002614$

$19\mathrm{.}58515357$

$18\mathrm{.}85351116$

$19\mathrm{.}49367966$

$20\mathrm{.}13379309$ B$)$ Crunchy Potato Chip plant sells packaged chips with a printed net weight of $800$ grams. Their packaging specification limits are $+/-8$ grams of this published fill weight. Currently the process is running at a mean of $807$ grams with a standard deviation of $1\mathrm{.}6$ grams. The firm requires a process capability ratio of at least $1\mathrm{.}33$ to be deemed "capable." Is the process capable? Is an adjustment needed?

$19\mathrm{.}89188482$

$20\mathrm{.}5538229$

$18\mathrm{.}25448502$

$19\mathrm{.}81178027$

$20\mathrm{.}9988059$

$18\mathrm{.}81101997$ Cp $(\mathrm{.}3$ pt$)$

$19\mathrm{.}32290623$

$18\mathrm{.}4612683$ Cpk $(\mathrm{.}3$ pt$)$

$16\mathrm{.}61763466$

$16\mathrm{.}67083041$ Capable? $(\mathrm{.}2$ pt$)$

$21\mathrm{.}01936115$ Why? $(\mathrm{.}2$ pt$)$

$19\mathrm{.}80396792$

$18\mathrm{.}37827848$

$18\mathrm{.}37324989$

$17\mathrm{.}48557574$ Adjustment needed? $(\mathrm{.}2$ pt$)$

$19\mathrm{.}99019814$ Why? $(\mathrm{.}2$ pt$)$

$21\mathrm{.}46166621$

$18\mathrm{.}74172508$

$20\mathrm{.}81905077$

$18\mathrm{.}45916952$

$17\mathrm{.}65166923$

$21\mathrm{.}1077458$

$16\mathrm{.}97178319$

$16\mathrm{.}62324024$

$17\mathrm{.}01943859$

$18\mathrm{.}11534744$

$21\mathrm{.}75184624$

$21\mathrm{.}68607259$

$16\mathrm{.}22471581$

$20\mathrm{.}31538462$

$18\mathrm{.}13380459$

$16\mathrm{.}16727164$

$21\mathrm{.}37642331$

$17\mathrm{.}50551306$

$21\mathrm{.}89088451$

$16\mathrm{.}88164806$

$16\mathrm{.}19531533$

$19\mathrm{.}5328017$

$20\mathrm{.}53828666$

$17\mathrm{.}57163188$

$18\mathrm{.}73027084$

$16\mathrm{.}14797876$

$20\mathrm{.}09418397$

$21\mathrm{.}81642031$

$21\mathrm{.}44465484$

$18\mathrm{.}5857048$

$18\mathrm{.}61207394$

$16\mathrm{.}27113671$

$18\mathrm{.}21101622$

$21\mathrm{.}21873909$

$16\mathrm{.}72366991$

$19\mathrm{.}56213521$

$19\mathrm{.}79900151$

$18\mathrm{.}44385248$

$19\mathrm{.}08862292$

$16\mathrm{.}7678095$

$18\mathrm{.}18699221$

$21\mathrm{.}29139859$

$20\mathrm{.}41204432$

$17\mathrm{.}98319187$

$18\mathrm{.}24349137$

$20\mathrm{.}1452724$

$18\mathrm{.}94917912$

$19\mathrm{.}38086632$

$17\mathrm{.}6236239$

$17\mathrm{.}0857955$

$19\mathrm{.}30707233$

$16\mathrm{.}01911873$

$17\mathrm{.}36111031$

$18\mathrm{.}15100266$

$17\mathrm{.}94148999$

$17\mathrm{.}2137261$

$16\mathrm{.}83557315$

$19\mathrm{.}43347325$

$19\mathrm{.}81383497$

$20\mathrm{.}93813921$

$17\mathrm{.}8669256$

$18\mathrm{.}84800381$

$20\mathrm{.}63111966$

$18\mathrm{.}70142014$

$17\mathrm{.}20668309$

$17\mathrm{.}84376875$

$21\mathrm{.}99951947$

$21\mathrm{.}57130888\backslash$