If you want to summarize a numeric field by its average, which option would you choose?

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

Answer: (D)

To summarize a numeric field by its average, you use the function that calculates the mean of all values. This function adds up all the numbers and divides by how many values there are, giving a sense of the typical value in the data. It’s useful for understanding central tendency, like the average order value or average time spent, rather than highlighting the extremes or total sum. The other options perform different summarizations: the maximum shows the largest value, the sum adds all values together, and the count tells you how many observations exist. So the average option is the best fit when you want to describe the typical value.