Question: Please use Excel QM to solve this problem. The data is pasted into the spreadsheet. You do not have to do any calculations. Small boxes

Please use Excel QM to solve this problem. The data is pasted into the spreadsheet. You do not have to do any calculations. 

Small boxes of Nutra Flakes cereal are labeled "net weight 10 ounces." Each hour, random samples of size boxes are weighed to check process control. five hours of observations yielded the following: 

Time   9.a.m    10.a.m    11.a.m     Noon     1.p.m 

Box 1   9.8         10.1         9.9          9.7        9.7 

Box 2    10.4      10.2        10.5         9.8       10.1 

Box 3     9.9         9.9         10.3       10.3      9.9 

Box 4     10.3       9.8         10.1        10.2        9.9 

Using the data, construct limits for x-bar and R-charts. is the process in control?

What other steps should the quality control department follow at this point? 

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 Operating System Questions!