Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

'Standard deviation' and 'mean absolute deviation' in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 272

PostPosted: Wed Dec 14, 2016 11:58 pm    Post subject: 'Standard deviation' and 'mean absolute deviation' in Excel Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
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