Posts tagged bars

HOW TO MAKE GRAPH WITH ERROR BARS ON EXCEL?


It’s a graph for bio class detailing reaction time vs substrate concentration, and they stated it’s okay to use the personal 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 ideal fit. Now I just need the error bars.

HOW DO YOU PUT IN ERROR BARS IN EXCEL 2007?


I know there is 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?

HOW CAN I DISPLAY ERROR BARS WITH AN EXCEL BAR GRAPH?

I want to display error bars (standard error of the mean) in a bar graph?
I want to graph the effect of task (difficult task versus simple) on a performance measure using the bar graph function in excel. It grants me to insert error bars but it assumes the error is the same for both conditions. So, when I try to insert error bars for standard error, it assumes the standard error is the same for both conditions. It is not.