A process at Printwright, Inc.'s largest facility is used to make plastic gears for a computer printer.
Question:
A process at Printwright, Inc.'s largest facility is used to make plastic gears for a computer printer. The data found in the worksheet Prob. 9-15 were gathered by a quality analyst. The gears were designed to be 3.57 ` 0.05 centimeters (cm) in diameter. Construct a histogram of the data. What can you observe about the shape of the distribution? What would you recommend to the production manager based on your analysis?
Problem 9-15 | ||||
Plastic Gear Data for Printwright, Inc. | ||||
3.52 | 3.55 | 3.55 | 3.55 | 3.63 |
3.58 | 3.55 | 3.63 | 3.55 | 3.55 |
3.49 | 3.50 | 3.52 | 3.56 | 3.53 |
3.53 | 3.57 | 3.58 | 3.49 | 3.61 |
3.52 | 3.58 | 3.62 | 3.52 | 3.52 |
3.50 | 3.58 | 3.63 | 3.52 | 3.52 |
3.51 | 3.58 | 3.55 | 3.58 | 3.55 |
3.54 | 3.52 | 3.63 | 3.58 | 3.61 |
3.54 | 3.55 | 3.61 | 3.58 | 3.61 |
3.57 | 3.53 | 3.63 | 3.57 | 3.61 |
3.57 | 3.53 | 3.62 | 3.57 | 3.54 |
3.62 | 3.53 | 3.64 | 3.57 | 3.54 |
3.62 | 3.53 | 3.65 | 3.57 | 3.55 |
3.62 | 3.53 | 3.62 | 3.54 | 3.61 |
3.53 | 3.53 | 3.54 | 3.51 | 3.54 |
3.56 | 3.57 | 3.56 | 3.58 | 3.60 |
3.56 | 3.57 | 3.56 | 3.58 | 3.60 |
3.56 | 3.57 | 3.56 | 3.59 | 3.60 |
3.56 | 3.57 | 3.56 | 3.59 | 3.60 |
3.57 | 3.57 | 3.56 | 3.59 | 3.60 |
3.57 | 3.57 | 3.56 | 3.59 | 3.60 |
3.57 | 3.57 | 3.56 | 3.59 | 3.60 |
3.57 | 3.57 | 3.62 | 3.59 | 3.60 |
3.57 | 3.57 | 3.54 | 3.59 | 3.60 |
3.57 | 3.58 | 3.62 | 3.59 | 3.60 |
3.57 | 3.58 | 3.62 | 3.59 | 3.61 |
3.57 | 3.58 | 3.64 | 3.60 | 3.52 |
3.57 | 3.58 | 3.62 | 3.60 | 3.52 |
3.57 | 3.58 | 3.51 | 3.60 | 3.52 |
3.57 | 3.58 | 3.55 | 3.55 | 3.52 |
6. The Cabo Fiesta Mexican Restaurant is trying to determine whether sales of its popular Pan Con Mucho Sabor breadsticks are correlated with the sales of margaritas. It has data on sales of bread- stick baskets and margaritas for 25 weeks, shown in the worksheet Prob. 9-20. Plot a scatter diagram and compute the correlation using Excel tools. What do your results indicate?
Problem 9-20 | ||
Cabo Fiesta Mexican Restaurant | ||
Breadsticks | ||
Week | Orders | Margaritas |
1 | 850 | 1340 |
2 | 860 | 1340 |
3 | 790 | 1300 |
4 | 860 | 1340 |
5 | 870 | 1370 |
6 | 790 | 1240 |
7 | 805 | 1285 |
8 | 790 | 1240 |
9 | 740 | 1170 |
10 | 720 | 1130 |
11 | 730 | 1150 |
12 | 685 | 1070 |
13 | 710 | 1150 |
14 | 740 | 1140 |
15 | 635 | 1030 |
16 | 660 | 990 |
17 | 720 | 1210 |
18 | 880 | 1370 |
19 | 880 | 1400 |
20 | 920 | 1370 |
21 | 930 | 1410 |
22 | 840 | 1240 |
23 | 830 | 1260 |
24 | 825 | 1235 |
25 | 790 | 1260 |