<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=133746">bug 133746</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Mike Kaganski from <a href="show_bug.cgi?id=133746#c7">comment #7</a>) > (In reply to Colin from <a href="show_bug.cgi?id=133746#c5">comment #5</a>) > > 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] <a href="https://en.wikipedia.org/wiki/Percentile">https://en.wikipedia.org/wiki/Percentile</a> Attached image clearly demonstrates that it sometimes works. Sometimes = bug</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>