help with chapter Unit 3: Assignment

profileDEE9175
Prob09-14unit3assignmentP14.xlsx

Input Data

Problem 9-14
Packman Shipping - Packing Times 1. Copy "Time" columns into yellow rows below (packer # coincides with row number)
2. Enter number of packers into cell E6
Scatter Diagram
Number of VALUES (<= 40)
Packer Number 1 2 3 4 5 6 7 8 9 10 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
Time (Min.)
Center ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Calculation of averages by group Chart will self-populate and format
Packer Time Packer Time
Number (minutes) Number (minutes)
1 16 21 15
2 10 22 23
3 11 23 18
4 13 24 20
5 12 25 17
6 14 26 16
7 17 27 18
8 13 28 17
9 16 29 22
10 9 30 13
11 12 31 13
12 16 32 19
13 17 33 19
14 14 34 16
15 18 35 17
16 14 36 20
17 16 37 24
18 12 38 22
19 13 39 21 Answer question from problem below
20 15 40 19
Packer Grp. Avgs. 13.9 18.45

Packman Shipping -Time by Packer

Times 1 2 3 4 5 6 7 8 9 10 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 Mean 1 2 3 4 5 6 7 8 9 10 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Packer Number

Minutes