Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
penguinchick
 
Posts: n/a
Default 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
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

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

  #3   Report Post  
penguinchick
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"