Q$1.$ We reviewed the R&R analysis in class, and here is the data for two operators, two trials, and seven parts. Given the information provided, please finish this question $($you don$$t need to submit the Excel file, and you can just write down the values requested below$).$ Please keep attention to the constant values and because they change based on the number of operators, trials, and parts.

Operator $1$ Operator $2$

Trial $1$ Trial $2$ Trial $1$ Trial $2$

$1212$

$0\mathrm{.}530\mathrm{.}540\mathrm{.}760\mathrm{.}75$

$0\mathrm{.}340\mathrm{.}350\mathrm{.}840\mathrm{.}85$

$0\mathrm{.}730\mathrm{.}760\mathrm{.}670\mathrm{.}70$

$0\mathrm{.}560\mathrm{.}520\mathrm{.}720\mathrm{.}76$

$0\mathrm{.}560\mathrm{.}570\mathrm{.}530\mathrm{.}52$

$0\mathrm{.}880\mathrm{.}870\mathrm{.}430\mathrm{.}42$

$0\mathrm{.}860\mathrm{.}850\mathrm{.}840\mathrm{.}83$

Given the data, $1).$ Please find the control limit for individual ranges; $2).$ please find the equipment variation $($EV$),$ appraiser variation $($AV$),$ repeatability and reproducibility $($R&R$),$ part variation $($PV$),$ and total variation $($TV$)$; $3).$ please also find the EV$\%$ of the total variance, AV$\%$ of the total variance, R&R$\%$ of the total variance, and PV$\%$ of the total variance.