Please show equations!

Problem 4 (Show all your problem-solving processes on the MS Excel template given; Once you are done, submit the template on the same dropbox). (8 points) In order to create X - and R-charts for a process, 5 samples of size 3 (n=3) are measured. Use the Table 1 below to calculate three-sigma limits for the X -chart and R-chart (Round your answers to the nearest hundredth). a. Determine A2, D3, and D4 for x and R charts. b. Find the control limits for X - chart (UCL7 ,LCLF). c. Find the control limits for R-chart (UCLR, LCLR). d. Develop X - chart and R-chart and plot the values. Using your results from both X - chart and R-chart, is the production process still in control? Why or why not? Obs 1 Obs 2 Obs 3 X-bar R Sample Number 1 2 X-double bar Answer d: UCLX-bar LCLx-bar R-bar 3 10.6 9.98 9.85 10.2 10.3 10.4 10.25 9.9 10.1 10.2 10.3 10.05 10.2 10.3 10.24 A2 4 D4 UCLR LCLR 5 D3 Factor for R Chart x-bar Chart R Chart 1.20 1.2 Number of Observations in Subgroup Lower Control Limit D3 1.00 1 0.80 0.8 0 0 Factor for x-bar Chart A2 1.88 1.02 0.73 0.58 0.48 0.42 0.37 0.34 0.31 Upper Control Limit D4 3.27 2.57 2.28 2.11 2 1.92 1.86 0 0.60 0.6 In 7 on 00 o C 0 0.40 0.4 0 0.08 0.14 0.20 0.2 0.00 0 0.18 0.22 1.82 1.78 0 1 2 3 4 5 6 0 1 2 3 4 5 6 * Use the three blue lines to draw the lines of the upper control limit, lower control limit, X-double bar, and R-bar