[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.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28560
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.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28560
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.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28560
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: No registered users and 19 guests