Question

1 Approved Answer

Posted on Aug 26, 2024

I need to know how to solve this using vlookup or other softwares in Excel. there are over 1000 vessels in this data set but

I need to know how to solve this using vlookup or other softwares in Excel. there are over 1000 vessels in this data set but you could kindly show me how to solve using excel with just a few of the ones gave and then i can repeat for the whole set.

Which carriers has the fastest average average transit time from Shenzen,China to Savannah Ga?

How should we think about variability and should it change which carrier we consider the fastest from Shenzen to Savannah?

Exercise 1 Which carriers has the fastest average transit time from Shenzhen, China to Savannah GA? How should we think about variability and should it change which carrier we consider the fastest from Shenzhen to Savannah? 3 vessel Cartie Vessel 1 Carrier 2 Vessel 2 Carrier 2 Vessel 3 Carrier 2 Vessel 4 Carrier 2 0 Vessel 5 Carrier 3 1 Vessel 6 Carrier 3 12 Vessel 7 Carrier 2 13 Vessel 8 Carrier 2 14 Vessel 9 Carrier 3 15 Vessel 10 Carrier 3 16 Vessel 11 Carrier 2 17 Vessel 12 Carrier 2 18 Vessel 13 Carrier 4 19 Vessel 14 Carrier 3 20 Vestel 15 Carrier 2 21 Vessel 16 Carrier 3 22 Vessel 17 Carrier 3 23 Vessel 18 Carrier 2 Vessel 19 Carrier 2 25 Vossel 20 Carrier 26 Vestel 21 Carrier 2 Exercise 1 Origin Name SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA Exercise a Exercise Port of Discharge Nam LOS ANGELES, CA LOS ANGELES, CA LOS ANGELES, CA SAVANNAH, GA SAVANNAH, GA NEW YORK, NY SAVANNAH, GA LOS ANGELES, CA LOS ANGELES, CA LOS ANGELES, CA SEATTLE, WASHINGTON SAVANNAH, GA LOS ANGELES, CA SAVANNAH, GA LOS ANGELES, CA SAVANNAH, GA SAVANNAH, GA LOS ANGELES, CA LOS ANGELES, CA LOS ANGELES, CA SAVANNAH, GA Exercise 4 Departu 3-Jul-20 10-Jul-20 10-Jul-20 11-Jul-20 11-Jul-20 4-Jul-20 18-Jul-20 17-Jul-20 2-Jul-20 2-Jul-20 9-Jul-20 4-Jul-20 20-Jul-20 18-Jul-20 3-Jul-20 4-Jul-20 4-Jul-20 3-Jul-20 3-01-20 2-Jul-20 4-Jul-20 Arrival 18-Jul-20 26-Jul-20 26-Jul-20 13-Aug-20 7-Aug-20 31-Jul-20 20-Aug-20 1-Aug-20 16-Jul-20 16-Jul-20 25-Jul-20 6-Aug-20 3-Aug-20 14.Aug-20 18-Jul-20 1-Aug-20 1. Aug-20 18-Jul-20 18.Jul-20 16 Jul-20 6-Aug-20 B F 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 A Vessel 25 Vessel 27 Vessel 28 Vessel 29 Vessel 30 Vessel 32 Vessel 33 Vessel 35 Vessel 36 Vessel 37 Vessel 40 Vessel 43 Vessel 45 Vessel 48 Vessel 49 Vessel 50 Vessel 51 Vessel 53 Vessel 54 Vessel 55 Vessel 56 Vessel 58 Vessel 60 Vessel 61 Vessel 62 Vessel 63 B Carrier 3 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 2 Carrier 3 Carrier 3 Carrier 3 Carrier 2 Carrier 3 Carrier 2 Carrier 2 Carrier 3 Carrier 3 Carrier 3 Carrier 3 Carrier 4 Carrier 2 Carrier 1 Carrier 3 Carrier 2 Carrier 3 Carrier 4 Carrier 4 Carrier 3 Exercise 1 SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA SHENZHEN, CHINA Exercise 2 Exercise 3 D SEATTLE, WASHINGTON SAVANNAH, GA SAVANNAH, GA SAVANNAH, GA SAVANNAH, GA SAVANNAH, GA LOS ANGELES, CA LOS ANGELES, CA SAVANNAH, GA SAVANNAH, GA NEW YORK, NY SEATTLE, WASHINGTON SEATTLE, WASHINGTON SAVANNAH, GA LOS ANGELES, CA NEW YORK, NY LOS ANGELES, CA LOS ANGELES, CA SAVANNAH, GA LOS ANGELES, CA LOS ANGELES, CA SEATTLE, WASHINGTON SAVANNAH, GA LOS ANGELES, CA LOS ANGELES, CA SAVANNAH, GA Exercise 4 E 31-Jul-20 25-Jul-20 25-Jul-20 25-Jul-20 25-Jul-20 25-Jul-20 9-Jul-20 9-Jul-20 4-Jul-20 4-Jul-20 4-Jul-20 2-Jul-20 23-Jul-20 4-Jul-20 2-Jul-20 4-Jul-20 9-Jul-20 10-Jul-20 4-Jul-20 4-Jul-20 2-Jul-20 30-Jul-20 4-Jul-20 4-Jul-20 20-Jul-20 19-Jul-20 17-Aug-20 21-Aug-20 27-Aug-20 27-Aug-20 21-Aug-20 27-Aug-20 23-Jul-20 23-Jul-20 1-Aug-20 6-Aug-20 31-Jul-20 19-Jul-20 9-Aug-20 1-Aug-20 16-Jul-20 31-Jul-20 23-Jul-20 24-Jul-20 6-Aug-20 18-Jul-20 16-Jul-20 15-Aug-20 1-Aug-20 18-Jul-20 3-Aug-20 14-Aug-20 Ready