Including error bars in a chart

  • Thread starter Thread starter Monique
  • Start date Start date
  • Tags Tags
    Error Error bars
AI Thread Summary
Free software options for creating charts with error bars include Gnuplot and R, which can handle statistical data effectively. Users discussed the need to calculate averages and standard deviations to represent error bars accurately. While OpenOffice Calc was found inadequate for this purpose, some participants suggested exploring online tools like the Grapher. Excel is a popular choice for error bars, but its cost can be prohibitive. Overall, various alternatives exist for users seeking to visualize data with error bars without relying on expensive software.
Monique
Staff Emeritus
Science Advisor
Gold Member
Messages
4,211
Reaction score
68
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.
 
Physics news on Phys.org
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 don't know any.
 
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
 
You might try http://students.washington.edu/bellc/grapher/index.php . 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:
I tried it out. It's for graphing formulas, it doesn't have a spreadsheet. Thanks for the suggestion though.
 
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.
 
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.
 
Back
Top