Three statistical problems

profilesama6820
homework_group_3_data.xls
Home>Applied Sciences homework help>Three statistical problems

Sheet1

Courier Pickup Time Delivery Time Mileage Cost
1 13 14 7 16.55
3 20 51 20 26.50
2 22 33 12 19.00
3 11 47 19 25.60
3 17 18 8 15.70
1 15 88 17 23.05
3 17 20 11 18.40
3 17 39 11 18.40
3 19 23 10 17.50
1 25 20 8 17.20
3 19 32 10 17.50
3 9 35 16 22.90
3 13 23 9 16.60
2 17 21 10 17.50
1 14 37 16 22.40
2 17 25 12 19.00
3 29 15 6 13.90
3 26 34 15 22.00
2 15 13 4 13.00
1 23 12 4 14.60
2 12 41 14 20.50
2 6 28 13 19.75
1 7 26 10 18.50
3 17 54 16 22.90
2 13 18 8 16.00
1 12 50 13 20.45
1 18 19 7 16.55
1 6 19 8 17.20
3 19 45 14 21.10
1 24 12 5 15.25
1 16 16 5 15.25
2 14 35 13 19.75
1 4 12 6 15.90
3 15 30 11 18.40
1 10 13 8 17.20
1 21 20 8 17.20
2 10 19 8 16.00
2 10 14 7 15.25
1 9 11 4 14.60
2 19 25 12 19.00
2 12 32 14 20.50
2 15 44 16 22.00
1 18 28 9 17.85
3 15 31 11 18.40
2 14 19 8 16.00
1 16 28 10 18.50
1 25 18 9 17.85
3 20 32 14 21.10
2 16 44 15 21.25
2 15 34 13 19.75
1 5 33 12 19.80
1 11 33 12 19.80
3 10 46 20 26.50
2 12 29 10 17.50
3 23 18 8 15.70
1 10 52 23 26.95
2 24 41 12 19.00
2 11 18 7 15.25
2 13 24 13 19.75
1 18 41 18 23.70
3 18 40 13 20.20
1 25 11 5 15.25
1 13 13 6 15.90
2 10 32 12 19.00
1 16 42 12 19.80
3 8 47 17 23.80
1 18 57 13 20.45
3 20 18 7 14.80
2 17 27 10 17.50
3 11 10 4 12.10
2 25 16 7 15.25
1 27 24 10 18.50
2 12 42 14 20.50
3 19 15 5 13.00
2 9 19 9 16.75
3 19 48 18 24.70
3 10 30 10 17.50
2 25 39 16 22.00
3 17 23 9 16.60
3 18 34 15 22.00
2 14 34 15 21.25
3 11 24 8 15.70
3 12 57 19 25.60
2 16 61 24 28.00
3 14 54 20 26.50
1 14 52 18 23.70
1 8 45 17 23.05
1 13 11 5 15.25
2 22 29 11 18.25
3 7 36 12 19.30
3 15 82 22 28.30
2 9 7 3 12.25
2 19 16 6 14.50
2 14 50 22 26.50
1 24 15 5 15.25
2 13 28 12 19.00
1 22 7 3 13.95
2 19 17 7 15.25
3 20 33 13 20.20
2 20 43 14 20.50
3 8 27 12 19.30
2 7 21 9 16.75
3 18 33 11 18.40
1 32 21 10 18.50
3 7 39 14 21.10
1 25 25 11 19.15
3 15 27 12 19.30
3 13 42 18 24.70
1 17 26 11 19.15
3 11 43 16 22.90
3 14 52 21 27.40
3 15 30 15 22.00
2 14 15 4 13.00
2 23 49 15 21.25
2 13 41 14 20.50
2 15 20 8 16.00
1 30 28 11 19.15
2 23 35 17 22.75
3 12 19 8 15.70
3 17 49 22 28.30
2 14 48 12 19.00
3 11 84 24 30.10
1 11 8 4 14.60
1 11 24 9 17.85
3 19 53 15 22.00
2 11 30 12 19.00
1 13 17 9 17.85
1 21 12 4 14.60
2 13 41 14 20.50
3 15 19 7 14.80
1 11 13 5 15.25
2 9 28 9 16.75
3 12 29 11 18.40
2 15 65 22 26.50
3 9 41 15 22.00
2 14 18 6 14.50
1 16 28 12 19.80
2 21 37 12 19.00
2 12 27 10 17.50
3 14 67 24 30.10
1 15 31 8 17.20
3 10 47 18 24.70
2 10 43 16 22.00
2 14 25 10 17.50
3 20 36 16 22.90
2 20 29 14 20.50
2 17 21 11 18.25
1 8 33 11 19.15
2 15 47 17 22.75
2 21 22 10 17.50
3 19 40 16 22.90
1 9 26 11 19.15
3 20 21 9 16.60
3 17 22 11 18.40
2 7 31 15 21.25
1 13 4 2 13.30
2 33 64 22 26.50
2 18 63 21 25.75
1 14 28 11 19.15
3 12 43 16 22.90
2 10 44 14 20.50
3 14 36 15 22.00
1 11 43 17 23.05
1 14 34 16 22.40
2 12 6 2 11.50
3 9 38 13 20.20
1 13 8 4 14.60
2 38 48 25 28.75
1 18 15 6 15.90
3 9 38 17 23.80
1 20 26 12 19.80
2 21 40 11 18.25
1 7 20 9 17.85
2 10 32 11 18.25
1 17 16 6 15.90
2 10 27 13 19.75
1 15 63 19 24.35
3 17 45 13 20.20
2 10 15 6 14.50
1 8 40 12 19.80
3 24 53 19 25.60
3 10 21 8 15.70
Using the data set attached, read the business case on page 460-464 and answer the questions on page 464 (in complete sentences in the format of a report/executive summary).

Sheet2

Sheet3