Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a chart that I just cannot figure out how to graph.
It is some survey results and the mean and standard deviation of each question. I want the horizontal axis to list 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0, 4.5, and 5.0. I want the vertical axis to list the question topic: eg, a, b, c, d, e, f, g, h, and i. For each question, I want to show the mean answer and the standard deviation on a bar, with a point for the mean and the endpoints being the +/- standard deviation. Examples of the data: Question a - Mean = 3.6875 Std. Dev. = .59387 Question b - Mean = 3.8958 Std. Dev. = .67810 Question c - Mean = 3.1875 Std. Dev. = .65730 etc. How can I set this up to create a chart like what I need, where I basically have a bar that stretches plus or minus the standard deviation, with the mean in the center? Thanks, Kim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Outlier analysis in excel - trimming means | Excel Worksheet Functions | |||
plot histogram & indicate means and std deviation | Excel Discussion (Misc queries) | |||
Statistic: Problem with two one sided t-test | Excel Discussion (Misc queries) |