Open the attached Excel workbook. There are two sheets with all the data. Since it is

difficult to draw the control limit lines in an Excel chart, I made it easy by formulating

the worksheet so that the charts will show the control lines. Do not change any data in

the colored cells.

In a manufacturing operation a particular part needs to have close tolerances to fit into

the bushings of the next operation. The part is produced but does not always comply

with specifications. This problem seriously disrupts the total production output of

completed items.

During the day $12$ samples of $5$ units each $(n=5$ when you use the table of factors for

computing control limits$)$ were collected during a shift. The data for the measurements

is in the Excel File that is attached to the assignment.

On each of the sheets calculate the average and range or standard deviation for each

$5-$sample group. On the sheet you will find advice about the formulas to use.

Then calculate the Upper and Lower control limits using the formulas on page $208$ of

the textbook. If your electronic version of the book has different page numbers, it is the

last page before the Chapter Problems in Chapter $6.$

Once you have calculated the control limits$,$ the colored areas will be populated with

your data. Select all the cells in a specific$-$colored area and then click insert chart and

select line chart. The run charts will be displayed with the Control lines and Center line

on the chart. Evaluate the charts and write in the answers on the Excel sheet in the

areas below the questions.

Do this for both sheets, save your work in a file that you will be able to upload to

Blackboard.