Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|