[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 #9 from Colin <that.man.colin at gmail.com> ---
(In reply to Mike Kaganski from comment #7)
> (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

Attached image clearly demonstrates that it sometimes works. Sometimes = bug

-- 
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/b4f2bfcc/attachment.htm>