need to make chart w/ confidence intervals and don't know how

[Guest]

I need to make a graph that shows four means w/ associated confidence
intervals and I have no idea how to do so. Any advice would be much
appreciated. Thanks!
Pchick

 

[Jon Peltier]

Do you know what the confidence intervals are at each of your data
points? Put the ± values into tow columns next to the column that
contains your four means. Plot your four means in an appropriate chart
type, then apply error bars, using the ± interval values for the width
of custom error bars.

See this web page for an illustrated example:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thank you so much. This helps a ton!

Do you know what the confidence intervals are at each of your data
points? Put the ± values into tow columns next to the column that
contains your four means. Plot your four means in an appropriate chart
type, then apply error bars, using the ± interval values for the width
of custom error bars.

See this web page for an illustrated example:

http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______