Soru

Zorluk: OrtaSorting and Multi-Column Ordering

The table below lists performance metrics for seven regional logistics distribution hubs:

Logistics HubRegionOrder Fulfillment Rate (orders/hr)On-Time Delivery Rate (%)Storage Capacity (thousand sq ft)
Hub AlphaNorth42094.5%150
Hub BetaEast51091.2%210
Hub GammaNorth42096.8%180
Hub DeltaWest38098.1%120
Hub EpsilonSouth51095.4%190
Hub ZetaEast47093.0%160
Hub EtaSouth51092.5%220

True or False: If the table is sorted primarily by Order Fulfillment Rate (orders/hr) in descending order, and ties are broken by On-Time Delivery Rate (%) in descending order, the hub ranked 3rd in the ordered list has a greater Storage Capacity than the hub ranked 5th.

Cevap: Cevap

Cevap

True
Sorting the table by Order Fulfillment Rate descending places hubs with 510 orders/hr in the top positions. Breaking ties by On-Time Delivery Rate descending orders these three hubs as Hub Epsilon (95.4%), Hub Eta (92.5%), and Hub Beta (91.2%), making Hub Beta 3rd. The next group (420 orders/hr) orders Hub Gamma (96.8%) ahead of Hub Alpha (94.5%), placing Hub Gamma 5th overall. Comparing Hub Beta's storage capacity (210) to Hub Gamma's (180) confirms that 210>180210 > 180.

Adım Adım Çözüm

1
Group hubs by the primary sort key: Order Fulfillment Rate (orders/hr) in descending order.
Group 1 (510 orders/hr): Hub Beta, Hub Epsilon, Hub Eta. Group 2 (470 orders/hr): Hub Zeta. Group 3 (420 orders/hr): Hub Alpha, Hub Gamma. Group 4 (380 orders/hr): Hub Delta.
Primary ordering establishes the initial rank blocks.
2
Break ties within Group 1 and Group 3 using On-Time Delivery Rate (%) in descending order.
Group 1 order: Hub Epsilon (95.4%), Hub Eta (92.5%), Hub Beta (91.2%). Group 3 order: Hub Gamma (96.8%), Hub Alpha (94.5%).
Higher percentage values receive higher priority when sorting descending.
3
Combine the ordered groups to find the 3rd and 5th hubs.
1st: Hub Epsilon, 2nd: Hub Eta, 3rd: Hub Beta, 4th: Hub Zeta, 5th: Hub Gamma, 6th: Hub Alpha, 7th: Hub Delta.
Determines exact multi-column rank order.
4
Compare Storage Capacity for the 3rd-ranked hub (Hub Beta) and the 5th-ranked hub (Hub Gamma).
Hub Beta Storage Capacity = 210. Hub Gamma Storage Capacity = 180. 210>180210 > 180.
Directly evaluates the condition stated in the prompt.

Anahtar Kavram

Multi-column sorting and tie-breaker rank evaluation
Bu soruyu puanla