Please answer with Exel spread sheet $->$The quality department of Lithion Corp uses control charts to monitor the life of the lithium$-$ion

batteries produced by the company. The quality manager has returned from a course on statistical

process control and has collected the data shown in the tab Battery Life.

a$.$ Using this data calculate $3-$Sigma control limits for X$-$bar and R charts.

b$.$ Plot the sample means on the X$-$bar chart and the sample ranges on the R chart.

c$.$ Do the X$-$bar and R charts indicate that the process is in control? Why or why not?

d$.$ Because of rising demand a second shift has been added with some temporary workers. The

control limits for the first shift are used for the second shift also. Six samples of battery life

were taken from this shift. This data is shown in the tab Second Shift. Does this new indicate

that battery life is still in control? Why or why not? Answer by plotting this new data against

the control limits calculated in $($a$)$