A manufacturer of hand lotion sells bottles of 100 ml. There are 2 machines used to fill the bottles. Fifty bottles are collected from each machine and the volume is measured. The excel data file is named Process Capability Data located in Data Sets in the content section of MyCourses. The lower specification limit for volume is 95 ml. It is recommended you use Minitab for this assignment. . (Hint: Use the Capability sixpack to answer both questions at once. Sigma level is calculated by hand or found in capability analysis.)

1. Prepare graphical summary and run/trend chart of each machine to determine whether the assumptions of normality and stability are satisfied. Comment on results.

2. Perform a capability analysis on each machine. The process has a lower limit of 95. Comment on the results. Are the machines capable? What sigma level?

1 2 Lower specification is 95 3 4 5 6 7 8 9 10 11 12 13 14 15 machine 2 100.6 103.5 104.7 103.0 102.4 100.6 102.2 95.3 99.6 100.6 101.7 102.3 104.1 104.1 102.3 101.9 102.9 104.1 102.8 100.1 99.8 102.8 102.8 102.5 103.3 102.4 98.5 98.6 104.4 16 17 18 19 20 21 machine 1 98.8 102.3 100.9 101.0 96.6 99.5 101.9 101.3 99.0 98.6 99.1 98.1 101.2 99.2 99.9 101.1 99.2 100.3 100.7 98.3 99.1 101.8 101.3 100.1 100.9 99.0 101.8 100.8 104.2 99.2 98.3 99.3 99.7 100.5 100.2 100.2 97.7 101.3 103.0 102.8 101.6 103.7 101.2 97.4 98.4 98.1 101.8 98.9 99.9 102.3 22 23 24 25 26 27 28 29 30 31 32 33 97.1 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 102.9 102.3 101.2 100.0 102.7 102.8 100.6 98.9 103.5 98.0 104.1 102.3 102.5 98.6 100.6 99.1 101.5 97.2 102.4 103.6 1 2 Lower specification is 95 3 4 5 6 7 8 9 10 11 12 13 14 15 machine 2 100.6 103.5 104.7 103.0 102.4 100.6 102.2 95.3 99.6 100.6 101.7 102.3 104.1 104.1 102.3 101.9 102.9 104.1 102.8 100.1 99.8 102.8 102.8 102.5 103.3 102.4 98.5 98.6 104.4 16 17 18 19 20 21 machine 1 98.8 102.3 100.9 101.0 96.6 99.5 101.9 101.3 99.0 98.6 99.1 98.1 101.2 99.2 99.9 101.1 99.2 100.3 100.7 98.3 99.1 101.8 101.3 100.1 100.9 99.0 101.8 100.8 104.2 99.2 98.3 99.3 99.7 100.5 100.2 100.2 97.7 101.3 103.0 102.8 101.6 103.7 101.2 97.4 98.4 98.1 101.8 98.9 99.9 102.3 22 23 24 25 26 27 28 29 30 31 32 33 97.1 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 102.9 102.3 101.2 100.0 102.7 102.8 100.6 98.9 103.5 98.0 104.1 102.3 102.5 98.6 100.6 99.1 101.5 97.2 102.4 103.6