Please solve with exel spread sheet $->$A process filling small bottles with baby formula has a target of $3$ ounces $\backslash$pm $0\mathrm{.}10$ ounces. In other words, a

bottle must contain between $2\mathrm{.}9$ and $3\mathrm{.}1$ ounces of baby formula. As part of a periodic process

capability study, two hundred bottles from the process were sampled. The results showed the average

amount of formula filled in the bottles to be $2\mathrm{.}972$ ounces with a standard deviation of $0\mathrm{.}023$ ounces.

a$.$ Would you consider this process capable of meeting the required specifications? Answer by

calculating an appropriate measure of capability.

b$.$ Assuming that the quantity of formula in a bottle is normally distributed, out of a batch of a

million bottles how many do you think would be unacceptable $$ i$.$e$.,$ outside the specification

limits$?$

c$.$ Currently the process is not centered. If the process is adjusted so that it becomes centered,

what is the impact on the process capability measure that you calculated in $($a$)?$

d$.$ Assume that the process is centered. What should the process standard deviation be in order

for the process to be considered Six$-$Sigma compliant $($i$.$e$.,$ have Cp or Cpk of $2\mathrm{.}0)?$