by using excel

Homework Production Line (A) 150.1 150.4 In a manufacturing plant we want to compare 2 production lines (A) and (B); 60 parts are taken from each line and the quality characteristic measured and recorded on the table. The design Specifications are : L = (150 = 0.5) mm 150.1 150.1 150.2 150.0 150.0 149.9 150.2 150.4 150.4 150.4 149.9 150.2 150.2 150.5 150.0 150.7 150.4 150.6 150.3 150.2 150.3 150.5 150.3 150.3 150.4 149.9 150.2 150.0 150.1 150.2 150.3 150.3 150.3 150.2 150.1 150.0 150.5 150.3 150.3 150.3 150.2 150.0 150.4 150.2 150.4 149.9 150.1 150.1 150.4 150.1 150.5 150.5 150.3 150.1 150.3 149.8 150.2 150.3 Production Line (B) 150.1 149.6 149.8 149.9 150.2 150.3 149.9 149.8 150.0 150.2 150.0 150.1 150.0 149.7 150.1 150.0 150.1 150.0 149.6 149.8 150.0 149.9 149.7 150.1 150.1 150.1 150.0 149.9 149.5 149.8 149.7 150.3 149.9 149.6 149.9 149.8 149.9 149.7 150.0 150.1 Make a comparison between the two production lines. Which one is better? And Why? If there is shift of the process, what can be the possible reasons for that? What recommendations would you make to the manufacturer? 149.9 149.5 150.0 149.7 150.0 149.9 149.9 150.0 150.2 150.0 149.9 149.4 149.8 150.2 149.8 150.2 149.4 149.8 149.7 149.6