Bug 70361

Valid enhancement request. Can't find any duplicate.
Marking as NEW and as enhancement.

This would be a valuable feature to the no few users who write articles for publication in scientific journals ; moreover, it would be a feature which, for example, MS Office does not possess. Perhaps a developer could be convinced to take a look and see if the game would indeed be worth the candle ?...

Henri

Created attachment 93332 [details]
Example of box plot chart type.

I am attaching an example of this type of chart for clarity. It appears to be similar to the stock (a.k.a. candlestick) chart but rather than four Y values (open, close, maximum, and minimum) per X value, there are:

- Upper whisker (upper horiz. thin line == maximum)
- 3rd quartile (top of box / bar)
- Median (thick line across box / bar)
- 1st quartile (bottom of box / bar)
- Lower whisker (lower horiz. thin line == minimum)

Currently, this type of chart is not specified in ODF v1.2.

Summary edited for clarity and so it shows up in searches for "chart".

I should also have been clearer in my last comment / example that the top and bottom box values (which I listed as "quartile") can be variable i.e., a custom percentile.

(In reply to comment #3)
> - Upper whisker (upper horiz. thin line == maximum)
> - 3rd quartile (top of box / bar)
> - Median (thick line across box / bar)
> - 1st quartile (bottom of box / bar)
> - Lower whisker (lower horiz. thin line == minimum)
> 

It should be noted that the whiskers are not always the maximum and minimum, but rather something like 1.5[1] the IQR (Inter Quartile Range). One of the most useful features of a box plot is that it allows you to see if there are extreme values.

[1] I say "something like" because there are apparently a few different styles. Another is 2 times the IQR IIRC.


To be exact, here's how my math book does one:

      Li   Q1______Md_____Q3       Ls
x x x |-----[______|______|--------|     x x

Where: 'x' are extreme values
IQR = Q3 - Q1
Li = max{minimum value, Q1 - 1.5 * IQR}
Ls = min{maximum value, Q3 + 1.5 * IQR}
Extreme values are those that are x such that x < Li or Ls < x

I do not know exactly which of these rules vary (I only know the "1.5" can).

http://web.pdx.edu/~stipakb/download/PA551/boxplot.html this page seems to discuss all the types of boxplots

Many thanks Olivier for clarify my poor attempt, the link in particular is excellent. Related Apache OO issue and OASIS issue added to the See Also list. I have sent an email to the OASIS office-comment mailing list to bring this bug to their attention, as the box plot chart type is indicated as being included in ODF v1.3.

Hi! Do you have any news about that?