Project: QGIS
Version: 3.18
The characteristics of the Cell Statistics processing tool have been replicated and modified to allow for three new processing algorithms, which allow QGIS to calculate cell statistics in a similar manner to common percentage functions used in spreadsheet programs. The new processing algorithms are:
- Cell stack percentile
- Cell stack percentrank from value
- Cell stack percentrank from raster layer
While the percentile algorithm only offers the possibility of calculating percentiles based on an input fraction value (ranging between 0 and 1), a percentrank raster can also be calculated based on an input value raster. This gives the user the opportunity to calculate per-cell percentranks based on dataset driven value input (eg. sample layers).
All algorithms provide different methods for calculating percentiles and percentranks:
Percentile: - Nearest Rank - Inclusive linear interpolation (see LibreOffice's and Microsoft Excel's PERCENTILE.INC function) - Exclusive linear interpolation (see LibreOffice's and Microsoft Excel's PERCENTILE.EXC function)
Percentrank: - Inclusive linear interpolation (see LibreOffice's and Microsoft Excel's PERCENTRANK.INC function) - Exclusive linear interpolation (see LibreOffice's and Microsoft Excel's PERCENTRANK.EXC function)
This feature was developed by Clemens Raffler