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!

Im not sure how to put this in excel please help. Thank

you! Product quality assurance (QA) is a particularly tricky business in the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!