April 2024
Intermediate to advanced
824 pages
36h 45m
English
Content preview from Business Statistics
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
128 Business Statistics
4.4.10 Using MS Excel, Minitab, and SPSS for Computing Mean Absolute Deviation
MS Excel’s computing ability can be used to compute mean absolute deviation. Minitab and SPSS
can also be used to compute mean absolute deviation through Calculator dialog box and Compute
Variable dialog box, respectively. Figure 4.7 is an MS Excel sheet exhibiting computation of mean
absolute deviation for Example 4.5.
4.4.11 Merits and Demerits of Mean Deviation
The serious limitation of mean absolute deviation in terms of its incapability of algebraic treatment
has restricted its wide use. Mean absolute deviation is useful in some areas ...