plz show work I will like the post

QUESTION 22 (10 points) - Xbar-Charts & R-Charts Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guidelines: Background, equations, lookups and Excel examples are in Module 05 - Quality Management. Charts must have titles, labels, and clear presentation of different lines. (a)(5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 35; Max = 70; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you print out full data). Give Interpretations of the chart results: the process is in control or out of control, and why. Table 22.1 (show only first 2 columns) X-2bar (value & unit) SD(all parts) (value & unit) SE(Xbar) (value & unit) UCL-Xbar (equation, value & unit) LCL-Xbar (equation, value & unit) (b)[5] You need to print out one R-chart. The R-chart should have the vertical axis format as: Min=0; Max - 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following midi table (points will be deducted if you print out full data). Give Interpretations of the chart results: the process is in control or out of control, and why. Table 22.2 (show.only first 2 columns) R-bar (value & unit) (value) (value) (equation value & unit) LCLER (equation value & unit) D4 D3 UGLER Question 22: Sample Data for both R-Chart and Xbar-Chart M N O Q Sample size o Samples (6) 12 60 Data for 50 samples (12 items in each sample) in pounds per item weight) Sample 1 2 4 9 10 12 13 14 15 16 17 Item 1 38.612 57.933 42.010 40.634 55,625 60.897 57.429 55.015 45.660 51.807 22.892 69.654 26.224 72.979 28.184 36.927 32.960 5 Item 2 54.906 59.584 43.611 56.543 36.565 54.925 50.925 47.852 56.056 62.165 35.839 48.004 84.924 58.080 41.354 65,034 36.321 6 Item 3 56.664 61.132 55.098 46.677 35.796 59.424 54.181 43.438 45.503 45.137 40.335 42.498 60.010 36.236 28.915 68.193 56.478 62 Item 4 36.262 57.642 57.751 43.800 60.272 55.882 53.109 47310 41.424 49.912 48.479 49.264 50.522 58.457 32.116 64.882 45.420 SO Items 51.312 27.928 41.168 55.404 46.451 48.862 53.656 47.291 44.938 55.425 60.291 28.970 53.205 25.012 53.084 44.733 63.420 18. Item 6 29.151 58.782 52.449 45.100 45.787 51.367 46.184 35.860 51.429 51.425 45.163 37.195 58.316 50.171 35.815 55.752 66.926 60. tem? 43513 52.039 46.961 45.360 51.028 44.582 39.378 58.815 56.835 44.156 63 380 19 359 24.550 86.790 32.668 42.879 68.410 41. Item B 53.386 46.932 48.771 63,541 59.711 53.812 60.726 54.213 49.568 50.069 27.745 75.943 79.993 40.347 27.619 50.757 26.374 81. Item 9 48.587 61.210 46.377 62.50 54.759 51.887 50.084 43.142 48.148 54.858 41.231 52.452 47.041 74.451 36.821 32.895 35.862 59. Item 10 62.155 43.031 41.765 49.856 39.287 19.106 45.236 36.052 53.072 60.854 42.431 42.104 42.359 80.208 55.233 45.905 51.828 63.432 50.873 50.555 41.214 53 22 33.8 49.406 42.095 48.256 32.414 52.902 51.350 48.015 65.152 61.910 64.814 35.635 52.980 Item 12 49.483 46.405 54.954 39.206 48.354 47.442 55.078 44.675 50 128 31.862 31.053 69.184 49.159 46.367 62.699 59.011 53.003 32.70 DATA v w Z AA AS AC AD AE AF AG 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 39 28.184 36.927 32.960 53.611 51.448 36,069 34.782 48.788 51.416 33.846 57.748 46.134 47.472 48.357 59.800 46.647 29.120 35.242 30.03 41.354 65.034 36.321 62.006 59.793 23.513 62.265 44,015 57688 59.046 59.042 69.638 46.668 48.646 49.105 59.199 69.295 32.417 52.17 28.915 68.193 56.478 63.598 62.607 43.068 48.851 60.005 53.527 53.288 40.451 58.271 54.424 46.653 42.080 37.780 75.346 39.922 46.95 32.116 64.882 45.420 50.409 9.494 50.583 44.843 48.069 62.408 48.191 46,095 50.667 65.429 43.334 56.987 56.296 34.651 48.117 43.187 53.084 44.733 63.420 18.854 48.891 40.396 62.525 46.140 59.242 28.962 40.290 33.751 63.857 51.380 55.089 62.190 65.413 55.487 64.941 35.815 55.752 66.926 60.710 35.997 63.12152.210 40.892 48.756 66,043 44,073 50.210 40.568 55.420 50.810 48.879 39,718 64.665 75.346 32.668 42.879 68.410 41.713 28.900 34,721 48.773 44.997 37.456 44,395 47.290 47.710 47.286 40.538 58.712 61.815 41,068 39.107 42. 201 27.619 50.757 26,374 81.720 $4.774 96.092 49.15845.605 43.146 56.794 61.601 50.362 64.633 39.856 45.842 44.103 66. 103 63.162 45,735 36.821 32.895 35.862 59.292 69.623 40.740 46.187 51.636 45.642 61.359 18.030 47.260 44.184 62.521 52.714 47.228 41.579 79.880 55.233 45.905 51.828 33.852 45.543 43.123 $0.046 46.991 54.592 44.446 43.407 32,558 37.033 47.946 60.161 50.695 48.032 38.084 40.036 64.814 35.635 52.980 47.427 70.120 48.762 49.576 57.071 52.714 44.934 61.979 43.580 39.956 65.152 35 614 48.716 54.783 40.740 57.013 62.699 59,011 53.003 32.707 40.198 27.642 42.857 47.405 41.523 48.20852.559 41.938 59.954 52.850 13.124 53.474 39.674 51 195 21.309 4 AE AF AH AL w AK AL AM AN AO AP AG AR AS AT AU AV AW 30 21 32 33 34 3S 36 32 19 39 40 41 43 44 45 46 47 0046.6AZ 29.120 35.242 30.030 42.790 | 54.974 42.625 53.457 19.733 50.877 50.147 35.651 46.982 52.842 35.577 54.216 56.215 59.393 47.160 54 05 59.199 69.295 32.417 52,177 37.626 58.048 57.292 53.665 51.729 37.806 35.721 51.631 46.556 43.439 55.708 47.422 56.539 69.979 58.429 58 180 37,780 75.346 39.922 46.952 44.680 44.858 87.670 41.733 38.139 42.279 54.255 64.435 43.748 58.989 51.429 46.313 50.218 38.886 37.485 44 R7 56.295 34.651 48,117 43.182 89.055 27.749 37.139 45.236 47.750 40.355 13.313 49.890 47.195 50.516 48.312 37.423 46.704 61.764 42.864 58 08962.190 65.413 55.48764.4162.467 67.980 53.66H45.715 65.167 39.096 52.156 62.565 41.269 46.902 32,026 50.986 52.856 33.755 41.831 510 10 48.879 39.718 64.665 75.346 32.313 48.759 48.926 60.386 57.497 44.685 26.736 56.957 59.581 51.617 47.783 55.138 48.542 48.531 62.206 45.5 717 GL81541.06839.107 42.201 50.10055.37 29.319 63.283 73.289 63.097 30.457 57.170 50.039 52.773 34 345 58.689 54.394 49.767 50.385 57.0 842 44 103 66.103 63.16245,735 20.695 68.821 41.819 68.029 78.450 72.969 10.313 52.881 57.525 43.677 55.528 59.879 39.308 50.434 38.998 214 47.22841.579 29.880 42.482 $7,499 45.653 40.448 66.235 33.802 56.425 68.920 48.862 48.278 58.738 47.193 36.315 57.319 48.935 64.243 161 50.695 6.032 BHOB 40.036 24.908 46.378 42.82358 323 54.266 34.607 61.80 28.530 58.235 67.115 49.320 52.821 60.846 45.382 48.131 47.679 54.44 614 48.716 1 54.785 40.740 57.013 50.184 28.237 42.520 47.955 61.777 $4,427 47.002 58.875 46.404 49.574 56.248 32.183 40.845 42.779 39.674 51.195 21.309 1124 63.474 14.452 50.855 56.258 63128 59.858 49.40 34. 109 45.116 25476 59.033 51.868 49.205 53.252 49.096 52.979 59.542 39.932 50.1 31.941 10 43 44 45 46 47 49 49 50 51 52 58 55 56 57 58 59 52 52.842 35.577 54.216 56.215 59.393 47.160 54.134 50.306 46,371 60 38.726 55.17564.718 65.779 75.398 61.560 60.400 68.906 55.544 56 43.439 55.708 47.422 56.539 69.979 58.429 58.979 51.826 55.179 35.992 56,675 53.225 56.245 57.716 69.973 48.503 73.750 81.461 18 58.989 51.429 46.313 50.218 38.886 37.485 44.679 43.533 70.276 57.011 72.476 41.648 42.189 74.716 60.642 59.083 55.969 60.127 95 50.516 48.312 37.423 46.704 61.764 42.864 58.232 50.955 59.209 50.622 76.138 58.201 64.668 43.595 58.057 67.720 88.759 69.947 69 46.902 32.026 50.886 52.856 33.755 41.831 51.641 46.918 52.829 61.091 69.859 65.142 52.822 66.614 72.885 64.375 55.019 48.210 -81 51.617 47.783 55.138 48.542 48.531 62.206 45.564 59.231 55.103 74.232 70.311 55.353 46.169 78.142 51.378 53.001 55.236 64.345 39 52.773 34.345 58.689 54,394 49.767 50.38557.010 57.001 65.161 58.299 43.491 56.358 61.747 50.852 49.405 67.121 50.572 53.841 525 43.677 55.528 59.879 39.308 50.434 38 998 50.121 47.533 49.301 46.456 73.043 76.518 59.176 39.652 55.569 50.096 73.193 73.835 278 58.738 47.193 36.315 57.319 48.935 64.243 61.800 59.131 66.107 60.268 67,090 79.301 65.559 46.205 61.904 64.192 41.602 61.856 115 49.320 52.821 60.846 45.382 48.131 47.679 54.441 49.621 20.700 51.739 55.189 67.965 64.855 56.414 67.650 43.644 63.086 55.637 404 49.574 56.248 32.183 40.845 42.79 59.858 48.407 50.003 64.414 61 212 69.027 43.006 61.194 48.169 66.647 62.514 43.019 61.292 _868 49.205 53.252 49.096 31.941 52.979 59.542 39.938 39.148 58.712 50.238 55.182 73.240 64.911 47.448 67.633 72.362 77,239 62.903 QUESTION 22 (10 points) - Xbar-Charts & R-Charts Based on a data sample in file "TOM3010_OM_HW3_Question22_Data.xlsx", you need to construct one Xbar-chart and one R-chart with the following guidelines: Background, equations, lookups and Excel examples are in Module 05 - Quality Management. Charts must have titles, labels, and clear presentation of different lines. (a)(5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 35; Max = 70; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (points will be deducted if you print out full data). Give Interpretations of the chart results: the process is in control or out of control, and why. Table 22.1 (show only first 2 columns) X-2bar (value & unit) SD(all parts) (value & unit) SE(Xbar) (value & unit) UCL-Xbar (equation, value & unit) LCL-Xbar (equation, value & unit) (b)[5] You need to print out one R-chart. The R-chart should have the vertical axis format as: Min=0; Max - 80; and Major Unit = 10. The horizontal axis has 60 points. Besides the chart, present the following midi table (points will be deducted if you print out full data). Give Interpretations of the chart results: the process is in control or out of control, and why. Table 22.2 (show.only first 2 columns) R-bar (value & unit) (value) (value) (equation value & unit) LCLER (equation value & unit) D4 D3 UGLER Question 22: Sample Data for both R-Chart and Xbar-Chart M N O Q Sample size o Samples (6) 12 60 Data for 50 samples (12 items in each sample) in pounds per item weight) Sample 1 2 4 9 10 12 13 14 15 16 17 Item 1 38.612 57.933 42.010 40.634 55,625 60.897 57.429 55.015 45.660 51.807 22.892 69.654 26.224 72.979 28.184 36.927 32.960 5 Item 2 54.906 59.584 43.611 56.543 36.565 54.925 50.925 47.852 56.056 62.165 35.839 48.004 84.924 58.080 41.354 65,034 36.321 6 Item 3 56.664 61.132 55.098 46.677 35.796 59.424 54.181 43.438 45.503 45.137 40.335 42.498 60.010 36.236 28.915 68.193 56.478 62 Item 4 36.262 57.642 57.751 43.800 60.272 55.882 53.109 47310 41.424 49.912 48.479 49.264 50.522 58.457 32.116 64.882 45.420 SO Items 51.312 27.928 41.168 55.404 46.451 48.862 53.656 47.291 44.938 55.425 60.291 28.970 53.205 25.012 53.084 44.733 63.420 18. Item 6 29.151 58.782 52.449 45.100 45.787 51.367 46.184 35.860 51.429 51.425 45.163 37.195 58.316 50.171 35.815 55.752 66.926 60. tem? 43513 52.039 46.961 45.360 51.028 44.582 39.378 58.815 56.835 44.156 63 380 19 359 24.550 86.790 32.668 42.879 68.410 41. Item B 53.386 46.932 48.771 63,541 59.711 53.812 60.726 54.213 49.568 50.069 27.745 75.943 79.993 40.347 27.619 50.757 26.374 81. Item 9 48.587 61.210 46.377 62.50 54.759 51.887 50.084 43.142 48.148 54.858 41.231 52.452 47.041 74.451 36.821 32.895 35.862 59. Item 10 62.155 43.031 41.765 49.856 39.287 19.106 45.236 36.052 53.072 60.854 42.431 42.104 42.359 80.208 55.233 45.905 51.828 63.432 50.873 50.555 41.214 53 22 33.8 49.406 42.095 48.256 32.414 52.902 51.350 48.015 65.152 61.910 64.814 35.635 52.980 Item 12 49.483 46.405 54.954 39.206 48.354 47.442 55.078 44.675 50 128 31.862 31.053 69.184 49.159 46.367 62.699 59.011 53.003 32.70 DATA v w Z AA AS AC AD AE AF AG 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 39 28.184 36.927 32.960 53.611 51.448 36,069 34.782 48.788 51.416 33.846 57.748 46.134 47.472 48.357 59.800 46.647 29.120 35.242 30.03 41.354 65.034 36.321 62.006 59.793 23.513 62.265 44,015 57688 59.046 59.042 69.638 46.668 48.646 49.105 59.199 69.295 32.417 52.17 28.915 68.193 56.478 63.598 62.607 43.068 48.851 60.005 53.527 53.288 40.451 58.271 54.424 46.653 42.080 37.780 75.346 39.922 46.95 32.116 64.882 45.420 50.409 9.494 50.583 44.843 48.069 62.408 48.191 46,095 50.667 65.429 43.334 56.987 56.296 34.651 48.117 43.187 53.084 44.733 63.420 18.854 48.891 40.396 62.525 46.140 59.242 28.962 40.290 33.751 63.857 51.380 55.089 62.190 65.413 55.487 64.941 35.815 55.752 66.926 60.710 35.997 63.12152.210 40.892 48.756 66,043 44,073 50.210 40.568 55.420 50.810 48.879 39,718 64.665 75.346 32.668 42.879 68.410 41.713 28.900 34,721 48.773 44.997 37.456 44,395 47.290 47.710 47.286 40.538 58.712 61.815 41,068 39.107 42. 201 27.619 50.757 26,374 81.720 $4.774 96.092 49.15845.605 43.146 56.794 61.601 50.362 64.633 39.856 45.842 44.103 66. 103 63.162 45,735 36.821 32.895 35.862 59.292 69.623 40.740 46.187 51.636 45.642 61.359 18.030 47.260 44.184 62.521 52.714 47.228 41.579 79.880 55.233 45.905 51.828 33.852 45.543 43.123 $0.046 46.991 54.592 44.446 43.407 32,558 37.033 47.946 60.161 50.695 48.032 38.084 40.036 64.814 35.635 52.980 47.427 70.120 48.762 49.576 57.071 52.714 44.934 61.979 43.580 39.956 65.152 35 614 48.716 54.783 40.740 57.013 62.699 59,011 53.003 32.707 40.198 27.642 42.857 47.405 41.523 48.20852.559 41.938 59.954 52.850 13.124 53.474 39.674 51 195 21.309 4 AE AF AH AL w AK AL AM AN AO AP AG AR AS AT AU AV AW 30 21 32 33 34 3S 36 32 19 39 40 41 43 44 45 46 47 0046.6AZ 29.120 35.242 30.030 42.790 | 54.974 42.625 53.457 19.733 50.877 50.147 35.651 46.982 52.842 35.577 54.216 56.215 59.393 47.160 54 05 59.199 69.295 32.417 52,177 37.626 58.048 57.292 53.665 51.729 37.806 35.721 51.631 46.556 43.439 55.708 47.422 56.539 69.979 58.429 58 180 37,780 75.346 39.922 46.952 44.680 44.858 87.670 41.733 38.139 42.279 54.255 64.435 43.748 58.989 51.429 46.313 50.218 38.886 37.485 44 R7 56.295 34.651 48,117 43.182 89.055 27.749 37.139 45.236 47.750 40.355 13.313 49.890 47.195 50.516 48.312 37.423 46.704 61.764 42.864 58 08962.190 65.413 55.48764.4162.467 67.980 53.66H45.715 65.167 39.096 52.156 62.565 41.269 46.902 32,026 50.986 52.856 33.755 41.831 510 10 48.879 39.718 64.665 75.346 32.313 48.759 48.926 60.386 57.497 44.685 26.736 56.957 59.581 51.617 47.783 55.138 48.542 48.531 62.206 45.5 717 GL81541.06839.107 42.201 50.10055.37 29.319 63.283 73.289 63.097 30.457 57.170 50.039 52.773 34 345 58.689 54.394 49.767 50.385 57.0 842 44 103 66.103 63.16245,735 20.695 68.821 41.819 68.029 78.450 72.969 10.313 52.881 57.525 43.677 55.528 59.879 39.308 50.434 38.998 214 47.22841.579 29.880 42.482 $7,499 45.653 40.448 66.235 33.802 56.425 68.920 48.862 48.278 58.738 47.193 36.315 57.319 48.935 64.243 161 50.695 6.032 BHOB 40.036 24.908 46.378 42.82358 323 54.266 34.607 61.80 28.530 58.235 67.115 49.320 52.821 60.846 45.382 48.131 47.679 54.44 614 48.716 1 54.785 40.740 57.013 50.184 28.237 42.520 47.955 61.777 $4,427 47.002 58.875 46.404 49.574 56.248 32.183 40.845 42.779 39.674 51.195 21.309 1124 63.474 14.452 50.855 56.258 63128 59.858 49.40 34. 109 45.116 25476 59.033 51.868 49.205 53.252 49.096 52.979 59.542 39.932 50.1 31.941 10 43 44 45 46 47 49 49 50 51 52 58 55 56 57 58 59 52 52.842 35.577 54.216 56.215 59.393 47.160 54.134 50.306 46,371 60 38.726 55.17564.718 65.779 75.398 61.560 60.400 68.906 55.544 56 43.439 55.708 47.422 56.539 69.979 58.429 58.979 51.826 55.179 35.992 56,675 53.225 56.245 57.716 69.973 48.503 73.750 81.461 18 58.989 51.429 46.313 50.218 38.886 37.485 44.679 43.533 70.276 57.011 72.476 41.648 42.189 74.716 60.642 59.083 55.969 60.127 95 50.516 48.312 37.423 46.704 61.764 42.864 58.232 50.955 59.209 50.622 76.138 58.201 64.668 43.595 58.057 67.720 88.759 69.947 69 46.902 32.026 50.886 52.856 33.755 41.831 51.641 46.918 52.829 61.091 69.859 65.142 52.822 66.614 72.885 64.375 55.019 48.210 -81 51.617 47.783 55.138 48.542 48.531 62.206 45.564 59.231 55.103 74.232 70.311 55.353 46.169 78.142 51.378 53.001 55.236 64.345 39 52.773 34.345 58.689 54,394 49.767 50.38557.010 57.001 65.161 58.299 43.491 56.358 61.747 50.852 49.405 67.121 50.572 53.841 525 43.677 55.528 59.879 39.308 50.434 38 998 50.121 47.533 49.301 46.456 73.043 76.518 59.176 39.652 55.569 50.096 73.193 73.835 278 58.738 47.193 36.315 57.319 48.935 64.243 61.800 59.131 66.107 60.268 67,090 79.301 65.559 46.205 61.904 64.192 41.602 61.856 115 49.320 52.821 60.846 45.382 48.131 47.679 54.441 49.621 20.700 51.739 55.189 67.965 64.855 56.414 67.650 43.644 63.086 55.637 404 49.574 56.248 32.183 40.845 42.79 59.858 48.407 50.003 64.414 61 212 69.027 43.006 61.194 48.169 66.647 62.514 43.019 61.292 _868 49.205 53.252 49.096 31.941 52.979 59.542 39.938 39.148 58.712 50.238 55.182 73.240 64.911 47.448 67.633 72.362 77,239 62.903