The Transportation Security Administration (TSA) has assembled a random list of 40 ft containers passing through 5 US East Coast container ports--Baltimore (Bal), New York/New Jersey (NY-NJ), Charleston (Chlsn), Jacksonville (Jxsvl). They are identified by weight in Metric tons (Tonnes), shipper (NYK, EG, M, CSCL), and delivery port. Each observation represents manifest information of a vessel call designated for further examined by a forensic group at TSA.

Perform a multi-level sort of the list (not including the "OBS" column) by "Shipper" (A-Z), "Port" (A-Z), and "# of 40 ft Cntrs" (Smallest-Largest) in Excel. Complete the sort in the order provided.

***Caution: Save a copy of the original data. After a sort in a) you will need to return to the original data.****

a) What is the Tonnes value for the new 8th OBS (remember to not include OBS in the sort)?

b) Return to the original unsorted data. Create a Custom Sort for shippers that sorts in the following Custom order--NYK, EG, CSCL, and M. What is the 50th OBS value for Tonnes? (hint: Create a "custom list" under the "order" tab in "custom sort" tool. Also, remember to not include OBS in the sort)

OBS	# of 40 ft Cntrs.	Tonnes	Shipper	Port
1	17,600	492,800	EG	NY-NJ
2	14,100	394,800	NYK	Bal
3	16,500	478,500	NYK	NY-NJ
4	12,600	378,000	NYK	Chlsn
5	14,600	423,400	NYK	VA
6	23,300	385,700	EG	Chlsn
7	17,000	510,000	NYK	VA
8	20,900	647,900	CSCL	VA
9	30,400	942,400	EG	VA
10	28,700	832,300	M	NY-NJ
11	28,700	803,600	EG	NY-NJ
12	27,800	834,000	NYK	NY-NJ
13	32,100	930,900	NYK	VA
14	25,200	756,000	NYK	VA
15	26,200	812,200	EG	NY-NJ
16	22,700	703,700	M	NY-NJ
17	19,300	579,000	NYK	Chlsn
18	17,800	569,600	M	Chlsn
19	18,000	540,000	NYK	NY-NJ
20	24,000	672,000	NYK	VA
21	24,900	747,000	NYK	Jxsvl
22	28,200	846,000	NYK	NY-NJ
23	27,700	858,700	M	VA
24	30,700	890,300	M	Jxsvl
25	27,500	825,000	EG	Chlsn
26	31,900	1,020,800	EG	NY-NJ
27	32,900	1,019,900	EG	VA
28	25,800	722,400	NYK	NY-NJ
29	28,000	868,000	NYK	NY-NJ
30	18,700	579,700	M	NY-NJ
31	21,900	657,000	EG	Chlsn
32	20,700	579,600	NYK	Jxsvl
33	33,200	1,029,200	EG	VA
34	32,700	948,300	EG	NY-NJ
35	36,700	1,101,000	EG	Bal
36	36,300	1,052,700	EG	NY-NJ
37	24,600	713,400	NYK	NY-NJ
38	29,600	888,000	NYK	VA
39	30,200	875,800	CSCL	NY-NJ
40	30,600	856,800	EG	VA
41	27,700	775,600	NYK	Bal
42	22,800	729,600	CSCL	NY-NJ
43	21,100	633,000	NYK	VA
44	17,100	513,000	NYK	NY-NJ
45	17,700	566,400	NYK	Chlsn
46	26,500	848,000	EG	Bal
47	28,200	789,600	NYK	Chlsn
48	29,300	820,400	NYK	NY-NJ
49	24,600	787,200	EG	Jxsvl
50	29,100	873,000	EG	NY-NJ
51	26,900	833,900	EG	Jxsvl
52	28,400	823,600	EG	NY-NJ
53	29,000	899,000	EG	Chlsn
54	29,800	894,000	EG	NY-NJ
55	30,400	851,200	NYK	VA
56	25,200	781,200	NYK	NY-NJ
57	22,300	646,700	NYK	Bal
58	22,500	652,500	M	Chlsn
59	32,100	1,027,200	M	NY-NJ
60	40,400	1,131,200	EG	NY-NJ
61	43,800	1,401,600	NYK	Chlsn
62	48,200	1,446,000	NYK	VA
63	40,100	1,243,100	NYK	VA
64	39,000	1,092,000	NYK	NY-NJ
65	42,400	1,314,400	NYK	Jxsvl
66	35,400	1,062,000	NYK	NY-NJ
67	40,000	1,200,000	EG	NY-NJ
68	38,700	1,199,700	NYK	NY-NJ
69	28,400	823,600	NYK	NY-NJ
70	32,600	978,000	EG	Jxsvl
71	33,500	1,005,000	M	NY-NJ
72	39,300	1,179,000	NYK	Chlsn
73	37,300	1,156,300	NYK	NY-NJ
74	53,600	1,608,000	NYK	NY-NJ
75	42,700	1,281,000	M	NY-NJ
76	42,300	1,226,700	CSCL	VA
77	46,700	1,307,600	NYK	Bal
78	46,400	1,438,400	EG	VA