Examkin

Question

Difficulty: MediumConditional Filtering and Selection

The table below presents operational performance metrics for six properties within a boutique hotel portfolio:

Property NameRegionOccupancy Rate (%)Average Daily Rate ($)Customer Satisfaction (1–10)
Grand AzureCoastal823409.1
Alpine HavenMountain754108.8
Urban VantageMetropolitan882908.4
Solstice ResortCoastal684509.3
Metro EliteMetropolitan913108.6
Highland LodgeMountain793809.0

Which of the following statements regarding the portfolio data are true? Select all that apply.

  1. A
    Exactly 3 properties have an Occupancy Rate of at least 80% AND a Customer Satisfaction score of at least 8.5.
  2. Among properties with an Average Daily Rate greater than $350, exactly 2 have a Customer Satisfaction score of at least 9.0.Answer
  3. No property in the Mountain region has an Occupancy Rate exceeding 80% OR an Average Daily Rate below $350.Answer
  4. D
    All properties located in the Coastal region have an Occupancy Rate of at least 70% AND an Average Daily Rate of at least $350.
  5. Exactly 4 properties satisfy at least one of the following criteria: Occupancy Rate greater than 85% OR Average Daily Rate greater than $400.Answer

Answer

The correct statements are those identifying 2 properties with ADR over 350andsatisfactionofatleast9.0,statingthatnoMountainpropertyexceeds80350 and satisfaction of at least 9.0, stating that no Mountain property exceeds 80% occupancy or has ADR below 350, and noting that exactly 4 properties satisfy either an occupancy over 85% or an ADR over $400.
The correct options properly execute multi-column boolean criteria (AND vs. OR). Specifically: filtering properties with ADR over 350forsatisfactionatorabove9.0correctlyisolates2properties;evaluatingMountainregionpropertiesconfirmszerosatisfyeitheroccupancyover80350 for satisfaction at or above 9.0 correctly isolates 2 properties; evaluating Mountain region properties confirms zero satisfy either occupancy over 80% or ADR under 350; and combining properties with occupancy over 85% or ADR over $400 correctly identifies a subset of 4 properties.

Step-by-Step Solution

1
Evaluate the statement regarding Occupancy Rate ≥80%\geq 80\% AND Customer Satisfaction ≥8.5\geq 8.5.
Properties meeting Occupancy ≥80%\geq 80\% are Grand Azure (82%), Urban Vantage (88%), and Metro Elite (91%). Of these, Urban Vantage has a satisfaction of 8.4 (<8.5< 8.5). Only 2 properties meet both criteria, making this statement false.
Conjunctive filtering requires both conditions to hold simultaneously.
2
Evaluate the statement regarding properties with ADR >$350> \$350 having Customer Satisfaction ≥9.0\geq 9.0.
Properties with ADR >$350> \$350 are Alpine Haven ($410\$410), Solstice Resort ($450\$450), and Highland Lodge ($380\$380). Solstice Resort (9.3) and Highland Lodge (9.0) meet the satisfaction threshold (2 properties total), making this statement true.
First filter the subset by ADR threshold, then apply the satisfaction criterion.
3
Evaluate the statement regarding Mountain region properties having Occupancy >80%> 80\% OR ADR <$350< \$350.
Alpine Haven (75%, $410\$410) and Highland Lodge (79%, $380\$380) both fail both conditions. Therefore, 0 Mountain properties satisfy the OR condition, making the statement true.
Disjunctive filtering checks if at least one condition is met per property.
4
Evaluate the statement regarding Coastal properties having Occupancy ≥70%\geq 70\% AND ADR ≥$350\geq \$350.
Grand Azure has ADR $340<$350\$340 < \$350, and Solstice Resort has Occupancy 68%<70%68\% < 70\%. Since neither satisfies both criteria, the statement is false.
A universal condition requires all items in the subset to satisfy the full compound logic.
5
Evaluate the statement regarding properties with Occupancy >85%> 85\% OR ADR >$400> \$400.
Occupancy >85%> 85\%: Urban Vantage, Metro Elite. ADR >$400> \$400: Alpine Haven, Solstice Resort. Combining these gives 4 unique properties, making the statement true.
An inclusive OR filter pools all elements that satisfy either criterion.

Key Concept

Conditional Filtering and Selection
Rate this question

Topics

Conditional Filtering and Selection

More questions from this topic