A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Plotting mean and standarddeviation (boxplot?)



 
 
Thread Tools Display Modes
  #1  
Old September 26th, 2003, 10:10 AM
Mette Dencker Johansen
external usenet poster
 
Posts: n/a
Default 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  
Old September 26th, 2003, 06:24 PM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default 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  
Old September 26th, 2003, 06:25 PM
dvt
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:56 AM.


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