⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

1 day, 14 hours remaining!

CompTIA Data+ DA0-002 (V2) Practice Question

A retail analyst is preparing a report on customer spending behavior. The transaction table contains a numeric column AmountSpent, which is right-skewed because a small number of customers make very large purchases. Roughly 8 % of the rows have NULL values in that column, and the analyst must replace the NULLs before calculating the median and quartiles for an upcoming dashboard. The business wants a quick, single-value imputation that minimizes the bias introduced by the skew while still reflecting the variable's central tendency. Which imputation strategy best meets these requirements?

  • Replace missing values with the column median calculated from the non-NULL data.

  • Replace missing values with the column mean calculated from the non-NULL data.

  • Replace missing values with zero to avoid overstating revenue.

  • Use forward fill (last observation carried forward) based on transaction date.

CompTIA Data+ DA0-002 (V2)
Data Acquisition and Preparation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot