Please show me how to do this in excel

Bottle Sample 1 2 3 4 1 0.586 0.589 0.605 0.581 2 0.583 0.611 0.616 0.594 3 0.575 0.580 0.588 0.597 4 0.614 0.620 0.602 0.585 5 0.616 0.613 0.584 0.621 6 0.588 0.621 0.589 0.587

More info Factors for calculating three-sigma limits for the x-chart and R-chart Factor for LCL for R-Chart (D3) Factor for UCL for R-Chart (D) Size of Sample Factor for UCL and LCL (n) for X-chart (A2) 2 1.880 3 1.023 4 0.729 5 0.577 6 0.483 7 0.419 8 0.373 9 0.337 10 0.308 0 0 0.076 0.136 0.184 0.223 3.267 2.575 2.282 2.115 2.004 1.924 1.864 1.816 1.777 Print Done Aspen Plastics produces plastic bottles to customer order. The quality inspector randomly selects four bottles from the bottle machine and measures the outside diameter of the bottle neck, a critical quality dimension that determines whether the bottle cap will fit properly. The dimensions (in.) from the last six samples are 4 Sample 1 1 2 3 4 5 6 1 0.586 0.583 0.575 0.614 0.616 0.588 Bottle 2 3 0.589 0.605 0.611 0.616 0.580 0.588 0.620 0.602 0.613 0.584 0.621 0.589 0.581 0.594 0.597 0.585 0.621 0.587 Click the icon to view the table of factors for calculating three-sigma limits for the X-chart and R-chart. Assume that only these six samples are sufficient, and use the data to determine control limits for an R- and an x-chart. Compute the range R and the sample mean x for each sample. (Enter your responses rounded to three decimal places.) 1 1 4 X Sample 1 2 3 4 0.586 0.583 0.575 0.614 0.616 Bottle 2 3 0.589 0.605 0.611 0.616 0.580 0.588 0.620 0.602 0.613 0.584 0.581 0.594 0.597 0.585 0.621 R 0.024 0.033 0.022 0.035 0.590 0.601 0.585 0.605 5 6 0.588 0.621 0.589 0.587 The UCLR equals inches and the LCLR equals inches. (Enter your responses rounded to three decimal places. If your answer for LCLR is negative, enter this value as 0.) The UCL, equals inches and the LCL; equals inches. (Enter your responses rounded to three decimal places.)