Including error bars in a chart

  • Thread starter Monique
  • Start date
  • #1
Monique
Staff Emeritus
Science Advisor
Gold Member
4,149
64
Can anyone recommend some free software to me where you can make charts that include an error bar? OpenOffice Calc is not able to do that (I don't have access to Excel).

So as an example: I have a triplicate measurement of 77, 75 and 76. I want the graph to show 75 as the mean and then an error bar of +/- 1.
 

Answers and Replies

  • #2
tmc
289
1
If I understand this right, any spreadsheet program should do.
Enter your data, calculate the average, find the value furthest from it (max-avg / min-avg), and use that as the error. Then plot that as an error bar.

There probably is a program that does this for you, but I dont know any.
 
  • #3
Monique
Staff Emeritus
Science Advisor
Gold Member
4,149
64
But how do I include that as an error bar in a graph, the software I tried is not able to do a proper job.

For instance: I have four replicates and for each replicate I have 5 types of information. For each type of information I want to have a bar that has its own error bar.
Code:
big small round square pointy
1   10    55     23       6
3   15    54     22       5
2   2     55     24       8
2   12    60     20       5

2   9.8  56     22.25  6       average
.71 4.8  2.35   1.48   1.22    stdev
 
  • #4
Bystander
Science Advisor
Homework Helper
Gold Member
5,203
1,224
You might try http://students.washington.edu/bellc/grapher/index.php [Broken] . I think it's the same "Grapher" I ran into 20 years ago --- might not be, and I've no idea what features it still has, has added, or anything else. Caveat emptor, but at the price, ....
 
Last edited by a moderator:
  • #5
Monique
Staff Emeritus
Science Advisor
Gold Member
4,149
64
I tried it out. It's for graphing formulas, it doesn't have a spreadsheet. Thanks for the suggestion though.
 
  • #6
tmc
289
1
If you already have your data points and their respective error bars, the graphing program I use the most is called "Origin".

Excel also does error bars.
 
  • #7
Monique
Staff Emeritus
Science Advisor
Gold Member
4,149
64
Hm, yeah, €900 is a little too much money for error bars :smile:
I'll find a computer with Excel and plug in the data there.
 

Related Threads on Including error bars in a chart

  • Last Post
Replies
6
Views
3K
Replies
3
Views
652
Replies
11
Views
10K
Replies
3
Views
4K
  • Last Post
Replies
1
Views
2K
  • Last Post
Replies
1
Views
8K
Replies
10
Views
2K
Replies
1
Views
1K
Replies
11
Views
9K
Top