Translations:Faq/Calc/142/10/en

    From The Document Foundation Wiki

    In this example, choosing a scale with 3 entries allows us to highlight the intermediate values. We have associated the Yellow color to Percentile[1] 50, and we have once again associated Tango: Sky blue 1 to Min (minimum) and Light red to Max (maximum).

    1. A percentile is each of the 99 values which divide the sorted data in 100 equal parts, so that each part represents 1/100 of the sample population. A percentile return the value for a data series going from the smallest to the largest value in a set of data. For Alpha = 25, the percentile means the first quartile = 50 Alpha is the MEDIAN.