Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
Incorrect result using AVEDEV formula | Excel Discussion (Misc queries) | |||
plots sent to to a chart tab do not show plot & I loss the plot | Charts and Charting in Excel | |||
avedev | Excel Worksheet Functions | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |