Skip to interview prep
Apexed

44. Two tools report different 90th percentiles for the same small dataset. What would you check before declaring one wrong?

EasyAnalysis & visualization

Technical
Show model answer

Confirm that both tools use the same rows, missing-value handling, units and weighting. Then compare their quantile definitions: some select an observed ordered value, while others interpolate between neighboring observations.

Document the chosen convention and calculate a tiny sorted example by hand. Small samples can make convention differences conspicuous, so align definitions before treating a numerical discrepancy as a software defect.

What interviewers listen for

  • Match data and weighting
  • Check interpolation conventions
  • Verify a small sorted example
Two tools report different 90th percentiles for the same small dataset. What would you check before declaring one wrong — Data & analytics interview question —