Question: Im not sure how to put this in excel please help. Thank you! Product quality assurance (QA) is a particularly tricky business in the dye
Im not sure how to put this in excel please help. Thank you!


Product quality assurance (QA) is a particularly tricky business in the dye manufacturing industry. A slight variation in reaction conditions can lead to a measurable change in the color of the product, and since customers usually require extremely high color reproducibility from one shipment to another, even a small color change can lead to rejection of a product batch. Suppose the various color frequency and intensity values that comprise a color analysis are combined into a single numerical value, c, for a particular yellow dye. During a test period in which the reactor conditions are carefully controlled and the reactor is thoroughly cleaned between successive batches (not the usual procedure), product analyses of 12 batches run on successive days yield the following color readings: The QA specification for routine production is that a batch that falls more than two standard deviations away from the test period mean must be rejected and sent for reworking. Determine the minimum and maximum acceptable values of C,as follows: a) Using Excel (show Excel printout)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
