Instructions: $1.$ Data Calculation: o For each day, calculate the mean $($X$)$ and range $($R$)$ of the $10$ sample values. o Compute the overall average $($X$)$ of all the means and the average range $($R$)$ across the $20$ days. $2.$ Control Limits: o Using the overall averages, calculate the upper and lower control limits for both the X$-$chart and the R$-$chart. o Use standard control chart factors $($e$.$g$.,$ A$2,$ D$3,$ D$4$ values for the X$$ and R charts$)$ based on the sample size $($n $=10).3.$ Construct the Control Charts: o Plot the X$-$chart and the R$-$chart using the calculated values. o Ensure that the control limits$,$ averages, and individual data points are clearly represented. $4.$ Interpretation: $75050\mathrm{.}350\mathrm{.}250\mathrm{.}149\mathrm{.}850\mathrm{.}449\mathrm{.}95050\mathrm{.}250\mathrm{.}1850\mathrm{.}150\mathrm{.}25049\mathrm{.}950\mathrm{.}350\mathrm{.}449\mathrm{.}850\mathrm{.}25049\mathrm{.}9950\mathrm{.}449\mathrm{.}85050\mathrm{.}249\mathrm{.}950\mathrm{.}350\mathrm{.}15050\mathrm{.}249\mathrm{.}81050\mathrm{.}250\mathrm{.}15049\mathrm{.}950\mathrm{.}350\mathrm{.}249\mathrm{.}85050\mathrm{.}150\mathrm{.}41149\mathrm{.}95050\mathrm{.}250\mathrm{.}349\mathrm{.}850\mathrm{.}150\mathrm{.}45049\mathrm{.}950\mathrm{.}2125049\mathrm{.}850\mathrm{.}150\mathrm{.}350\mathrm{.}25049\mathrm{.}950\mathrm{.}450\mathrm{.}149\mathrm{.}71350\mathrm{.}249\mathrm{.}950\mathrm{.}15050\mathrm{.}350\mathrm{.}449\mathrm{.}850\mathrm{.}25049\mathrm{.}91450\mathrm{.}150\mathrm{.}249\mathrm{.}95050\mathrm{.}449\mathrm{.}850\mathrm{.}250\mathrm{.}349\mathrm{.}950155049\mathrm{.}950\mathrm{.}150\mathrm{.}349\mathrm{.}850\mathrm{.}250\mathrm{.}45050\mathrm{.}249\mathrm{.}71650\mathrm{.}349\mathrm{.}850\mathrm{.}250\mathrm{.}15050\mathrm{.}449\mathrm{.}950\mathrm{.}150\mathrm{.}349\mathrm{.}81750\mathrm{.}150\mathrm{.}250\mathrm{.}349\mathrm{.}95049\mathrm{.}850\mathrm{.}250\mathrm{.}45050\mathrm{.}11849\mathrm{.}85050\mathrm{.}250\mathrm{.}349\mathrm{.}950\mathrm{.}15050\mathrm{.}450\mathrm{.}249\mathrm{.}91950\mathrm{.}249\mathrm{.}95050\mathrm{.}350\mathrm{.}150\mathrm{.}449\mathrm{.}850\mathrm{.}25049\mathrm{.}92050\mathrm{.}150\mathrm{.}35050\mathrm{.}249\mathrm{.}950\mathrm{.}149\mathrm{.}850\mathrm{.}250\mathrm{.}450$ o Analyze the charts to determine if the process is in control or out of control. o Identify any points that fall outside the control limits$,$ and discuss the potential reasons behind these deviations. o Propose any corrective actions if necessary. Deliverables: $$ Complete the calculations for daily averages and ranges. $$ Plot the X$-$chart and R$-$chart. $$ Upload your spreadsheet with all the calculations and charts for grading