Please Solve this Problem Using Excel Only, the Excel example is the second image.

S6.2 The overall average on a process you are attempting to monitor is 50 units. The process population standard deviation is 1.72. Determine the upper and lower control limits for a mean chart, if you choose to use a sample size of 5. PX a. Set z = 3. G H I J L M N A B C D E F 1 CHAPTER S6: Example S1 2 3 Quality Control x bar chart 4 Enter the population standard deviation then enter the data from each sample. Finally, you may change the 5 Number of samples 12 number of standard deviations 6 Sample size 9 9 Population standard 7 deviation 1 8 Data Results 9 Mean 10 Sample 1 16.1 x-bar value 16 11 Sample 2 16.8 & z value 3 12 Sample 3 15.5 Sigma x bar 0.33333333 13 Sample 4 16.5 14 Sample 5 16.5 Upper control limit 17 15 Sample 6 16.4 Center line 16 16 Sample 7 15.2 Lower control limit 15 17 Sample 8 16.4 18 Sample 9 16.3 19 Sample 10 14.81 Below LCL 20 Sample 11 14.2 Below LCL 21 Sample 12 17.3 Above UCL 20 22 Average 16 23 10 24 5 25 0 26 27 28 Graph Data La CL UCL 16.1 15 16 17 30 Sample 2 16.8 15 16 17 31 Sample 3 15.5 15 16 17 32 Sample 4 16.5 15 16 17 33 Sample 5 16.5 15 16 17 34 Sample 6 16.4 15 16 17 35 Sample 7 15.2 15 16 17 36 Sample 8 16.4 15 16 17 37 Sample 9 16.3 15 16 17 38 Sample 10 14.8 15 16 17 39 Sample 11 14.2 15 16 17 40 Sample 12 17.3 15 16 17 41 42 x-bar chart 15 Data LCL -CL 1 2 3 4 5 8 9 10 11 12 UCL 6 7 Sample Sample 29 Sample 1