OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: [OASIS Issue Tracker] Commented: (OFFICE-2295) STDEVA

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18352#action_18352 ] 

Dennis Hamilton commented on OFFICE-2295:

I just assumed this was a simple matter of definition.   In looking at the definitions of STDEV, STDEVA, STDEVP, and STDEVPA, though, it dawned on me how serious it is to treat non-numerical values as 0.

Has this been given serious discussion?  Considering that implementations of STDEVA are apparently all over the map, maybe this is a function to leave out or somehow deprecate?

The problem is that inserting values as 0 has serious impact on the results, because it changes the value of "n" and it also change the value of the mean, (x-overline).  The introduction of 0 values can be quite serious in terms of the quality of the result.

I just want to make sure we understand the consequences of that approach, rather than leaving the STDEVA case for non-numeric values in the sample as implementation-defined (or even implementation-dependent and deprecated).  It looks like there is no way to reconcile the behavior of different implementations or of formulas converted from different current implementtions.

PS: It would be nice to have one of these determine an error value whenever the sample/set included cells/values that don't yield Number values. 

PPS:  I don't think it is useful to have LEGACY.* variants that allow conversion from other formulas.  I don't think that is satisfying here because there is no way to convert among those variants and each other or whatever non-legacy cases are included in the OpenFormula specification.

> -------
>                 Key: OFFICE-2295
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2295
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Sub-task
>          Components: OpenFormula
>            Reporter: Robert Weir 
>            Assignee: Andreas Guelzow 
>             Fix For: ODF 1.2 Part 2 CD 1
> == 6.17.71 STDEVA ==
> The text "cells with text are converted to 0;" conflicts with "The 
> handling of strings is implementation defined."

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]