[Solved] How to change Y error bars for each datum point

Discuss the spreadsheet application

[Solved] How to change Y error bars for each datum point

Postby JonathanPower » Mon Apr 09, 2012 1:27 pm

I need to show for each single point the variation error range.

I have many Y values each value is a different mean with its corresponding standard deviation that needs to be shown in the graph.

When I try to use the "Insert Y bars errors option", the program add the same error bar for all the points, but I need to be able to add a different error bar for each single Y value, to be able to make a chart like this:

gt-stat-fig8.gif

Is this even possible in calc ?
Last edited by JonathanPower on Mon Apr 09, 2012 10:35 pm, edited 2 times in total.
OpenOffice 3.3 on Windows xp
JonathanPower
 
Posts: 20
Joined: Sun Feb 05, 2012 11:20 am

Re: How to change Y error bars for each datum point in a gra

Postby Hagar Delest » Mon Apr 09, 2012 2:19 pm

Yes, it's possible, you can apply a range of errors, see: [Solved] Y-Error Bars Incorrect.

Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28830
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to change Y error bars for each datum point in a gra

Postby JonathanPower » Mon Apr 09, 2012 8:59 pm

Thanks, however there is no explanation on how actually you can do this, so I still don't konw who can I do this.
OpenOffice 3.3 on Windows xp
JonathanPower
 
Posts: 20
Joined: Sun Feb 05, 2012 11:20 am

Re: How to change Y error bars for each datum point in a gra

Postby Hagar Delest » Mon Apr 09, 2012 9:37 pm

Check the attachment in the other topic and the options in the error bars dialog (see help file also!):
Error bar.png

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28830
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to change Y error bars for each datum point in a gra

Postby JonathanPower » Mon Apr 09, 2012 9:48 pm

Hagar Delest wrote:Check the attachment in the other topic and the options in the error bars dialog (see help file also!):
Error bar.png

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.


Thanks. My problem is that I have no idea what those "$shett.1$, ecc" simbols mean, Does the "$sheet1.$C$12:$I$12" mean that the progam is taking all the values on row 12 from letter "I" to letter "C" ? Is there a tutorial for understanding what those simbols mean ?

Thank you very much.
OpenOffice 3.3 on Windows xp
JonathanPower
 
Posts: 20
Joined: Sun Feb 05, 2012 11:20 am

Re: How to change Y error bars for each datum point in a gra

Postby Hagar Delest » Mon Apr 09, 2012 9:56 pm

You got it, the field is the range to be taken into account. You should indeed read some tutorial, see:
- [Tutorial] Absolute, relative and mixed references
- [Tutorial] Ten concepts that every Calc user should know

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28830
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to change Y error bars for each datum point in a gra

Postby JonathanPower » Mon Apr 09, 2012 10:33 pm

Hagar Delest wrote:You got it, the field is the range to be taken into account. You should indeed read some tutorial, see:
- [Tutorial] Absolute, relative and mixed references
- [Tutorial] Ten concepts that every Calc user should know

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.


I was really surprised when I discoveder that I was undertant this...it seemed too mucn complicated at first but your images was incredibly helpful.

Thanks for your help.
OpenOffice 3.3 on Windows xp
JonathanPower
 
Posts: 20
Joined: Sun Feb 05, 2012 11:20 am


Return to Calc

Who is online

Users browsing this forum: lvlanson and 13 guests