1.

a. Upload your excel file with a completed R-bar and X-bar chart on a new tab. Make sure to show your intermediate steps (e.g., keep the calculations visible for your averages).

b. Should the operations team at Dan's Cat Empurrium be concerned with their current process? Why or why not? Support your claims by using the charts you created in the last question.

c. The company's product specifications state that their hammocks are guaranteed to be between 48.26 and 53.34 cm long.

Report the Cp and Cpk for Dan's cat hammock production. What current sigma level is their process at? What does this mean about the current process?

Length of each hammock is measure in cm. . 10 48.768 52.324 50.546 54.356 57.4802 55.1434 59.944 50.8 49.784 53.213 57.6834 43.434 56.2864 58.42 57.3532 46.9392 50.292 Product 53.8226 50.1904 2 53.6956 53.8734 3 57.912 55.753 4 52.2732 49.784 5 51.2064 52.8574 6 63.754 52.1462 749.3522 47.4218 8 48.387 58.42 9 50.3174 58.0136 10 52.324 47.752 11 55.88 57.912 1255.2704 59.0804 13 47.752 53.34 14 53.848 55.88 15 53.34 59.436 16 50.546 48.8696 17 55.626 61.6204 18 49.6062 53.34 1955.2704 54.1528 20 62.1538 45.974 21 58.166 55.753 22 54.7878 51.1556 23 53.34 56.5404 24 51.7652 46.736 25 62.1538 46.228 26 50.4444 50.4444 27 51.308 60.5536 2854.8132 55.753 29 57.0738 52.832 30 54.4065 60.020 31 50.673 55.88 32 49.7078 56.896 331 52.3748 54.356 34 49.8348 54.3052 35 56.8198 52.1462 36 50.673 57.6834 37 48.8696 443992 38 49.3522 55.372 39 53.848 61.6204 40 51.7398 50.8 50.8 58.0136 49.9618 54.3052 51.308 53.34 54.2798 54.864 54.864 52.1462 58.1406 58.166 55.372 46.3296 47.752 52.832 54.1782 53.086 50.8 49.8348 55.88 54.2798 62.1538 51.0794 55.753 55.372 54.864 52.832 54.864 52.1208 50.292 46.3296 58.0136 50.546 50.8 55.88 47.752 50.673 57.0738 52.832 52.832 54.9402 60.5536 54.6608 45.847 48.514 50.1396 45.847 44.3992 48.006 55.88 46.3296 53.6194 44.8818 51.7398 55.1434 54.6862 54.4068 46.3296 51.816 53.086 56.2864 44.8818 52.324 47.4218 46.736 58.674 47.244 53.848 60.0202 53.086 59.436 54.6862 56.2864 56.896 52.324 57.6072 45.974 52.3748 51.6382 59.0804 51.8922 48.006 56.4134 60.6806 52.324 54.864 49.9618 54.864 50.292 56.007 54.864 56.5404 54.1782 52.324 53.8734 58.42 56.2356 56.2356 53.34 52.6034 60.1472 59.6138 54.9402 44.3992 54.3052 47.7774 50.673 54.1782 49.7078 58.42 55.753 52.6796 48.26 51.2064 53.848 51.308 54.864 45.847 55.3466 55.88 58.0136 48.768 56.8198 56.896 55.4736 55.372 54.6862 49.9618 57.912 58.928 51.6382 45.974 50.292 44.3992 50.8 54.7878 51.8922 56.5404 60.96 57.4802 55.372 58.547 58.166 50.292 54.864 57.6072 47.7774 51.0794 53.34 53.34 52.2478 60.0202 63.754 60.1472 63.754 43.434 53.34 48.387 56.007 47.752 53.34 55.2704 61.6204 54.1528 45.974 44.3992 50.927 50.8 50.8 52.1208 62.1538 49.4792 49.784 52.1208 47.244 53.848 62.1538 51.2064 58.42 54.8132 54.2798 57.0738 49.3522 59.4868 48.7426 48.768 51816 49.6062 56.2356 51.816 48.768 53.6956 54.356 53.848 53.086 50.8 59.0804 52.3748 51.2826 53.34 63.754 56.896 43.9166 52.832 59.944 51.816 49.2252 60.452 52.6796 47.7774 48.9966 52.2478 54.864 54.1782 53.6194 49.784 60.452 48.7426 51.816 48.514 49.0728 63.2206 55.372 50.3174 54.864 56.9468 48.514 57.912 57.0738 53.848 46.228 58.547 60.0202 50.1396 45.847 49.2252 47.5996 51.2064 56.388 54.356 55.372 50.927 57.404 52.1462 56.9468 50.546 54.6608 57.404 50.545 49.276 51.7652 50.673 52.8574 52.832 53 34 55.88 48.006 56.896 52.2732 54.356 43.434 50.8 51.305 46.3296 54.6862 61.087 56.9468 54.152 51.8922 50.8 49.9618 55.372 55.753 46.8122 55.88 46.3296 55.372 45.0596 49.7078 50.8 58.928 51.6382 58.928 51.7398 55.372 59.6138 52.2478 49.784 58.928 47.9044 46.3296 47.752 50.1396 57.3532 56.388 53.8226 55.753 49.0728 55.372 55.2704 50.1904 48.006 Size of Sample (n) Factor for LCL for R-Chart (D3) 2 2 3 4 5 6 7 8 9 Factor for UCL and LCL for -Chart (A2) 1.88 1.023 0.729 0.577 0.483 0.419 0.373 0.337 0.308 0 0 0 0 0 0.076 0.136 0.184 0.223 Factor for UCL for R-Chart (D) 3.267 2.575 2.282 2.115 2.004 1.924 1.864 1.816 1.777 10 NOTE: These are for 3-siema limits. Just like critical values from statistics class, these will change if we chance our criteria 13 sismal