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

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

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/
_______


penguinchick wrote:

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

Thank you so much. This helps a ton!

"Jon Peltier" wrote:

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/
_______


penguinchick wrote:

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