Problem 9-14
Packman Shipping – Packing Times
Scatter Diagram
This spreadsheet is designed for up to 40 single values. Enter data ONLY in yellow-shaded cells.
Enter the number of values in cell E6. Then enter your data below. To recalculate the sheet, press F9 key.
If X-axis values differ from those shown, then substitute and clear unneeded ones.
Number of VALUES (<= 40) 40
Packer Number
12345 6 78910 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
Calculation of averages by group
Packer Time Packer Time
Number (minutes) Number (minutes)
116 21 15
210 22 23
311 23 18
413 24 20
512 25 17
614 26 16
717 27 18
813 28 17
916 29 22
0
20
25
30
Packer Number
Packman Shipping -Time by Packer