writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 20:
Line 20: − + Line 26:
Line 26: − Where N1, N 2 ... are positive integers.+ − + +
→Examples
==Examples==
==Examples==
=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3<br/>
#=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3<br/>
'''Steps'''
'''Steps'''
#Mean=(50+52+ 54+ 56+ 58+ 60)/6 = 330/6 = 55
#Mean=(50+52+ 54+ 56+ 58+ 60)/6 = 330/6 = 55
#Average Deviation = 5+3+1+1+3+5)/6 = 3
#Average Deviation = 5+3+1+1+3+5)/6 = 3
#=AVEDEV(-20,40,-30,50,60) = 36
=AVEDEV (B2:B5) is 1.75
#=AVEDEV(-1.2,3.5,7,2,8.3,9.1) = 3.35
#=AVEDEV(B2:B5) = 1.75