If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plotting mean and standarddeviation (boxplot?)
Hi
Could anybody help me on this: I want to plot the mean and standard deviation as a function of, say, time (I know that it will be discrete in time), with the mean marked with a dot and mean+standard deviation as a short horizontal line, connected to the mean-dot by a vertical line and mean-standard deviation the same way. It may be what is called a box plot, but I'm not sure... Thank you! /Mette |
#2
|
|||
|
|||
Plotting mean and standarddeviation (boxplot?)
This will be a lot easier to do if you swap the layout.
Put the time in a column to the right of the mean values. If you don't want to mess your existing data set, use a copy. Now, plot a XY Scatter chart using a subtype that includes a line. The means will be on the x-axis and the times will be on the y-axis. Now, double-click plotted series, then select the 'X Error Bars' tab. In there, in the Display section select the 'Both' option. In the 'Error Amount' section, select the Custom option. For both the + and - values specify the same standard deviation values you have. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi Could anybody help me on this: I want to plot the mean and standard deviation as a function of, say, time (I know that it will be discrete in time), with the mean marked with a dot and mean+standard deviation as a short horizontal line, connected to the mean-dot by a vertical line and mean-standard deviation the same way. It may be what is called a box plot, but I'm not sure... Thank you! /Mette |
#3
|
|||
|
|||
Plotting mean and standarddeviation (boxplot?)
Mette Dencker Johansen wrote:
Hi Could anybody help me on this: I want to plot the mean and standard deviation as a function of, say, time (I know that it will be discrete in time), with the mean marked with a dot and mean+standard deviation as a short horizontal line, connected to the mean-dot by a vertical line and mean-standard deviation the same way. It may be what is called a box plot, but I'm not sure... Thank you! /Mette I think you only need error bars, which are built into Excel. If you have an XY chart, select the series by clicking on it and from the menu Format | Selected series | Y Error Bars tab. Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|