1. 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)

2. 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.

3. 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?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 A B D E F G H J K Observation (each time data is collected) Product 1 2 3 4 5 6 7 8 9 10 1 53.8226 50.1904 50.8 52.832 54.9402 60.5536 54.6608 45.847 56.388 48.768 253.6956 53.8734 58.0136 48.514 50.1396 45.847 44.3992 48.006 54.356 52.324 3 57.912 55.753 49.9618 55.88 46.3296 53.6194 44.8818 51.7398 55.372 50.546 452.2732 49.784 54.3052 55.1434 54.6862 54.4068 46.3296 51.816 50.927 54.356 5 51.2064 52.8574 51.308 53.086 56.2864 44.8818 52.324 47.4218 57.404 57.4802 6 63.754 52.1462 53.34 46.736 58.674 47.244 53.848 60.0202 52.1462 55.1434 7| 49.3522 47.4218 54.2798 53.086 59.436 54.6862 56.2864 56.896 56.9468 59.944 8 48.387 58.42 54.864 52.324 57.6072 45.974 52.3748 51.6382 50.546 50.8 9 50.3174 58.0136 54.864 59.0804 51.8922 48.006 56.4134 60.6806 54.6608 49.784 10 52.324 47.752 52. 1462 52.324 54.864 49.9618 54.864 50.292 57.404 53.213 11 55.88 57.912 58.1406 56.007 54.864 56.5404 46.9392 54.1782 50.546 57.6834 12 55.2704 59.0804 58.166 52.324 53.8734 58.42 56.2356 56.2356 49.276 43.434 13 47.752 53.34 55.372 53.34 52.6034 60.1472 59.6138 54.9402 51.7652 56.2864 14 53.848 55.88 46.3296 44.3992 54.3052 47.7774 50.673 54. 1782 50.673 58.42 15 53.34 59.436 47.752 49.7078 58.42 55.753 52.6796 48.26 52.8574 57.3532 16 50.546 48.8696 52.832 51.2064 53.848 51.308 54.864 45.847 52.832 50.292 17 55.626 61.6204 54.1782 55.3466 55.88 58.0136 48.768 56.8198 53.34 49.7078 1849.6062 53.34 53.086 56.896 55.4736 55.372 54.6862 49.9618 55.88 50.8 19 55.2704 54. 1528 50.8 57.912 58.928 51.6382 45.974 50.292 48.006 58.928 20 62.1538 45.974 49.8348 44.3992 50.8 54.7878 51.8922 56.5404 56.896 51.6382 21 58.166 55.753 55.88 60.96 57.4802 55.372 58.547 58.166 52.2732 58.928 22 54.7878 51.1556 54.2798 50.292 54.864 57.6072 47.7774 51.0794 54.356 51.7398 23 53.34 56.5404 62.1538 53.34 53.34 52.2478 60.0202 63.754 43.434 55.372 24 51.7652 46.736 51.0794 60.1472 63.754 43.434 53.34 48.387 50.8 59.6138 25 62. 1538 46.228 55.753 56.007 47.752 53.34 55.2704 61.6204 51.308 52.2478 26 50.4444 50.4444 55.372 54.1528 45.974 44.3992 50.927 50.8 46.3296 49.784 27 51.308 60.5536 54.864 50.8 52.1208 62.1538 49.4792 49.784 54.6862 58.928 28 54.8132 55.753 52.832 52.1208 47.244 53.848 62.1538 51.2064 61.087 47.9044 29 57.0738 52.832 54.864 58.42 54.8132 54.2798 57.0738 49.3522 56.9468 46.3296 30 54.4068 60.0202 52.1208 59.4868 48.7426 48.768 51.816 49.6062 54.1528 47.752 31 50.673 55.88 50.292 56.2356 51.816 48.768 53.6956 54.356 51.8922 50.1396 32 49.7078 56.896 46.3296 53.848 53.086 50.8 59.0804 52.3748 50.8 57.3532 33 52.3748 54.356 58.0136 51.2826 53.34 63.754 56.896 43.9166 49.9618 56.388 34 49.8348 54.3052 50.546 52.832 59.944 51.816 49.2252 60.452 55.372 53.8226 35 56.8198 52. 1462 50.8 52.6796 47.7774 48.9966 52.2478 54.864 55.753 55.753 36 50.673 57.6834 55.88 54.1782 53.6194 49.784 60.452 48.7426 46.8122 49.0728 37 48.8696 44.3992 47.752 51.816 48.514 49.0728 63.2206 55.372 55.88 55.372 3849.3522 55.372 50.673 50.3174 54.864 56.9468 48.514 57.912 46.3296 55.2704 39 53.848 61.6204 57.0738 57.0738 53.848 46.228 58.547 60.0202 55.372 50.1904 4051.7398 50.8 52.832 50.1396 45.847 49.2252 47.5996 51.2064 45.0596 48.006 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42