Skip to content

CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation

An analyst fills missing values in a column of monthly expenses (Rs thousand) using the mean of the available values: 20, 30, 40, 50 and two blanks. After imputation with the mean, what is the mean of all six values?

The mean remains Rs 35 thousand. The four known values average 35, and replacing both blanks with 35 adds 70 to a total of 140, giving 210 divided by six values, which is 35. Mean imputation preserves the average but reduces variability.

  1. A35Correct
  2. B28
  3. C30
  4. D40

Explanation

Mean of the four available values = (20+30+40+50)/4 = 140/4 = 35. Each blank is filled with 35, so total = 140 + 70 = 210 and mean = 210/6 = 35. Mean imputation leaves the mean unchanged. The value 30 comes from using the median-style midpoint wrongly.

Did you get it right without looking?

One question tells you little. A timed set on Data Processing, Organisation, Cleaning and Validation shows your real accuracy, how long you take and where you lose marks.

Practise Data Processing, Organisation, Cleaning and ValidationFree diagnostic mock

More Data Processing, Organisation, Cleaning and Validation questions