atom feed4 messages in org.oasis-open.lists.officeRe: [office] Proposal: Error bar cate...
FromSent OnAttachments
Michael Brauer - Sun Germany - ham02 - HamburgFeb 1, 2008 5:03 am 
robe...@us.ibm.comFeb 3, 2008 10:08 am 
Michael Brauer - Sun Germany - ham02 - HamburgFeb 22, 2008 7:42 am 
robe...@us.ibm.comFeb 22, 2008 7:52 am 
Subject:Re: [office] Proposal: Error bar category standard-error
From:Michael Brauer - Sun Germany - ham02 - Hamburg (Mich@Sun.COM)
Date:Feb 22, 2008 7:42:56 am
List:org.oasis-open.lists.office

Hi Rob,

robe@us.ibm.com wrote:

"Standard error (standard deviation of the mean) of a data series assuming an equal distribution"

I believe "assuming a normal distribution" is the typical wording. In that case the standard error = StandardDeviation/Sqrt(N)

Just to make sure I did understand that correctly:

What you propose is that we use the following description:

* Standard error (standard deviation of the mean) of a data series assuming a normal distribution

Is that correct?

Michael

-Rob

___________________________

Rob Weir Software Architect Workplace, Portal and Collaboration Software IBM Software Group

email: robe@us.ibm.com phone: 1-978-399-7122 blog: http://www.robweir.com/blog/

*Michael Brauer - Sun Germany - ham02 - Hamburg <Mich@Sun.COM>* Sent by: Mich@Sun.COM

02/01/2008 07:51 AM

To off@lists.oasis-open.org cc

Subject [office] Proposal: Error bar category standard-error

Hi,

while implementing the ODF 1.2 enhancements for the error category of business charts, OOo Chart's developer Björn Milcke noticed that one value in the "choice" for the chart:error-category is missing: the standard-error. It's a reasonable value, that some applications do support already.

He therefore proposed the following small enhancement:

In chapter "16.33.2 Error Category" add the following value to the choices for the error-category:

[..]

* Standard error (standard deviation of the mean) of a data series assuming an equal distribution

[..]

<define name="style-chart-properties-attlist" combine="interleave"> <optional> <attribute name="chart:error-category" a:defaultValue="none"> <choice> <value>none</value> <value>variance</value> <value>standard-deviation</value> <value>percentage</value> <value>error-margin</value> <value>constant</value> * new * <value>standard-error</value> <value>cell-range</value> </choice> </attribute> </optional> </define>

Best regards

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Amtsgericht Muenchen: HRB 161028 Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering