The Transportation Security Administration (TSA) has assembled a random list of

Question

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). Complete the sort in the order provided in Excel.

***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)

c) Which of the following formulas will allow you to accurately count the simultaneous occurrence of records with VA in the Port column and M in the Shipper column of the original Port data? Assume the Port Data is located in the upper left-hand corner of a worksheet (OBS is in cell A1):

W) =COUNTIFS(D2:D79,"M", E2:E79,"VA")

X)   =COUNTIF(E2:E79,"VA")+COUNTIF(D2:D79, "M")

Y)   both W) and X)

Z)   none of the above

Shipper Port EG NY-NJ NYK Bal NYK NY-NJ NYK Chlsn NYK VA EG Chlsn NYK VA CSCL VA EG VA M NY-NJ EG NY-NJ NYK NY-NJ NYK VA NYK VA EG NY-NJ M NY-NJ NYK Chlsn M Chlsn NYK NY-NJ NYK VA NYK Jxsvl NYK NY-NJ M VA M Jxsvl EG Chlsn EG NY-NJ EG VA NYK NY-NJ NYK NY-NJ M NY-NJ EG Chlsn NYK Jxsvl EG VA EG NY-NJ EG Bal EG NY-NJ NYK NY-NJ NYK VA CSCL NY-NJ EG VA NYK Bal CSCL NY-NJ NYK VA NYK NY-NJ NYK Chlsn EG Bal NYK Chlsn NYK NY-NJ EG Jxsvl EG NY-NJ EG Jxsvl EG NY-NJ EG Chlsn EG NY-NJ NYK VA NYK NY-NJ NYK Bal M Chlsn M NY-NJ EG NY-NJ NYK Chlsn NYK VA NYK VA NYK NY-NJ NYK Jxsvl NYK NY-NJ EG NY-NJ NYK NY-NJ NYK NY-NJ EG Jxsvl M NY-NJ NYK Chlsn NYK NY-NJ NYK NY-NJ M NY-NJ CSCL VA NYK Bal EG VA

Explanation / Answer

b) the 50th OBS value for Tonnes is occur at

c) The following formulas will allow you to accurately count the simultaneous occurrence of records with VA in the Port column and M in the Shipper column of the original Port data is

COUNTIFS(D2:D79,"M", E2:E79,"VA")

M NY-NJ

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.