Question: Statistical Process Control An organization specializes in the farming and distribution of Norland potatoes, which were developed at North Dakota State University in 1 9
Statistical Process Control
An organization specializes in the farming and distribution of Norland potatoes, which were developed at North Dakota State University in 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.
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.
Submit your answer and supporting evidence to the question posed in a MS Word document. All calculations, charting, and conditional formatting must be done in MS Excel. Submit your MS Excel file with your MS Word file.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
