writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 21:
Line 21: − + − #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+ − #Average Deviation = 5+3+1+1+3+5)/6 = 3+
→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
#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
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