How do I plot AVEDEV?
in [Charts]
|
Prev: xlStockVOHLC chart with extra xlColumnClustered series
Next: How to change document from a Chart to spreadsheet
From: Graeme on 11 Feb 2010 06:00 How do I plot Mean Average Deviation -the AVEDEV funcation - as opposed to standard deviation? Any suggestions? Thanks, Graeme
From: Mike Middleton on 11 Feb 2010 14:13
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" <Graeme(a)discussions.microsoft.com> wrote in message news:E6928946-C5BC-4091-A6B7-96451C9E1BC2(a)microsoft.com... How do I plot Mean Average Deviation -the AVEDEV funcation - as opposed to standard deviation? Any suggestions? Thanks, Graeme |