Soru

Zorluk: OrtaSorting and Multi-Column Ordering

The table below presents operational metrics for 8 oceanographic research vessels participating in a global marine survey:

Vessel IDRegionActive DaysFuel Efficiency (nmi/ton)Grants ($M)
Triton-1Pacific24014.23.8
Nereus-4Atlantic21518.54.2
Proteus-2Pacific24016.02.9
Oceanus-7Arctic19012.15.1
Calypso-3Atlantic26015.43.1
Glaucus-5Pacific21519.24.6
Thalassa-9Indian26013.84.0
Doris-6Atlantic19014.53.5

Based on the table above, evaluate whether the following statement is True or False:

"If the table is sorted primarily by Active Days in descending order, with ties broken by Fuel Efficiency in descending order, the vessel that ranks 4th from the top is Triton-1."

Cevap: Cevap

Cevap

True
Sorting primarily by Active Days descending places Calypso-3 and Thalassa-9 in positions 1–2, and Proteus-2 and Triton-1 in positions 3–4. Applying the secondary sort by Fuel Efficiency descending resolves the tie between Proteus-2 (16.0 nmi/ton) and Triton-1 (14.2 nmi/ton), placing Proteus-2 3rd and Triton-1 4th.

Adım Adım Çözüm

1
Group and sort vessels by the primary criterion (Active Days in descending order).
Tier 1 (260 days): Calypso-3, Thalassa-9. Tier 2 (240 days): Triton-1, Proteus-2. Tier 3 (215 days): Nereus-4, Glaucus-5. Tier 4 (190 days): Oceanus-7, Doris-6.
Primary sort determines the overarching rank brackets.
2
Apply the secondary tie-breaker (Fuel Efficiency in descending order) to resolve order within tied groups.
For Tier 1 (260 days): Calypso-3 (15.4) > Thalassa-9 (13.8) -> Ranks 1 and 2. For Tier 2 (240 days): Proteus-2 (16.0) > Triton-1 (14.2) -> Ranks 3 and 4.
Higher fuel efficiency takes precedence when active days are identical.
3
Identify the vessel occupying the 4th position.
Position 4 is occupied by Triton-1.
Proteus-2 claims 3rd place, leaving Triton-1 in 4th place.

Anahtar Kavram

Multi-Column Tie-Breaking and Hierarchical Table Sorting
Tahmini Süre:1m 30s
Bu soruyu puanla