Examkin

Soru

Zorluk: OrtaConditional Filtering and Selection

The table below presents financial and operational metrics for seven portfolio companies evaluated by a venture capital firm:

CompanySectorRevenue Growth (%)ProfitableEmployee Retention Rate (%)
Alpha CorpTech35Yes88
Beta HealthBiotech45No92
Gamma PowerCleanEnergy28Yes85
Delta PayFinTech50No78
Epsilon BioBiotech40Yes94
Zeta SystemsTech60No82
Eta DynamicsCleanEnergy52Yes90

An investment committee will shortlist companies that satisfy at least two of the following three conditions:
1. Revenue Growth greater than 40%40\%
2. Profitable (Status = Yes)
3. Employee Retention Rate of at least 90%90\%

Which of the following companies meet the investment committee's criteria for shortlisting?

  1. Beta HealthCevap
  2. B
    Delta Pay
  3. Epsilon BioCevap
  4. D
    Zeta Systems
  5. Eta DynamicsCevap

Cevap

The companies that qualify for shortlisting are Beta Health, Epsilon Bio, and Eta Dynamics.
The correct selections are Beta Health, Epsilon Bio, and Eta Dynamics because each satisfies at least two of the three stated conditions. Beta Health achieves Revenue Growth above 40% (45%) and Retention at or above 90% (92%). Epsilon Bio is Profitable and achieves Retention of at least 90% (94%). Eta Dynamics satisfies all three requirements.

Adım Adım Çözüm

1
Define the three evaluation criteria explicitly
Criterion 1: Revenue Growth >40%> 40\%; Criterion 2: Profitable = Yes; Criterion 3: Employee Retention Rate ≥90%\geq 90\%.
Clear definitions prevent boundary errors when filtering multi-column data.
2
Evaluate each company against all three criteria
Alpha Corp: C1 (No, 35%), C2 (Yes), C3 (No, 88%) -> Total: 1 criterion.
Beta Health: C1 (Yes, 45%), C2 (No), C3 (Yes, 92%) -> Total: 2 criteria.
Gamma Power: C1 (No, 28%), C2 (Yes), C3 (No, 85%) -> Total: 1 criterion.
Delta Pay: C1 (Yes, 50%), C2 (No), C3 (No, 78%) -> Total: 1 criterion.
Epsilon Bio: C1 (No, 40% is not > 40%), C2 (Yes), C3 (Yes, 94%) -> Total: 2 criteria.
Zeta Systems: C1 (Yes, 60%), C2 (No), C3 (No, 82%) -> Total: 1 criterion.
Eta Dynamics: C1 (Yes, 52%), C2 (Yes), C3 (Yes, 90%) -> Total: 3 criteria.
Systematic evaluation ensures no row or condition is miscounted.
3
Identify all companies meeting at least two conditions
Beta Health (2 criteria), Epsilon Bio (2 criteria), and Eta Dynamics (3 criteria) qualify.
Filtering for total criteria count ≥2\geq 2 yields the correct subset.

Anahtar Kavram

Multi-condition compound filtering requires evaluating individual logical constraints across multiple columns and aggregating total satisfied criteria per row.
Bu soruyu puanla

Konular

Conditional Filtering and Selection

Bu konudan daha fazla soru