0.5 vs 0.9 in PERCENTILE_CONT()

PERCENTILE_CONT() is one of those SQL functions that looks simple until you have to explain what values like 0.5 or 0.9 actually mean.