How do you summarize the "Price per unit" in a pivot table?

• A. Sum
• B. Count
• C. Median
• D. Average

Answer: (D)

When you summarize numeric data in a pivot table, you choose a function that describes how to combine the values. Price per unit is a numeric measure across items, so the most informative single figure is the average. The average shows the typical price across all items, smoothing out outliers and giving a representative value.

Sum would produce the total of all prices, which isn’t a per-item summary. Count would tell you how many records there are, not the price level. Median could be useful if you care about robustness to outliers, but the standard choice for a price metric is the average. In practice, place Price per unit in the Values area and set the summary function to Average to display the mean price.