View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default How do I plot AVEDEV?

Graeme -

AVEDEV, i.e., the average of absolute deviations from the mean, is a
single-number summary measure of dispersion.

Usually, I do not "plot" such a number. What kind of plot are you
developing?

Regarding standard deviation (stdev), on a histogram (column chart of the
frequency distribution of a set of data), one might plot vertical lines for
"mean minus two stdev" and "mean plus two stdev" to show a 95% range. See
Jon Peltier's methods at http://peltiertech.com/Excel/Charts/AddLine.html

- Mike
http://www.MikeMiddleton.com


"Graeme" wrote in message
...
How do I plot Mean Average Deviation -the AVEDEV funcation - as opposed to
standard deviation?

Any suggestions?

Thanks, Graeme