Standard Deviation Error Bars - Excel 2010

I am using Excel 2010 and for my biology lab we need to include error bars on the graphs using standard deviation. My teacher has Excel 2003 on her laptop and explained to my class how to get the error bars. The way she showed doesnt work because of the clash of programs. On my graphs I have 3 different series; 5 minutes, 10 minutes, and differnce. For every series we are supposed to put in the standard deviation, but when I try this it doesnt work. Can someone please explain this? I'm really confused about this. Any help will be appreciated.
Hello,
Thank you for posting. We would require few more information on the issue so that we can assist you better.
1. What type of chart are you trying create?
2. What happens when you try to put the standard deviation into the chart?
3. Do you get any error message?
You may refer the article mentioned below which explains on how to add error bars into Excel 2007:
Reply with the required details, we will be happy to help you.
Thanks.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Here are some more examples:
Deviation Column Charts

Run Chart with Mean and Standard Deviation Lines

Drawing a Normal curve

http://www.tushar-mehta.com/excel/charts/normal_distribution/

Introduction A graph that represents the density function of the Normal probability distribution is also known as a Normal Curve or a Bell Curve (see Figure 1 below).  The Normal distribution requires two parameters, the mean and the standard deviation.  A Normal distribution with a mean of zero and a standard deviation of 1 is also known as the Standard Normal Distribution (m=0, s=1) as in Figure 1.


"Stay together, by staying apart"
Covid19
.
"It is not because things are difficult that we do not dare,
it is because we do not dare that they are difficult."
- Lucius Annaeus Seneca 5BC-65AD
.
ꙨပꙨ

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

1. My teacher told us that we have to use a scatter plot for the error bars and that we were to only use the Y-axis bars.

2. My teacher said to use the STDEV as the + or - value.

3. I didnt get any error messages, but it didnt turn out the way my teacher had shown us.

 

Can the graphs be put together as one, or do they have to be separate??

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Check the interactive guide below:
http://office.microsoft.com/en-us/excel-help/interactive-excel-2003-to-excel-2007-command-reference-guide-HA010149151.aspx

If you know how to perform a task in Excel 2003, this guide will show the same options in Excel 2007.


Regards,
Marcus DAlmeida

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated September 20, 2019 Views 3,138 Applies to: