Apache OpenOffice (AOO) Bugzilla – Issue 13184
add Box plot, Whisker plot , Five-number summary
Last modified: 2016-05-29 01:51:59 UTC
In education I will not use special statistic tools but I use spreadsheets. In this context it would be nice to have boxplots. Perhabs you can get them by modifying a Stock Chart. Wenn you use 25%-Quantil, 100%-Quantil, 0%-Quantil and 75%-Quantil in this order with Stock Chart Typ 2, you get nearly a boxplot. The only think missing is a line for the 50%-Quantil. kind regards Regina Henschel
HI Bettina, one for you.
Set to "NEW"
Reassigned to Ingrid.
Seems that this would be a good idea for statistical analysis.
*** Issue 84836 has been marked as a duplicate of this issue. ***
This will be also added in ODF 1.2, right???
reset to new
You can almost get a box and whisker plot by combining two features: the QUARTILE function and the Stock chart. 1. First get OpenOffice to work out the quartiles: Assuming your data is in columns – add 5 rows at the top (immediately under the title for each column if you have one) and 2 columns at the start. In the first new column (new 5 rows) insert the numbers 1,0,4,3,2 and in the second the labels q1, min, max, q3 and median (this specific order makes the chart work). Then into the first new space above your first column of data insert the function “=QUARTILE(C$8:C$12;$A2)" – where C8 to C12 are the cells your first column of data is in and A2 is the cell you just added and typed 1 (ie first new row, first new column. Note where to put the $ - they mean you can just copy that function across all your columns of data (and only type it once). After copying it across, If you have different number of entries in each column change the '12' it represents the last entry. Then copy the function down to fill all your new cells, which should now have calculated and be showing the quartiles for your chart. 2. Now draw your chart. Select your new cells (except the first column and last row) – ie start with “q1” (or the cell above it if you have titles for each column) and finish with the row opposite q3 in your last column of data. Insert – Chart – and choose the second variety of “Stock” charts. Press next in the Chart wizard and change the first choice on the page to “Data series in rows”. Go through the wizard and add titles (and remove legend unless it shows something you want). When you finish your box and whisker chart will be inserted. This method doesn't show the median /mean line in the middle of each box that you would normally have, but you can add it manually (median is calculated for you in the bottom of the rows you just added). Hence my "almost" at the start of this post.