Skip to content

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

Monthly sales (₹ lakh) of a Pune distributor for five branches are 40, 44, 46, 50 and one entry missing. The other four branches' mean is the benchmark, and the analyst fills the missing value with the mean of the four available values. What value is imputed, and what is the mean of all five values after imputation?

The imputed value is 45 and the five-value mean stays 45. The four known values total 180, giving a mean of 45. Adding 45 makes the total 225, and 225 divided by 5 is 45. Mean imputation leaves the mean unchanged.

  1. AImputed 45; mean of five values 45Correct
  2. BImputed 45; mean of five values 36
  3. CImputed 46; mean of five values 45
  4. DImputed 40; mean of five values 44

Explanation

Mean of available values = (40+44+46+50)/4 = 180/4 = 45. After imputing 45, the total is 225 and the mean of five values is 225/5 = 45. Mean imputation never changes the mean of the data, which is why option 36 (dividing 180 by 5 and ignoring the imputed value) is wrong.

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