[OASIS Issue Tracker] (OFFICE-3664) Additional chart type: box plot

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ https://issues.oasis-open.org/browse/OFFICE-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=81073#comment-81073 ] 

Regina Henschel commented on OFFICE-3664:
-----------------------------------------

I have found something about outliers in Excel

[https://techcommunity.microsoft.com/t5/excel/excel-box-and-whiskers/m-p/1526455]

So Excel identifies outliers by rule Q3+1.5*IQR and Q1-1.5*IQR respectively. And for calculating Q1 and Q3 and IQR=Q3-Q1 the attribute quartileMethod is evaluated.

> Additional chart type: box plot
> -------------------------------
>
>                 Key: OFFICE-3664
>                 URL: https://issues.oasis-open.org/browse/OFFICE-3664
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: Chart, Part 1 (Schema)
>    Affects Versions: ODF 1.3
>            Reporter: Andreas Guelzow
>            Assignee: Andreas Guelzow
>            Priority: Major
>             Fix For: ODF 1.4
>
>         Attachments: BockplotExcel.xlsx
>
>
> Some ODF implementation provides box-plot charts not supported within ODF 1.2. THis type (with appropriate attributes to specify its properties) should be added to ODF.



--
This message was sent by Atlassian Jira
(v8.3.3#803004)