Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Including error bars in a chart

  1. Jan 20, 2006 #1

    Monique

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    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.
     
  2. jcsd
  3. Jan 20, 2006 #2

    tmc

    User Avatar

    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.
     
  4. Jan 21, 2006 #3

    Monique

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    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 (Text):

    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
     
     
  5. Jan 21, 2006 #4

    Bystander

    User Avatar
    Science Advisor
    Homework Helper
    Gold Member

  6. Jan 21, 2006 #5

    Monique

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    I tried it out. It's for graphing formulas, it doesn't have a spreadsheet. Thanks for the suggestion though.
     
  7. Jan 21, 2006 #6

    tmc

    User Avatar

    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.
     
  8. Jan 21, 2006 #7

    Monique

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    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.
     
  9. May 13, 2006 #8
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Including error bars in a chart
Loading...