Including error bars in a chart

  • Context: High School 
  • Thread starter Thread starter Monique
  • Start date Start date
  • Tags Tags
    Error Error bars
Click For Summary

Discussion Overview

The discussion revolves around the challenge of creating charts with error bars using free software alternatives, particularly in the absence of Excel. Participants share their experiences and suggestions for software that can accommodate error bars in graphical representations of data.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant seeks free software for creating charts with error bars, noting that OpenOffice Calc does not meet their needs.
  • Another participant suggests that any spreadsheet program should suffice for calculating averages and error values, although they are unsure of specific software that automates this process.
  • A participant expresses difficulty in including error bars for multiple data types in their graph, providing a detailed example of their data structure.
  • One suggestion includes a link to a graphing tool called "Grapher," though its current capabilities are uncertain.
  • A participant tests the suggested "Grapher" tool and finds it unsuitable for their needs, as it does not function as a spreadsheet.
  • Another participant mentions using "Origin" for graphing, which supports error bars, while also noting that Excel does this as well.
  • A participant humorously remarks on the high cost of "Origin" software, indicating they will seek access to Excel instead.
  • Additional software suggestions include Gnuplot, R, and Hippodraw, with links provided for each.

Areas of Agreement / Disagreement

Participants do not reach a consensus on a specific software solution, and multiple competing views and suggestions remain throughout the discussion.

Contextual Notes

Some participants express uncertainty about the capabilities of the suggested software, and there are varying levels of familiarity with the tools mentioned. The discussion reflects a range of needs based on different data structures and software functionalities.

Who May Find This Useful

This discussion may be useful for individuals seeking free software options for creating charts with error bars, particularly in scientific or academic contexts where data visualization is required.

Monique
Staff Emeritus
Science Advisor
Gold Member
Messages
4,229
Reaction score
61
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.
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 6 ·
Replies
6
Views
8K
  • · Replies 43 ·
2
Replies
43
Views
6K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 19 ·
Replies
19
Views
8K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
5K