Difference between revisions of "Manuals/calci/AVEDEV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></fo...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''AVEDEV(n1,n2,n3)'''</div><br/> |
| − | + | *<math>n1,n2,n3...</math> are positive integers. | |
| − | |||
| − | + | *AVEDEV returns the average of the absolute deviations of data points from their mean. | |
| + | *Arguments can be numbers, names, arrays, or references. | ||
| − | + | Logical values and text representations of numbers are calculated. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Formula:- | Formula:- | ||
| − | + | The equation to find out the average deviation is: | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | + | ||
| Column1 | | Column1 | ||
| class=" " | Column2 | | class=" " | Column2 | ||
| Line 51: | Line 28: | ||
| class=" " | 6 | | class=" " | 6 | ||
| class="sshl_f SelectTD SelectTD" | | | class="sshl_f SelectTD SelectTD" | | ||
| − | + | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 80: | Line 57: | ||
|} | |} | ||
| − | + | Where N1, N 2 ... are positive integers. | |
| − | + | =AVEDEV (B2:B5) is 1.75 | |
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:51, 21 November 2013
AVEDEV(n1,n2,n3)
- are positive integers.
are positive integers.- AVEDEV returns the average of the absolute deviations of data points from their mean.
- Arguments can be numbers, names, arrays, or references.
Logical values and text representations of numbers are calculated.
Formula:- The equation to find out the average deviation is:
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 7 | 1.75 | ||
| Row2 | 6 | |||
| Row3 | 9 | |||
| Row4 | 3 | |||
| Row5 | 0 | |||
| Row6 |
Where N1, N 2 ... are positive integers. =AVEDEV (B2:B5) is 1.75