writer
5,435
edits
Changes
→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 = <math>\frac{50+52+ 54+ 56+ 58+ 60}{6} = \frac{330}{6} = 55</math>
#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 = <math>\frac{5+3+1+1+3+5}{6} = 3</math>
*=AVEDEV(-20,40,-30,50,60) = 36
*=AVEDEV(-20,40,-30,50,60) = 36
*=AVEDEV(-1.2,3.5,7,2,8.3,9.1) = 3.35
*=AVEDEV(-1.2,3.5,7,2,8.3,9.1) = 3.35