can you please answer this question in excel with the formulas, thank you.

Q4) Auto pistons at Wemming Chung's plant in Shanghai are produced in a forging process, and the diameter is a critical factor that must be controlled. From sample sizes of 10 pistons produced each day, the mean and the range of this diameter have been as follows: a) What is the value of x (grand)? b) What is the value of R (bar)? c) What are the UCLx and LCLx, using 36? Plot the data. d) What are the UCLR and LCLR, using 36 ? Plot the data \begin{tabular}{|c|c|c|c|} \hline Sample Size & A2 & D3 & D4 \\ \hline 2 & 1.88 & 0 & 3.2670 \\ \hline 3 & 1.023 & 0 & 2.5740 \\ \hline 4 & 0.729 & 0 & 2.2820 \\ \hline 5 & 0.577 & 0 & 2.1140 \\ \hline 6 & 0.483 & 0 & 2.0040 \\ \hline 7 & 0.419 & 0.076 & 1.9240 \\ \hline 8 & 0.373 & 0.136 & 1.8640 \\ \hline 9 & 0.337 & 0.184 & 1.8160 \\ \hline 10 & 0.308 & 0.223 & 1.7770 \\ \hline 11 & 0.285 & 0.256 & 1.7440 \\ \hline 12 & 0.266 & 0.283 & 1.7170 \\ \hline 13 & 0.249 & 0.307 & 1.6930 \\ \hline 14 & 0.235 & 0.328 & 1.6720 \\ \hline 15 & 0.223 & 0.347 & 1.6530 \\ \hline 16 & 0.212 & 0.363 & 1.6370 \\ \hline 17 & 0.203 & 0.378 & 1.6220 \\ \hline 18 & 0.194 & 0.391 & 1.6080 \\ \hline 19 & 0.187 & 0.403 & 1.5970 \\ \hline 20 & 0.18 & 0.415 & 1.5850 \\ \hline 21 & 0.173 & 0.425 & 1.5750 \\ \hline 22 & 0.167 & 0.434 & 1.5660 \\ \hline 23 & 0.162 & 0.443 & 1.5570 \\ \hline 24 & 0.157 & 0.451 & 1.5480 \\ \hline 25 & 0.153 & 0.459 & 1.5410 \\ \hline & & & \\ \hline \end{tabular} Q4) Auto pistons at Wemming Chung's plant in Shanghai are produced in a forging process, and the diameter is a critical factor that must be controlled. From sample sizes of 10 pistons produced each day, the mean and the range of this diameter have been as follows: a) What is the value of x (grand)? b) What is the value of R (bar)? c) What are the UCLx and LCLx, using 36? Plot the data. d) What are the UCLR and LCLR, using 36 ? Plot the data \begin{tabular}{|c|c|c|c|} \hline Sample Size & A2 & D3 & D4 \\ \hline 2 & 1.88 & 0 & 3.2670 \\ \hline 3 & 1.023 & 0 & 2.5740 \\ \hline 4 & 0.729 & 0 & 2.2820 \\ \hline 5 & 0.577 & 0 & 2.1140 \\ \hline 6 & 0.483 & 0 & 2.0040 \\ \hline 7 & 0.419 & 0.076 & 1.9240 \\ \hline 8 & 0.373 & 0.136 & 1.8640 \\ \hline 9 & 0.337 & 0.184 & 1.8160 \\ \hline 10 & 0.308 & 0.223 & 1.7770 \\ \hline 11 & 0.285 & 0.256 & 1.7440 \\ \hline 12 & 0.266 & 0.283 & 1.7170 \\ \hline 13 & 0.249 & 0.307 & 1.6930 \\ \hline 14 & 0.235 & 0.328 & 1.6720 \\ \hline 15 & 0.223 & 0.347 & 1.6530 \\ \hline 16 & 0.212 & 0.363 & 1.6370 \\ \hline 17 & 0.203 & 0.378 & 1.6220 \\ \hline 18 & 0.194 & 0.391 & 1.6080 \\ \hline 19 & 0.187 & 0.403 & 1.5970 \\ \hline 20 & 0.18 & 0.415 & 1.5850 \\ \hline 21 & 0.173 & 0.425 & 1.5750 \\ \hline 22 & 0.167 & 0.434 & 1.5660 \\ \hline 23 & 0.162 & 0.443 & 1.5570 \\ \hline 24 & 0.157 & 0.451 & 1.5480 \\ \hline 25 & 0.153 & 0.459 & 1.5410 \\ \hline & & & \\ \hline \end{tabular}