Soru

Zorluk: OrtaSorting and Multi-Column Ordering

The table below presents clinical trial enrollment and quality metrics for eight medical research sites participating in a pharmaceutical study:

Research SiteRegionTarget EnrollmentAchieved Enrollment (%)Protocol Deviations (per 100 subjects)
Site 101North15095%4.5
Site 102East12095%3.8
Site 103South20092%4.2
Site 104West15092%1.8
Site 105North20090%2.5
Site 106East25088%3.1
Site 107West18085%1.8
Site 108South20085%2.5

If the table is sorted in descending order by Achieved Enrollment (%), and any ties are broken by sorting in ascending order by Protocol Deviations (per 100 subjects), which research site will be listed 4th from the top?

  1. Site 103Cevap
  2. B
    Site 104
  3. C
    Site 101
  4. D
    Site 105
  5. E
    Site 107

Cevap

Site 103 will be listed 4th from the top after applying the primary descending sort on Achieved Enrollment (%) and the secondary ascending sort tie-breaker on Protocol Deviations.
Sorting the table primarily by Achieved Enrollment (%) in descending order places the two 95% sites first, followed by the two 92% sites. Applying the secondary sort (Protocol Deviations in ascending order) places Site 104 (1.8 deviations) in 3rd position and Site 103 (4.2 deviations) in 4th position.

Adım Adım Çözüm

1
Group research sites by the primary sort key: Achieved Enrollment (%) in descending order.
Groups in order: 95% (Sites 101, 102), 92% (Sites 103, 104), 90% (Site 105), 88% (Site 106), 85% (Sites 107, 108).
Primary sort priority dictates that higher percentage values must appear before lower percentage values.
2
Apply the secondary tie-breaking condition: Protocol Deviations (per 100 subjects) in ascending order for tied groups.
For the 95% group: Site 102 (3.8) comes before Site 101 (4.5) -> Positions 1 and 2.
For the 92% group: Site 104 (1.8) comes before Site 103 (4.2) -> Positions 3 and 4.
Ascending order means lower numerical deviation values rank higher among tied entries.
3
Determine the site occupying the 4th position.
1st: Site 102, 2nd: Site 101, 3rd: Site 104, 4th: Site 103.
Site 103 is the second site within the 92% group after tie-breaking.

Anahtar Kavram

Multi-Column Sorting with Primary and Secondary Tie-Breaking Rules
Tahmini Süre:1m 30s
Bu soruyu puanla