part 1 Search Sample size 12 Data for 60 samples (12 items in each sample) in pounds per item(weight) Talking: Item 1 4 7.271 64.314 60.983 54.887 45.167 59.861 66.769 63.545 72.742 61.964 57.978 55.177 78.059 58.014 61.907 55 273 69.041 65.736 60,02338.115 57.683 54229 59.29654.794 66121 61704 60 654 61 303 59.754 59 532 57551 58.380 49.631 72.178 57.11765.519 60.008 64.741 49.754 63.834 54.264 57.300 58.072 64.271 56.782 51.698 58.744 58.539 65.843 44.859 65.659 58.828 66.126 77.037 44.522 59.983 50.207 57.576 76.437 61.853 57.512 53.03 67.569 61.732 63.476 51.250 68.819 51.383 73.700 62.053 69.08360.601 55.960 65.839 54.290 49.754 57.244 48.875 71.533 49.770 54.597 51,369 65.241 72.951 45.025 59.049 50.446 53.77054.648 72.36364.375 68.860 57.919 61.692 62.061 58.292 70.136 69.422 57.145 52.815 73.816 79.016 48.513 97.353 62.355 75.802 75.545 58.343 35.821 50.845 59.428 58.567 81.100 69.433 0.829 64.636 54.19260.89371.809 51.42880.868 55 561 41.863 77.179 56.185 60 151 58.765 79.933 55.333 69.641 54.29259 017 72.923 56.837 60.869 61.911 53 301 59.099 47.485 71.606 61.563 60 204 25.853 64.437 13 14 62.819 51.529 63.540 71.958 61.775 74.609 65.882 79.677 61.535 52.464 47.413 79.287 81.652 68.742 33.609 68,651 73.092 42.112 74,384 64.927 77.0 47.950 56.6R281.692 15 49.904 76.356 65.928 45.144 42.203 9.643 60.980 57.258 51.195 51.843 $6.081 46.126 16 93.738 58.273 45.554 73.017 58.482 33.145 5386 60.890 45 615 50032 68 889 66 339 17 50.491 58.691 41.637 54.142 84.909 84.463 78.372 79.211 36.493 80.330 46.646 37 205 18 19 66.53855.473 55.69773.202 52.488 38.141 57.301 54.929 50.050 29.886 38.265 88.357 51.018 64.873 36.750 66.021 77.668 44.099 50.733 52.618 45.629 102.776 48.601 56.637 20 21 22 35.659 58.351 55.982 55.327 55.435 59.687 24.568 71.922 62,238 38.069 58.692 52.202 83.625 73.759 55.884 59.791 54.045 48.334 76.853 70.055 55.392 40.194 54.141 58.842 37.816 51.039 85267 34.947 48 699 64 752 55,85368841 49 290 61.532 6094559.827 23 65.024 53.283 65.490 63.465 58.361 55.149 61039 65.702 57 588 71 903 62 102 51001 Item 9 Item 10 Item 11 Item 12 part 2 Q Search 23 65.024 53.283 65.490 63.465 68.361 55.149 61.039 66.702 52.588 71.903 62.102 51.031 24 25 26 48.783 71.34277.659 65.276 62.020 57 297 69.458 46.292 65.698 49.507 59.459 59.179 61.878 55.027 69.630 64.922 71.29671.963 60.656 59.785 62.429 56.42056.643 68.536 52.716 58.140 73.202 54.446 70.811 57.125 47.675 60.153 65.845 42.837 66.224 55.652 27 28 29 68.653 45.59962.405 52.67561.239 73.971 75.761 66.198 68.774 56.600 50.301 56.563 62.263 63.615 56.110 66.990 75.549 42.831 62.73263,42976,057 51.420 66.058 68.400 56.523 62.65160.106 57.244 63.879 46.994 60.416 52.841 56.900 62.492 63.564 44.800 30 60.795 62.958 50.079 53.236 65.834 43.487 58.266 68.464 66.344 58.895 49.319 49.580 31 54.395 47.085 49.177 44.975 48.084 48.552 54.93951.802 43.71750.918 38.299 51.649 50 997 49.847 44.342 52.397 52.825 45.470 53.008 51.254 49.165 54.263 56.685 60.084 33 53.877 61.135 52.058 49.829 55.035 39.652 44.313 58.188 51.411 50.934 38.625 50.735 34 58.804 51.960 40.002 46.055 49.732 46.936 54,017 45.321 65.665 47.317 61.974 53.073 35 49.552 41.302 55.494 42.937 45.721 64.148 53 242 61.928 46.021 49.229 44.234 49.642 36 49.772 39.329 34.308 52.040 40.639 50.149 51.661 49.383 51.998 54.043 43.038 58.180 37 44.052 37.196 55.645 49.663 47.269 53.655 50.933 58.504 57.727 51.406 46.331 49.042 38 39 50.986 54.660 52.28634.251 42.271 61.451 44.531 52.857 56.30646.036 53.52147.884 45.955 49.030 53.898 47.509 55.509 50.939 42.38743.360 50.03344.006 47.64953.442 40 44.191 55 297 40.976 56.739 53.270 48.271 60.261 55.621 45.996 55.727 50.139 44.387 41 43 60.955 58.295 55.264 58.677 53.99567.036 58.468 69.956 62.065 50.789 51.342 63.099 51.93239.187 59.037 70.690 59.313 58.949 56.709 53.78051.976 63.175 56.876 46.397 46.399 61.807 55.069 50.229 61.947 56.321 52.814 65.811 51.816 65.467 55.753 80.440 44 45 46 66.82969.063 55.610 52.216 56.192 49.872 56.129 62.07551.544 55.930 64.463 48.631 69.275 61.540 54.139 51.509 67.832 66.456 66.449 60.570 23.348 67.825 63.653 58.830 65.780 65.254 63.918 55.864 54.958 45.527 54.658 64.38876.830 76.892 47.645 57.164 47 74.01 68.37 65.27 62.90 59.53 53.70 62.79 84.06 68.59 52.60 44.62 57.17 part 3 Q Search 43 55.264 67.036 62.065 63.099 59.037 58.949 51.976 46.397 55.069 56.321 51.816 44 45 66.82969.063 52.216 56.192 56.129 62.075 55.930 64.463 69.275 61.540 51.509 67.832 66.449 60.570 67.825 63.653 65.780 65.254 55.864 54.958 54.658 64.388 46 55.610 49.872 51.544 48.631 54.139 66.456 73.348 58.830 63.918 45.527 76.830 47 74.019 68.379 65.278 62.907 59.537 53.702 62.756 84.069 68.598 52.605 44.625 48 49 54.851 63.397 55.655 57.260 58.116 49.424 53.69158.739 52.81236.250 58.956 62.283 62.171 59.707 50.921 65.430 70.41470.762 62.326 60.449 58.142 68.925 50 57.529 47.779 56.976 53.959 58.590 69.005 58.094 50.271 60.458 53.650 64.983 51 58.551 70.462 70.015 83.915 60.203 86.186 74.659 64.087 73.404 63.551 79.862 52 71.683 71.085 67.825 82.873 61.860 71.170 72.443 76.225 71.177 66.612 80.427 53 54 55 64.550 86.888 101.367 63.825 62.300 82.792 63.68762.694 67.599 59.762 78.880 51.065 69.70581.564 58.249 68.090 59.645 62.818 70.026 65.950 56.139 50.240 78.522 58.579 76.186 80.430 72.804 80.320 76.256 66.193 72.804 61.31772.450 56 73.377 98.856 63.234 88.013 66.943 74.184 77.494 79.549 53.938 67.205 63.179 57 58 66.571 87.660 71.813 83.909 65.85171.944 67.262 86.630 69.583 68.802 67.572 67.584 66.154 51.721 62.540 67.796 79.974 78.115 89.079 70.765 63.486 61.022 59 61.643 59.693 75.767 72.915 67.987 66.693 60.144 70.469 70.426 63.549 70.085 60 73.949 75.669 57.297 69.557 63.408 58.871 69.251 65.744 71.999 67.564 79.747 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 guideline: Only present control charts and mini tables. Points will be deducted if you print out full table. Charts must have titles and labels. Numbers in mini tables must show 3 decimal places. (a)[5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 45; Max = 75; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (not full table). Give interpretations of the chart. X-2bar (value & unit) SD(all parts) (value & unit) TABLE 22.1 SE(Xbar) (value & unit) (mini table) 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 mini table (not full table). Give interpretations of the chart. R-bar (value & unit) D4 (value) TABLE 22.2 D3 (value) (mini table) UCL-R (equation, value & unit) LCL-R (equation, value & unit) part 1 Search Sample size 12 Data for 60 samples (12 items in each sample) in pounds per item(weight) Talking: Item 1 4 7.271 64.314 60.983 54.887 45.167 59.861 66.769 63.545 72.742 61.964 57.978 55.177 78.059 58.014 61.907 55 273 69.041 65.736 60,02338.115 57.683 54229 59.29654.794 66121 61704 60 654 61 303 59.754 59 532 57551 58.380 49.631 72.178 57.11765.519 60.008 64.741 49.754 63.834 54.264 57.300 58.072 64.271 56.782 51.698 58.744 58.539 65.843 44.859 65.659 58.828 66.126 77.037 44.522 59.983 50.207 57.576 76.437 61.853 57.512 53.03 67.569 61.732 63.476 51.250 68.819 51.383 73.700 62.053 69.08360.601 55.960 65.839 54.290 49.754 57.244 48.875 71.533 49.770 54.597 51,369 65.241 72.951 45.025 59.049 50.446 53.77054.648 72.36364.375 68.860 57.919 61.692 62.061 58.292 70.136 69.422 57.145 52.815 73.816 79.016 48.513 97.353 62.355 75.802 75.545 58.343 35.821 50.845 59.428 58.567 81.100 69.433 0.829 64.636 54.19260.89371.809 51.42880.868 55 561 41.863 77.179 56.185 60 151 58.765 79.933 55.333 69.641 54.29259 017 72.923 56.837 60.869 61.911 53 301 59.099 47.485 71.606 61.563 60 204 25.853 64.437 13 14 62.819 51.529 63.540 71.958 61.775 74.609 65.882 79.677 61.535 52.464 47.413 79.287 81.652 68.742 33.609 68,651 73.092 42.112 74,384 64.927 77.0 47.950 56.6R281.692 15 49.904 76.356 65.928 45.144 42.203 9.643 60.980 57.258 51.195 51.843 $6.081 46.126 16 93.738 58.273 45.554 73.017 58.482 33.145 5386 60.890 45 615 50032 68 889 66 339 17 50.491 58.691 41.637 54.142 84.909 84.463 78.372 79.211 36.493 80.330 46.646 37 205 18 19 66.53855.473 55.69773.202 52.488 38.141 57.301 54.929 50.050 29.886 38.265 88.357 51.018 64.873 36.750 66.021 77.668 44.099 50.733 52.618 45.629 102.776 48.601 56.637 20 21 22 35.659 58.351 55.982 55.327 55.435 59.687 24.568 71.922 62,238 38.069 58.692 52.202 83.625 73.759 55.884 59.791 54.045 48.334 76.853 70.055 55.392 40.194 54.141 58.842 37.816 51.039 85267 34.947 48 699 64 752 55,85368841 49 290 61.532 6094559.827 23 65.024 53.283 65.490 63.465 58.361 55.149 61039 65.702 57 588 71 903 62 102 51001 Item 9 Item 10 Item 11 Item 12 part 2 Q Search 23 65.024 53.283 65.490 63.465 68.361 55.149 61.039 66.702 52.588 71.903 62.102 51.031 24 25 26 48.783 71.34277.659 65.276 62.020 57 297 69.458 46.292 65.698 49.507 59.459 59.179 61.878 55.027 69.630 64.922 71.29671.963 60.656 59.785 62.429 56.42056.643 68.536 52.716 58.140 73.202 54.446 70.811 57.125 47.675 60.153 65.845 42.837 66.224 55.652 27 28 29 68.653 45.59962.405 52.67561.239 73.971 75.761 66.198 68.774 56.600 50.301 56.563 62.263 63.615 56.110 66.990 75.549 42.831 62.73263,42976,057 51.420 66.058 68.400 56.523 62.65160.106 57.244 63.879 46.994 60.416 52.841 56.900 62.492 63.564 44.800 30 60.795 62.958 50.079 53.236 65.834 43.487 58.266 68.464 66.344 58.895 49.319 49.580 31 54.395 47.085 49.177 44.975 48.084 48.552 54.93951.802 43.71750.918 38.299 51.649 50 997 49.847 44.342 52.397 52.825 45.470 53.008 51.254 49.165 54.263 56.685 60.084 33 53.877 61.135 52.058 49.829 55.035 39.652 44.313 58.188 51.411 50.934 38.625 50.735 34 58.804 51.960 40.002 46.055 49.732 46.936 54,017 45.321 65.665 47.317 61.974 53.073 35 49.552 41.302 55.494 42.937 45.721 64.148 53 242 61.928 46.021 49.229 44.234 49.642 36 49.772 39.329 34.308 52.040 40.639 50.149 51.661 49.383 51.998 54.043 43.038 58.180 37 44.052 37.196 55.645 49.663 47.269 53.655 50.933 58.504 57.727 51.406 46.331 49.042 38 39 50.986 54.660 52.28634.251 42.271 61.451 44.531 52.857 56.30646.036 53.52147.884 45.955 49.030 53.898 47.509 55.509 50.939 42.38743.360 50.03344.006 47.64953.442 40 44.191 55 297 40.976 56.739 53.270 48.271 60.261 55.621 45.996 55.727 50.139 44.387 41 43 60.955 58.295 55.264 58.677 53.99567.036 58.468 69.956 62.065 50.789 51.342 63.099 51.93239.187 59.037 70.690 59.313 58.949 56.709 53.78051.976 63.175 56.876 46.397 46.399 61.807 55.069 50.229 61.947 56.321 52.814 65.811 51.816 65.467 55.753 80.440 44 45 46 66.82969.063 55.610 52.216 56.192 49.872 56.129 62.07551.544 55.930 64.463 48.631 69.275 61.540 54.139 51.509 67.832 66.456 66.449 60.570 23.348 67.825 63.653 58.830 65.780 65.254 63.918 55.864 54.958 45.527 54.658 64.38876.830 76.892 47.645 57.164 47 74.01 68.37 65.27 62.90 59.53 53.70 62.79 84.06 68.59 52.60 44.62 57.17 part 3 Q Search 43 55.264 67.036 62.065 63.099 59.037 58.949 51.976 46.397 55.069 56.321 51.816 44 45 66.82969.063 52.216 56.192 56.129 62.075 55.930 64.463 69.275 61.540 51.509 67.832 66.449 60.570 67.825 63.653 65.780 65.254 55.864 54.958 54.658 64.388 46 55.610 49.872 51.544 48.631 54.139 66.456 73.348 58.830 63.918 45.527 76.830 47 74.019 68.379 65.278 62.907 59.537 53.702 62.756 84.069 68.598 52.605 44.625 48 49 54.851 63.397 55.655 57.260 58.116 49.424 53.69158.739 52.81236.250 58.956 62.283 62.171 59.707 50.921 65.430 70.41470.762 62.326 60.449 58.142 68.925 50 57.529 47.779 56.976 53.959 58.590 69.005 58.094 50.271 60.458 53.650 64.983 51 58.551 70.462 70.015 83.915 60.203 86.186 74.659 64.087 73.404 63.551 79.862 52 71.683 71.085 67.825 82.873 61.860 71.170 72.443 76.225 71.177 66.612 80.427 53 54 55 64.550 86.888 101.367 63.825 62.300 82.792 63.68762.694 67.599 59.762 78.880 51.065 69.70581.564 58.249 68.090 59.645 62.818 70.026 65.950 56.139 50.240 78.522 58.579 76.186 80.430 72.804 80.320 76.256 66.193 72.804 61.31772.450 56 73.377 98.856 63.234 88.013 66.943 74.184 77.494 79.549 53.938 67.205 63.179 57 58 66.571 87.660 71.813 83.909 65.85171.944 67.262 86.630 69.583 68.802 67.572 67.584 66.154 51.721 62.540 67.796 79.974 78.115 89.079 70.765 63.486 61.022 59 61.643 59.693 75.767 72.915 67.987 66.693 60.144 70.469 70.426 63.549 70.085 60 73.949 75.669 57.297 69.557 63.408 58.871 69.251 65.744 71.999 67.564 79.747 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 guideline: Only present control charts and mini tables. Points will be deducted if you print out full table. Charts must have titles and labels. Numbers in mini tables must show 3 decimal places. (a)[5] You need to print out one Xbar-chart. The Xbar-chart should have the vertical axis format as: Min = 45; Max = 75; and Major Unit = 5. The horizontal axis has 60 points. Besides the chart, present the following mini table (not full table). Give interpretations of the chart. X-2bar (value & unit) SD(all parts) (value & unit) TABLE 22.1 SE(Xbar) (value & unit) (mini table) 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 mini table (not full table). Give interpretations of the chart. R-bar (value & unit) D4 (value) TABLE 22.2 D3 (value) (mini table) UCL-R (equation, value & unit) LCL-R (equation, value & unit)