writer
5,435
edits
Changes
no edit summary
<div style="font-size:30px">'''AVEDEV(n1,n2,n3)'''</div><br/>
<div style="font-size:30px">'''AVEDEV(n1,n2,n3...)'''</div><br/>
*<math>n1,n2,n3...</math> are any real numbers.
*<math>n1,n2,n3...</math> are any real numbers.
This function will give the result as error, when the text couldn't convert in to numbers.
This function will give the result as error, when the text couldn't convert in to numbers.
==Examples==
=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3
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
| class="sshl_f" |
|- class="even"
| class=" " | 6
|- class="odd"
| class="sshl_f" |
|- class="even"
| Row4
|- class="odd"
|- class="even"
| class="sshl_f" |
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