Changes

Manuals/calci/AVEDEV (view source)

25 bytes added , 09:44, 21 November 2013

Line 20: Line 20:

==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'''

#Mean=(50+52+ 54+ 56+ 58+ 60)/6 = 330/6 = 55

Line 26: Line 26:

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

−

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

+

#=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

writer

5,435

edits