Results for quantilsrang translation from German to English

quantilsrang
percentrank

quantilsrang(daten; wert)
percentrank(data; value)

kgrÖsste, median, min, quantil, quantilsrang, quartile
large, median, min, percentile, percentrank, quartile

kgrÖsste, kkleinste, max, median, min, quantil, quantilsrang
large, small, max, median, min, percentile, percentrank

=quantilsrang(a1:a50; 50) gibt den prozentualen rang des wertes 50 am gesamtbereich aller werte in a1:a50.
=percentrank(a1:a50; 50) returns the percentage rank of the value 50 from the total range of all values found in a1:a50.