writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 19:
Line 19: − Logical values and text representations of numbers are calculated. + − + − Formula:-+ − The equation to find out the average deviation is: + − + − {| id="TABLE3" class="SpreadSheet blue"+ − |- class="even" − | class=" " | − − | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − | class=" " | 7 − | class="sshl_f" | 1.75 − | class="sshl_f" | − − − | class=" " | Row2 − − | class="sshl_f SelectTD SelectTD" | − − | class="sshl_f" | − | class="sshl_f" | − − | Row3 − | class=" " | 9 − | class="sshl_f" | − | class="sshl_f" | − − − − | class="sshl_f " | 3 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − − | class=" " | Row5 − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − | 0 − − | Row6 − − | class="sshl_f" | − | class="sshl_f" | − | class="sshl_f" | − |}
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