The table below presents clinical trial enrollment and quality metrics for eight medical research sites participating in a pharmaceutical study:
| Research Site | Region | Target Enrollment | Achieved Enrollment (%) | Protocol Deviations (per 100 subjects) |
|---|---|---|---|---|
| Site 101 | North | 150 | 95% | 4.5 |
| Site 102 | East | 120 | 95% | 3.8 |
| Site 103 | South | 200 | 92% | 4.2 |
| Site 104 | West | 150 | 92% | 1.8 |
| Site 105 | North | 200 | 90% | 2.5 |
| Site 106 | East | 250 | 88% | 3.1 |
| Site 107 | West | 180 | 85% | 1.8 |
| Site 108 | South | 200 | 85% | 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?
- Site 103Answer
- BSite 104
- CSite 101
- DSite 105
- ESite 107
Answer
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.
Step-by-Step Solution
Key Concept
Multi-Column Sorting with Primary and Secondary Tie-Breaking Rules
Estimated Time:1m 30s