Statistical Process Control Assignment: An organization specializes in the farming and distribution of Norland potatoes, which were developed at North Dakota State University in $1957,$ to stores throughout the country. The organization has a specific fertilizer and maturation schedule to ensure that the potatoes are within a specific weight range at the time of packaging. Specifically, the organization is interested in evaluating the prevalent process dispersion. In order to check whether the aforementioned fertilizer and maturation schedule is achieving the organization$$s goals, SPC has been implemented. Assignment: Use the uploaded picture of the MS Excel worksheet of Sample Weights to create an Excel file. $1.$ Create a control chart in MS Excel that includes: $$ UCL, LCL$,$ Target and sample statistics to be compared to the UCL and LCL $2.$ Formulas must be included in the MS Excel worksheet! $3.$ Apply conditional formatting to the appropriate sample statistics to indicate their status. Conditional Formatting:$$ In Control$=$ Green Fill with Dark Green Text Out of Control $=$ Light Red Fill with Dark Red Text $4.$ Is the process deemed in or out of control?$$ Provide specific evidence to support your position. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & A & B & C & D & E & F & G & H & I & J & K & L $\backslash \backslash$

$\backslash$hline $1$ & & $\backslash$multicolumn$\{11\}\{|$c$|\}\{$Sample$\}\backslash \backslash$

$\backslash$hline $2$ & & & $1$ & $2$ & $3$ & $4$ & $5$ & $6$ & $7$ & $8$ & $9$ & $10\backslash \backslash$

$\backslash$hline $3$ & $\backslash$multirow$\{12\}\{*\}\{\}$ & $1$ & $3\mathrm{.}38$ & $3\mathrm{.}67$ & $3\mathrm{.}48$ & $3\mathrm{.}67$ & $3\mathrm{.}89$ & $3\mathrm{.}38$ & $3\mathrm{.}67$ & $3\mathrm{.}89$ & $3\mathrm{.}67$ & $3\mathrm{.}48\backslash \backslash$

$\backslash$hline $4$ & & $2$ & $3\mathrm{.}72$ & $4\mathrm{.}04$ & $3\mathrm{.}84$ & $4\mathrm{.}04$ & $4\mathrm{.}29$ & $3\mathrm{.}72$ & $4\mathrm{.}04$ & $4\mathrm{.}29$ & $4\mathrm{.}04$ & $3\mathrm{.}84\backslash \backslash$

$\backslash$hline $5$ & & $3$ & $3\mathrm{.}84$ & $4\mathrm{.}17$ & $3\mathrm{.}96$ & $4\mathrm{.}17$ & $4\mathrm{.}42$ & $3\mathrm{.}84$ & $4\mathrm{.}17$ & $4\mathrm{.}42$ & $4\mathrm{.}17$ & $3\mathrm{.}96\backslash \backslash$

$\backslash$hline $6$ & & $4$ & $3\mathrm{.}61$ & $3\mathrm{.}92$ & $3\mathrm{.}72$ & $3\mathrm{.}92$ & $4\mathrm{.}16$ & $3\mathrm{.}61$ & $3\mathrm{.}92$ & $4\mathrm{.}16$ & $3\mathrm{.}92$ & $3\mathrm{.}72\backslash \backslash$

$\backslash$hline $7$ & & $5$ & $4\mathrm{.}18$ & $4\mathrm{.}54$ & $4\mathrm{.}31$ & $4\mathrm{.}54$ & $4\mathrm{.}82$ & $4\mathrm{.}18$ & $4\mathrm{.}54$ & $4\mathrm{.}82$ & $4\mathrm{.}54$ & $4\mathrm{.}31\backslash \backslash$

$\backslash$hline $8$ & & $6$ & $5\mathrm{.}10$ & $5\mathrm{.}54$ & $5\mathrm{.}26$ & $5\mathrm{.}54$ & $5\mathrm{.}88$ & $5\mathrm{.}10$ & $5\mathrm{.}54$ & $5\mathrm{.}88$ & $5\mathrm{.}54$ & $5\mathrm{.}26\backslash \backslash$

$\backslash$hline $9$ & & $7$ & $3\mathrm{.}72$ & $4\mathrm{.}04$ & $3\mathrm{.}84$ & $4\mathrm{.}04$ & $4\mathrm{.}29$ & $3\mathrm{.}72$ & $4\mathrm{.}04$ & $4\mathrm{.}29$ & $4\mathrm{.}04$ & $3\mathrm{.}84\backslash \backslash$

$\backslash$hline $10$ & & $8$ & $3\mathrm{.}84$ & $4\mathrm{.}17$ & $3\mathrm{.}96$ & $4\mathrm{.}17$ & $4\mathrm{.}42$ & $3\mathrm{.}84$ & $4\mathrm{.}17$ & $4\mathrm{.}42$ & $4\mathrm{.}17$ & $3\mathrm{.}96\backslash \backslash$

$\backslash$hline $11$ & & $9$ & $4\mathrm{.}18$ & $4\mathrm{.}54$ & $4\mathrm{.}31$ & $4\mathrm{.}54$ & $4\mathrm{.}82$ & $4\mathrm{.}18$ & $4\mathrm{.}54$ & $4\mathrm{.}82$ & $4\mathrm{.}54$ & $4\mathrm{.}31\backslash \backslash$

$\backslash$hline $12$ & & $10$ & $3\mathrm{.}95$ & $4\mathrm{.}29$ & $4\mathrm{.}08$ & $4\mathrm{.}29$ & $4\mathrm{.}56$ & $3\mathrm{.}95$ & $4\mathrm{.}29$ & $4\mathrm{.}56$ & $4\mathrm{.}29$ & $4\mathrm{.}08\backslash \backslash$

$\backslash$hline $13$ & & $11$ & $3\mathrm{.}38$ & $3\mathrm{.}67$ & $3\mathrm{.}48$ & $3\mathrm{.}67$ & $3\mathrm{.}89$ & $3\mathrm{.}38$ & $3\mathrm{.}67$ & $3\mathrm{.}89$ & $3\mathrm{.}67$ & $3\mathrm{.}48\backslash \backslash$

$\backslash$hline $14$ & & $12$ & $4\mathrm{.}30$ & $4\mathrm{.}66$ & $4\mathrm{.}43$ & $4\mathrm{.}66$ & $4\mathrm{.}96$ & $4\mathrm{.}30$ & $4\mathrm{.}66$ & $4\mathrm{.}96$ & $4\mathrm{.}66$ & $4\mathrm{.}43\backslash \backslash$

$\backslash$hline $15$ & & & & & & & & & & & & $\backslash \backslash$

$\backslash$hline $16$ & $\backslash (\backslash$sigma$=\backslash )$ & $0\mathrm{.}12$ & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$