Examkin

Question

Difficulty: EasySorting and Multi-Column Ordering

The table below displays performance metrics for six maritime shipping ports.

PortRegionTonnage (M Tons)On-Time Arrival Rate (%)Operational Cost ($M)
Port AEast458812
Port BWest608815
Port CEast609214
Port DNorth309510
Port EWest458511
Port FEast608516

If the table is sorted first by Tonnage (M Tons) in descending order, and any ties are broken by On-Time Arrival Rate (%) in descending order, Port B will be listed second from the top.

Answer: Answer

Answer

The statement is True. When sorted primarily by Tonnage (descending) and secondarily by On-Time Arrival Rate (descending), Port B occupies the second row from the top.
Sorting primarily by Tonnage in descending order identifies Ports B, C, and F as the top group with 60 M Tons. Applying the secondary sort by On-Time Arrival Rate in descending order ranks Port C (92%) first and Port B (88%) second.

Step-by-Step Solution

1
Identify the primary sort column and filter for the highest values.
The primary sort column is Tonnage (M Tons) descending. The maximum tonnage value is 60, shared by Port B, Port C, and Port F.
Primary sort criteria dictate grouping the dataset by the highest primary metric first.
2
Apply the secondary sort criteria (On-Time Arrival Rate descending) to break the three-way tie.
Among Ports B, C, and F, their On-Time Arrival Rates are: Port C (92%), Port B (88%), and Port F (85%). Sorting descending gives the order: Port C, Port B, Port F.
Secondary sort rules determine the internal ordering of rows that share identical primary sort values.
3
Determine the final position of Port B.
Port C is row 1, Port B is row 2, and Port F is row 3.
Comparing the sorted order directly answers the statement's evaluation criteria.

Key Concept

Multi-Column Table Sorting and Tie-Breaking Logic
Rate this question

Topics

Sorting and Multi-Column Ordering

More questions from this topic