Author Message
Admin
Site Admin

Joined: 25 Sep 2007
Posts: 272

 Posted: Wed Dec 14, 2016 11:58 pm    Post subject: 'Standard deviation' and 'mean absolute deviation' in Excel In Excel you can calculate 'standard deviation' and 'mean absolute deviation' of your data points or samples, so to say, with STDEVA function and AVEDEV function. But before we proceed, let's make it clear what are these two deviations. The terms make you little bit confused. So let's get it clear first. Standard deviation is a measure of how widely your data points are dispersed or far away from the mean (from the average value). A low standard deviation means that the data points are close to the mean, while a high standard deviation indicates that the data points are spread apart (over a wider range) from the mean. Microsoft Excels's STDEVA function estimates standard deviation based on a sample. On the other hand, AVEDEV function returns you the average of the absolute deviations of your data points from their mean. That menas, it first calculates the absolute deviation of each data point from the mean, then calculates the mean or average value of the deviation. So how it will be for the above example: Mean = (21 + 8 + 3 + 15 + 9 + 26 + 4)/7 = 12.28571 Now calculate absolute deviation of each data point from the mean. Remember, it's absolute deviation, so you ignore the minus sign. so, |21 – 12.28571| = 8.714286 |8 – 12.28571| = 4.285714 |3 – 12.28571| = 9.285714 |15 – 12.28571| = 2.714286 |9 – 12.28571| = 3.285714 |26 – 12.28571| = 13.714286 |4 – 12.28571| = 8.285714 Now, sum of absolute deviations = (8.714286 + 4.285714 + 9.285714 + 2.714286 + 3.285714 + 13.714286 + 8.285714) = 50.285714 So the mean of absolute deviation = 50.285714/7 = 7.183673 Clear!! *Recommended: Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena. For comments of suggestions, please contact us: info@shamskm.com
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT + 2 Hours Page 1 of 1

 Jump to: Select a forum Forum Rules----------------General Rules Learn German Easily----------------German as a Foreign Language (Deutsch als Fremdsprache) Category----------------General ForumPolitics - commentsJokesScienceTechnology & How-To ForumEnvironmental Issues forumGeographic Information System (GIS) forumWebsites Related ForumPublic Health & Yoga forum Cappuccino & Espresso----------------Cappuccino & Espresso Job Posting----------------Job offerThe Space travellers
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group