Which data summarization tool groups data into categories and computes aggregates, commonly used for department charges?

Which data summarization tool groups data into categories and computes aggregates, commonly used for department charges?

• A. Bar chart
• B. Pivot table
• C. Line chart
• D. Histogram

Answer: (B)

Grouping data into categories and calculating aggregates is exactly what a pivot table is designed to do. When you have department charges, you often want to see totals (or averages, counts, etc.) broken down by department, and you may also want to slice by service type or time period. A pivot table lets you place department names into rows, add service types as columns if needed, and summarize the charge field with a sum (or other aggregate). This creates a clear, cross-tabulated view of totals by category that you can pivot, filter, or drill into with just a few clicks, making it the most efficient tool for this kind of analysis. Other visualizations aren’t built to perform this kind of on-the-fly grouping and aggregation across multiple categories. A bar chart shows values per category but doesn’t inherently produce the grouped totals or allow quick multi-dimensional breakdowns. A line chart focuses on trends over time, not categorical summaries. A histogram shows distribution of a numeric variable, not category-based totals.

Grouping data into categories and calculating aggregates is exactly what a pivot table is designed to do. When you have department charges, you often want to see totals (or averages, counts, etc.) broken down by department, and you may also want to slice by service type or time period. A pivot table lets you place department names into rows, add service types as columns if needed, and summarize the charge field with a sum (or other aggregate). This creates a clear, cross-tabulated view of totals by category that you can pivot, filter, or drill into with just a few clicks, making it the most efficient tool for this kind of analysis.

Other visualizations aren’t built to perform this kind of on-the-fly grouping and aggregation across multiple categories. A bar chart shows values per category but doesn’t inherently produce the grouped totals or allow quick multi-dimensional breakdowns. A line chart focuses on trends over time, not categorical summaries. A histogram shows distribution of a numeric variable, not category-based totals.