Sample

$123456$

Observation $1161717171616$

$2171717161623$

$3171616161617$

$4172217161716$

$5161616161717$

$6171717161616$

$7171616172116$

$8171616171617$

$9171716161717$

$10172316171717$

$11171616171717$

$12161716171717$

$13171617171616$

$14161617171717$ An organization specializes in the farming and distribution of watermelons to stores throughout the country. The organization has a specific fertilizer and maturation schedule to ensure that the melons are within a specific weight range at the time of packaging. In order to check whether the aforementioned fertilizer and maturation schedule is achieving the organization$$s goals, SPC has been implemented.

Create a control chart in MS Excel that includes the UCL, LCL$,$ Target and sample statistics to be compared to the UCL and LCL$.$

Is the process deemed in or out of control? Provide specific evidence to support your position.

Also, apply conditional formatting to the appropriate sample statistics to indicate their respective status, in $($Green Fill with Dark Green Text$)$ or out $($Light Red Fill with Dark Red Text$)$ of control.