[Issue] Custom standard error in chart

Discuss the spreadsheet application

[Issue] Custom standard error in chart

Postby Ligtenstein » Mon Nov 26, 2007 11:51 pm

I do not see how I can insert measured standard deviations into a chart. The problem is as follows. I have 3 colums. One with time, one with the values as plotted against the time, these values being a mean of several measurements. The third colum is the standard deviation as calculated for each value plotted. The latter I want to represent as error bars for each value. Does anyone know how to do that?
Ligtenstein
 
Posts: 1
Joined: Mon Nov 26, 2007 10:58 am

Re: Standard error in chart

Postby Hagar Delest » Wed Nov 28, 2007 11:52 pm

Ligtenstein wrote:I do not see how I can insert measured standard deviations into a chart.

Not possible yet. You should subscribe and vote for that feature request : Issue 66788 - Error bars: Standard deviation based on sample.
Note that there I've also opened a bug report about standard deviation representation : Issue 72331 - Wrong error indicator for standard deviation.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28996
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Issue] Custom standard error in chart

Postby bmilcke » Wed Dec 19, 2007 6:45 pm

In fact the issue you are looking for is Issue 366. It is planned to implement this for OOo 3.0.
User avatar
bmilcke
 
Posts: 1
Joined: Wed Dec 19, 2007 6:19 pm
Location: Hamburg, Germany

Re: [Issue] Custom standard error in chart

Postby AndrewZ » Fri Mar 21, 2008 12:06 am

The "Y error bars in charts" feature issue #366 (134 votes) is implemented for OpenOffice.org 3.0 and is ready for testing now. Please try to break it and report any bugs.

Article: An Early Look At New Features in OpenOffice.org

Image

Image

This is an old post, so this reply is partially "for the record' (such as people searching the archives).
<signature>
* Did you solve your problem? Do others a favor: Post the solution
* Visit OpenOffice.org Ninja (blog) and OpenOffice.org Ninja Wiki for news, previews, troubleshooting, etc.
</signature>
OOo 3.0.X on Fedora 9 + XP
User avatar
AndrewZ
Volunteer
 
Posts: 633
Joined: Mon Oct 08, 2007 1:25 am
Location: Colorado, USA

Re: [Issue] Custom standard error in chart

Postby Cambirder » Fri Apr 18, 2008 3:26 pm

Unfortunately although standard deviation error bars can be added in 3.0 instead of the error bars centering on the mean they incorrectly center on each plot, but I have come up with a work around which is illustrated below

SD1.png
SD1.png (7.76 KiB) Viewed 6155 times


Column C is the mean and in the above case this is hidden as it is plotted as an invisible line. At D2 I've calculated the SD using the formula =STDEV($B$2:$B$5) which I've simple copied down to D4.

I have then added the error bars to the plot of the mean using the following settings.

SD2.png
SD2.png (8.11 KiB) Viewed 6157 times


Hopefully by the time 3.0 is in RC stage this glitch will have been sorted.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: [Issue] Custom standard error in chart

Postby Cambirder » Fri Apr 18, 2008 3:35 pm

Another solution is to avoid error bars altogether and plot horizontal lines to represent mean+SD & mean - SD as in the following example. I actually prefer to show SD this way, and it can be done on 2.4 and earlier versions.

SD3.png
SD3.png (6.02 KiB) Viewed 6148 times


The formula D2 is C2+STDEV($B$2:$B$5) and in E2 C2-STDEV($B$2:$B$5)
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: [Issue] Custom standard error in chart

Postby Hagar Delest » Fri Apr 18, 2008 3:36 pm

Thanks, that's at least a nice workaround for the Issue 72331 I'd filed (link above). I'll add a comment to point to that trick!
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28996
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 25 guests