[Libreoffice-bugs] [Bug 133746] Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133746

--- Comment #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Colin from comment #5)

You need to understand what "percentile" means. Its not "(max + min)/2"; it's
"value below which a given percentage of observations in a group of
observations falls" [1]. So if you have a data set:

1 2 3 8 8 10 10 10 10 10

then your 10th percentile is >=1 and <2 (because 10% of cases - i.e. 1 of 10 -
is below 1); your 40th percentile is 8 - because first 4 cases - i.e. 40% - are
<=8, and the rest is >=8; and your 50th percentile is >=8 and <= 10. Your 60%
percentile is 10, and same are all further percentiles.

[1] https://en.wikipedia.org/wiki/Percentile

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200607/4171f8ca/attachment.htm>