How do you add single standard error bars to an Excel 2008 graph?
Q. I know how to add all bars at once...but how do you add an individual standard deviation bar to only one collumn? pleaseee urgent! someone help me!
Asked by karabear0926 - Thu Jan 1 12:39:10 2009 - Software - 1 Answers - Comments

A. When you click on a one of the bars, the whole category is selected BUT When you click again on any of these columns, only that column will be selected. Try it So after you select only one of the columns (The one you want to have the standard error bar on) right-click and click properties and add that error bar Enjoy my profile, VBAXLMan is back
Answered by VBAXLMan - Fri Jan 2 04:31:03 2009

How do i know how to put "Error Bars" onto a graph?
Q. I recently got my Science coursework back from my teacher at school and on my graphs, she's written that i need to use Error Bars. I know about these but i have no idea how to put them on. As in, how large do they need to be on my data? Or where abouts they go. Thanks in advance This is on paper by the way, not the computer so please don't give any "Type (random excel code)" :)
Asked by bobbinator1992 - Thu Apr 3 14:30:29 2008 - Mathematics - 1 Answers - Comments

A. to put error bars on, you need to know how big the errors on your data are. If you are taking the data yourself, you can just estimate the errors at the time of observation. For instance, if you're measuring a length with a ruler you may estimate that there is an uncertainty of +-2 mm or some such amount. There are many subtleties in how to actually estimate the errors for you data, but i won't go into the details. The link below is a random image of some errobars. suppose you're plotting a graph y vs x, and the y-value are your dependent values. For a data point, (xo,yo). The top horizontal bar should be yo+err, and the bottom horizontal bar should be yo-err. The length of the horizontal bar is unimportant, as long as it's visible.
Answered by delps - Thu Apr 3 15:30:56 2008

How to make graph with error bars on Excel?
Q. It's a graph for bio class detailing reaction time vs substrate concentration, and they said it's okay to use the computer so I would like to learn how to do it properly on excel. Excel already had a couple of templates where it automatically graphed the scatter plot along with a line of best fit. Now I just need the error bars.
Asked by fye - Sun Sep 27 03:41:11 2009 - Software - 1 Answers - Comments

A. On your chart Right-click on one of your data series Select Format Data Series Select the X Error Bars tab or the Y Error Bars Tab You can define the errors by a fixed value or reference cells that have individual values for each data point. .
Answered by Cozmosis - Sun Sep 27 08:12:27 2009

An online graphing thing that does lines of best fit and error bars?
Q. Can anyone help me find a thing online that lets me graph a line of best fit and error bars to a graph. It would be absolutely amazing if you could help me out ASAP, because i can't seem to find one. And it'll take forever doing it by hand.
Asked by Toraibella - Wed Mar 17 22:12:45 2010 - Other - Education - 1 Answers - Comments

A.
Answered by - Wed Mar 17 22:20:52 2010

How do you get error bars on microsoft excel?
Q. I have a bar graph, with 3 bars, so 3 sets of data...and I need to add error bars...I'm using Excel 2010...how do I do it?!
Asked by s. strummer - Thu Mar 4 01:25:14 2010 - Software - 1 Answers - Comments

A. Slect your data series then Choose Analysis Error Bars and select from the available choices
Answered by - Sat Mar 6 16:30:21 2010

What do error bars indicate in psychology?
Q. does it indicate mean square error or variability of the data? Error bars are used to indicate: a. mean square error b. variability of the data c. test reliability d. categorical data e. experimental group Thanks
Asked by willie41288 - Wed Oct 27 21:37:43 2010 - Psychology - 1 Answers - Comments

A. B: variability of the data (usually +/- one standard deviation of the dataset).
Answered by - Thu Oct 28 17:59:53 2010

How do I introduce error bars in my excel graphs(bar chart)?
Q. I'm doing statiscal analysis of data in triplicate and I need 2 introduce error bars. Just aint too good with excel...HELP!!!
Asked by fredank_d_lion - Thu Nov 9 19:17:26 2006 - Software - 1 Answers - Comments

A. If you just double-click on the bars in the chart, the "Format Data Series" dialog box will come up; "Y Error Bars" is one of the tabs.
Answered by O Cacador - Thu Nov 9 22:16:36 2006

How to fix error bars on excel for mac?
Q. I am plotting a number of species on an excel column graph using excel for mac. Some species were counted individually, others by percentage cover. This has been fine and the graphs look correct at this point. However, when I try to add error bars using the standard error I calculated on some graphs it completely throws out the entire graphs- showing negative values, moving the bars so they are detached from the axis and floating displaying incorrect data. Any ideas on what is wrong with this? I am pretty sure the standard error was calculated correctly. Please help!
Asked by - Sun Apr 10 05:07:06 2011 - Software - 1 Answers - Comments

A. Which version of Excel for Mac are you using? Have you installed the updates (use Help > Check for updates)
Answered by jimgmacmvp - Sun Apr 10 12:00:08 2011

what does the graph look like when the error bars overlap?
Q. i really dont get how they can overlap eachother... like when they do, it means that the data is not reliable... i tried looking for images of overlaping error bars but could'nt find any. can anyone explain or find an image of overlapping error bars.. (whatever thats means) thanks in advance!
Asked by Jasmine. - Sun Feb 8 13:41:38 2009 - Physics - 1 Answers - Comments

A. Even though error bars do not overlap you cannot say with certainty the difference is statistically significant However when bars overlap then the difference between the two means is definitely not statistically significant..
Answered by GrahamH - Sun Feb 8 23:18:03 2009

Is it possible to put different error bars on each data point in excel or open office?
Q. I have a bar graph and i need to put a unique error bar on each chart bar. Is there a way to do this in excel or open office, and if so explain how.
Asked by - Tue Sep 20 10:23:38 2011 - Software - 1 Answers - Comments

why using the standard deviation as error bars tells a more complete story with the data?
Q. why using the standard deviation as error bars tells a more complete story with the data? ANy help pleasee? :(
Asked by Sarah<3 - Wed Sep 22 20:32:59 2010 - Biology - 1 Answers - Comments

A. It is more complete because std dev shows how much your results in the different trials have deviated from each other - in a sense, it calculates how consistent your results are. If you have a larger standard deviation, it shows that although you may have gotten an idea mean, your results are not accurate because not all your trials were consistent with the mean. With a smaller std dev, it shows that your experiment is more accurate because most of your test results show that they are near the mean.
Answered by - Sun Sep 26 05:08:37 2010

Can someone help me understand error bars?
Q. In Biology, I have to express my results on a graph, plotting the mean points. Then we have to do error bars, which is basically a big line between the largest value and the lowest. But I don't know how I'm supposed to interpret them. Like, if the bar is really big, does that mean the results have not been precise? Or if the error bar does not pass through the mean point, does that mean it's not been accurate? ANY help would be appreciated.
Asked by Catherine - Thu Oct 21 14:54:50 2010 - Other - Science - 1 Answers - Comments

A. In Biology, I have to express my results on a graph, plotting the mean points. Then we have to do error bars, which is basically a big line between the largest value and the lowest. No, usually error bars are +/- one standard deviation But I don't know how I'm supposed to interpret them. +/- one standard deviation. Like, if the bar is really big, does that mean the results have not been precise? Right. A big standard deviation means noisy data, or an answer that is not necessarily all that close to the correct value. Or if the error bar does not pass through the mean point, does that mean it's not been accurate? The error bar has to include the mean, as the bar goes from mean + 1 SD to mean - 1 SD. Wikipedia probably has an article on… [cont.]
Answered by redbeardthegiant - Fri Oct 22 14:31:52 2010

How do i make the error bars on my graph each a different size?
Q. Because each data point has a different number and they all come out the same when i use error bars.
Asked by NavyBoat - Thu Dec 4 14:03:14 2008 - Mathematics - 1 Answers - Comments

A. omg i need to know this right now too! i have no idea... i guess print it out and draw them in?
Answered by thisisawkward - Sun Dec 7 23:17:26 2008

Error bars on a line graph question?
Q. I want to show error bars on a line graph. Only, I don't want to do percentages type thing. The lines represent an average, and instead I was hoping to use a error bar for the highest and lowest values for that spacific series. Is this logical or even possible? Does this make sense?
Asked by Emily - Sat Apr 26 16:08:24 2008 - Other - Science - 1 Answers - Comments

A. It's acceptable as long as you say in the caption of the graph that the error bars delineate the range of all results. There are a number of ways to show error bars. Most people want their error bars to be as small as possible (it makes their work look more accurate) so they use standard error (preferably if they know they have normality in the data) or confidence intervals based on Student's T or Pearson's Chi-square, and I'm sure there's other methods. Even showing standard deviation would usually produce smaller error bars than your whole range of results. But it's up to you. Just be sure to explicitly state your methods.
Answered by 1ofU - Sat Apr 26 19:35:41 2008

What are "error bars" in AP Physics B graphs?
Q. The question says: Draw in "error bars" on your displacement versus time graphs for the displacement measurement. What does this mean?
Asked by - Sun Sep 20 18:44:59 2009 - Physics - 1 Answers - Comments

A. I think it means "experimental error". For instance if you were going to record the time when a car reaches x = 50 metres lets say, maybe you would stop the watch at 49.9 metres or 50.1 metres as your best effort to record the time at 50 metres.
Answered by ctx - Sun Sep 20 19:00:58 2009

How do you plot error bars when representing data on a semilog scale?
Q. I have a set of means that I want to depict on a semilog y scale. So I took the log of these mean values and plotted them on graph paper. Now how do I plot the error bars representing standard deviation on this graph? I don't understand how the standard deviation changes when we're depicting the data on a semilog scale.
Asked by teacher's pet - Mon Dec 27 21:08:51 2010 - Mathematics - 1 Answers - Comments

A. There is no good exact formula for this. A reasonable approximation is to take SD(log(y)) = SD(y)/mean(Y). In your case, this means to divide the standard deviation you calculated _before_ taking logs by the sample mean _before_ taking logs. Then, set up the error bars the way you normally would, without the transformation.
Answered by - Mon Dec 27 21:35:42 2010

What do error bars on a graph mean or show?
Q. Error bars are used on graphs to indicate the error, or uncertainty in a reported measurement (wiki) What does this mean? Please include your source if possible Thanks
Asked by jzz r (Left Y/A for good) - Fri Mar 26 00:47:31 2010 - Mathematics - 1 Answers - Comments

A. Most often the error bars represent the standard deviation from the data points.
Answered by Funny - Fri Mar 26 00:49:08 2010

how do you create error bars for a set of points in excel 2007?
Q. i have a graph (exponential in nature) with 6 points. however, each of these 6 points have a different uncertainty. eg the first point as an uncertainty of plus/minus 2.3, the second an uncertainty of plus/minus 3.8 etc. i would like to create these vertical error bars on excel 2007 so please help!!!
Asked by jack.highwater - Fri Mar 13 03:42:52 2009 - Software - 1 Answers - Comments

A. Put your error values in a column Right-click on the line on the chart Select Format Data Series Select the Y Error Bars tab Select Custom Select the cells that you put the errors in for both the plus and minus error values
Answered by Cozmosis - Fri Mar 13 04:04:30 2009

How do you put in error bars in excel 2007?
Q. I know there's an option under the layout tab, but whenever I click it to add the standard error, the error bars all end up the same size. When I did calculations for the standard error of my values, I had different values for each y point; some small and some large. So when I put the bars in excel, they should all be different lengths. Anyone know how to get the appropriate error bars for standard error?
Asked by j_s_j_c_c - Sun May 17 22:17:58 2009 - Software - 2 Answers - Comments

A. Instead of the standard error, select custom: plus and minus and select the cells where you calculated the plus and minus errors e.g. 1/2 your calculated errors for each cell.
Answered by Cozmosis - Sun May 17 23:59:31 2009

Are standard deviation and error bars on a graph the same thing?
Q. i know that for standard deviation, I just plug in the numbers into a formula. What are error bars? I'm analyzing cancer cell viability for each concentration of drug tested.
Asked by CB - Fri Apr 18 23:00:37 2008 - Mathematics - 1 Answers - Comments

A. Well I guess they are what you get when you plug the numbers into a statistical graphing program. Ok enuf sarcasm. Error bars represent the uncertainty surrounding the measurement. Sometimes BOTH the x value (the independent variable) and the y value (the dependent variable) each have uncertainties so you need both vertical and horizontal error bars. The length of the error bars is set by convention. So it depends on the discipline that you are doing research in. Some disciplines use 2.5 s.d., some use 3 s.d. and some use only one s.d. (And thats assuming that the distribution of responses is normally distributed). At other times, the size of the error bars is not determined by the standard deviation. A goofd example of that is measuring… [cont.]
Answered by odimwitdwon - Fri Apr 18 23:22:42 2008