Changes

==Examples==

==Examples==

=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3

=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

#Deviation=|50-55|,|52-55|,|54-55|,|56-55|,|58-55|,|60-55|=5,3,1,1,3,5

Deviation=|50-55|,|52-55|,|54-55|,|56-55|,|58-55|,|60-55|=5,3,1,1,3,5

#Average Deviation = 5+3+1+1+3+5)/6 = 3

Average Deviation = 5+3+1+1+3+5)/6 = 3

Where N1, N 2 ...   are positive integers.

Where N1, N 2 ...   are positive integers.

=AVEDEV (B2:B5) is 1.75

=AVEDEV (B2:B5) is 1.75