A new machine has just been installed to cut and rough-shape large slugs. The slugs are then transferred to a precision grinder. One of the critical measurements is the outside diameter. The quality control inspector randomly selected five slugs each hour, measures the outside diameter, and recorded the results. The measurements (in millimeters) for the period 8:00 am to 10:30 am follow.

	Outside diameter (millimeters)
Time (samples)
8:00	87.1	87.3	87.9	87.0	87.0
8:30	86.9	88.5	87.6	87.5	87.4
9:00	87.5	88.4	86.9	87.6	88.2
9:30	86.0	88.0	87.2	87.6	87.1
10:00	87.1	87.1	87.7	87.1	87.1
10:30	88.0	86.2	87.4	87.3	87.8

Set up a spreadsheet to do your calculations and plot the control charts.

a. Use Excel to do all the calculations, use Excel functions as much as possible

to calculate each sample average, sample range, mean of the means (grand mean), average range, upper and lower control limits.

b. Create a mean chart

Plot the sample averages, upper and lower mean limits on one chart

c. Create a range chart

Plot the sample ranges, upper and lower range limits on a second chart

d. What do you conclude from your charts??