You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost. You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost…

Question

Options

• ACreate a new view.
• BColor encode the hotel chain names.
• CInclude an Other group.
• DInclude the Summary card.

• A
  8% (5)
• B
  3% (2)
• C
  77% (50)
• D
  12% (8)

Explanation

Including an Other group (C) automatically collects all ungrouped members - the 80 hotel chains not in either the top 10 or bottom 10 - into a single "Other" bucket with its own subtotal, enabling a clean side-by-side comparison of all three segments within the same crosstab.

Why the distractors are wrong:

• A (New view): Creating a separate view fragments the analysis; the goal is to improve comparison within the existing crosstab, not split it across views.
• B (Color encode names): Color adds visual distinction but doesn't solve the structural gap - the remaining 80 chains still have no group or subtotal to compare against.
• D (Summary card): The Summary card displays aggregate totals for the entire dataset, not a breakdown of how ungrouped chains compare to the named groups.

Memory tip: Think of "Other" as a catch-all bucket - whenever you create named groups, the remaining ungrouped members go there automatically with their own subtotal, completing the picture without manual effort.

No community discussion yet for this question.