Find the Data below. This data contains 20 samples collected from a cosmetic manufacturing line. The data indicates the skin sensitivity level to a har color. The Excel file also has the A2, D3, D4, and d2 table on the second sheet. Please write see attachment in the answer space if you do graphics in Excel file and you want to attach it to your homework. Please try to use Excel, otherwise you may have to do a lot of computation by hand. (a) Construct an X-bar chart for this manufacturing line: X-bar Chart i. Is this process in control? ii. Do you notice any problems despite your answer to Part i? ___________________________________________________________________________ ___________________________________________________________________________ (b) Construct an R-Chart for this manufacturing line: R-Charti. Is this process in control? ii. Based on your calculation for the X-Bar Chart and R-Chart, compare your answers regarding the in control question? Do the charts result differently? Why or Why Not? ___________________________________________________________________________ ___________________________________________________________________________ ___________________________________________________________________________

Here is the data that need to be used

\begin{tabular}{|c|c|c|c|c|c|} \hline Sample Size (n) & Factor for X-bar Chart (A2) & Factor for Lower Control Limit in R chart (D3) & Factor for Upper Control Limit in R chart (D4) & Sactor to estimate Standard deviation, (d2) \\ \hline 2 & 1.88 & 0 & 3.27 & 1.128 \\ \hline 3 & 1.02 & 0 & 2.57 & 1.693 \\ \hline 4 & 0.73 & 0 & 2.28 & 2.059 \\ \hline 5 & 0.58 & 0 & 2.11 & 2.326 \\ \hline 6 & 0.48 & 0 & 2 & 2.534 \\ \hline 7 & 0.42 & 0.08 & 1.92 & 2.704 \\ \hline 8 & 0.37 & 0.14 & 1.86 & 2.847 \\ \hline 10 & 0.34 & 0.18 & 1.82 & \\ \hline \end{tabular}