ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I plot AVEDEV? (https://www.excelbanter.com/charts-charting-excel/256032-how-do-i-plot-avedev.html)

Graeme

How do I plot AVEDEV?
 
How do I plot Mean Average Deviation -the AVEDEV funcation - as opposed to
standard deviation?

Any suggestions?

Thanks, Graeme

Mike Middleton

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



All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com