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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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/
_______
 
Thank you so much. This helps a ton!

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top