DA0-002 Visualization and Reporting Practice Question
A data analyst creates a dashboard showing average order value by region. The chart indicates that one region has an unusually high average. Investigation reveals that the region has very few orders, but one large purchase inflates the average. Which data transformation should the analyst apply to improve the visualization?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use median instead of mean for aggregation
Using the median instead of the mean reduces the influence of extreme values. The median is a robust measure of central tendency that is not skewed by a single large order, thus providing a more accurate representation of typical order values in that region. Option A (logarithmic scaling) could help with visualization of wide ranges but does not change the aggregation; option C (pie chart) is not suitable for comparing average values across regions; option D (removing all outliers) is too drastic and may discard valid data points.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Apply logarithmic scaling to the y-axis
Why it's wrong here
Log scaling compresses values but does not address the aggregation method.
- ✓
Use median instead of mean for aggregation
Why this is correct
Median is less sensitive to outliers than mean.
- ✗
Change the chart type to a pie chart
Why it's wrong here
Changing chart type does not fix the aggregation issue.
- ✗
Remove all outliers from the dataset
Why it's wrong here
Removing outliers may discard valid data; better to use robust aggregation.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.