show answer with excel formula if possible

Sample 1 2 3 1 2 8.34 7.77 8.18 8.13 8.14 8.14 8.38 7.89 8.24 7.87 8.33 6 8.13 456 Tube number 3 4 5 6 7 8 8.02 7.94 8.44 8.26 7.81 8.11 7.88 8.04 8.00 7.89 7.93 8.09 7.83 8.09 7.90 8.16 7.97 8.07 7.92 7.99 8.01 7.81 8.14 7.88 8.08 8.51 8.41 8.28 8.09 8.16 8.11 8.13 8.14 7.96 8.13 8.14 Size of Sample (n) 2 3 456789 Factors for calculating three-sigma limits for the x-chart and R-chart. Factor for UCL and LCL Factor for LCL for R-Chart (D3) Factor for UCL for R-Chart (D4) for x-chart (A) 1.880 0 3.267 1.023 0 2.575 0.729 0 2.282 0.577 0 2.115 0.483 0 2.004 0.419 0.076 1.924 0.373 0.136 1.864 0.337 0.184 1.816 0.308 0.223 1.777 10 Webster Chemical Company produces mastics and caulking for the construction industry. The product is blended in large mixers and then pumped into tubes and capped. Management is concerned about whether the filling process for tubes of caulking is in statistical control. The process should be centered on 8 ounces per tube. Several samples of eight tubes were taken, each tube was weighed, and the weights in the table below were obtained. Click the icon to view the ounces of caulking per tube data. Click the icon to view the table of factors for calculating three-sigma limits for the x-chart and R-chart. a. Assume that only six samples are sufficient and develop the control charts for the mean and the range. Set up the R-chart by specifying the center line and three-sigma control limits below. (Enter your responses rounded to three decimal places.) R-chart UCLR = R= LCLR =