Difference between revisions of "Manuals/calci/AVEDEV"

Latest revision as of 01:34, 11 August 2020

AVEDEV()

Parameters are any set of any real numbers.
- AVEDEV(),returns the average of the absolute deviations of data points from their mean.

Description

This function is used to find the average of the absolute deviations of data points from its mean.
Arguments can be numbers,names,arrays or references.

This function gives the average absolute deviation of a given set of numbers. The Average deviation is calculated in three steps:

We have to find the mean ${\bar {x}}$ .
To find the deviation of each value, subtract all numbers with its mean value.
Then find the average deviation, add all the deviation values and divide by the total number of given numbers.

AverageDeviation=\sum _{i=1}^{n}{\frac {x_{i}-{\bar {x}}}{n}}

Here $x_{i}$ is the observation.
${\bar {x}}$ is the mean.
$n$ is the number of given set of observations.

Here we have to give more than one arguments. Arguments can be either number, name,logical values, arrays or cell references that contain numbers.

This function will give the result as error, when the text couldn't convert in to numbers.

ZOS

The syntax is to calculate AVEDEV in ZOS is .
- Parameters are any set of any real numbers.
For e.g.,AVEDEV(-25..-12)

AVEDEV

Examples

=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3

Steps

Mean = ${\frac {50+52+54+56+58+60}{6}}={\frac {330}{6}}=55$
Deviation = $|50-55|,|52-55|,|54-55|,|56-55|,|58-55|,|60-55|=5,3,1,1,3,5$
Average Deviation = ${\frac {5+3+1+1+3+5}{6}}=3$

=AVEDEV(-20,40,-30,50,60) = 36
=AVEDEV(-1.2,3.5,7,2,8.3,9.1) = 3.35
=AVEDEV(B2:B5) = 1.75

References

Average Deviation

List of Main Z Functions

Z3 home

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''AVEDEV(n1,n2,n3)'''</div><br/>
+<div style="font-size:30px">'''AVEDEV()'''</div><br/>
-*<math>n1,n2,n3...</math> are any real numbers.
+*Parameters are any set of any real numbers.
+**AVEDEV(),returns the average of the absolute deviations of data points from their mean.
 ==Description==
-*AVEDEV returns the average of the absolute deviations of data points from their mean.
-*Arguments can be numbers, names, arrays, or references.
+*This function is used to find  the average of the absolute deviations of data points from its mean.
+*Arguments can be numbers,names,arrays or references.
 This function gives the average absolute deviation of a given set of numbers.
 The Average deviation is calculated in three steps:
 #We have to find the mean <math>\bar{x}</math>.
 #To find the deviation of each value, subtract all numbers with its mean value.
-#Then find the average deviation, add all the deviation values and divide by the number of given set of numbers.
+#Then find the average deviation, add all the deviation values and divide by the total number of given numbers.
+:<math>Average Deviation =\sum_{i=1}^{n} \frac{x_i-\bar{x}}{n}</math>
+*Here <math>x_i</math> is the observation.
+*<math>\bar{x}</math> is the mean.
+*<math>n</math> is the number of given set of observations.
+Here we have to give more than one arguments. Arguments can be either number, name,logical values, arrays or cell references that contain numbers.
+ This function will give the result as error, when the text couldn't convert in to numbers.
-<math>Average Deviation =\sum_{i=1}^n \frac{xi-\bar{x}}{n}</math>
-*Here <math>xi</math> is the observation.
+==ZOS==
-*<math>\bar{x}</math>. is the mean.
-*<math>n</math> is the number of given set of observations.
+*The syntax is to calculate AVEDEV in ZOS is <math>AVEDEV()</math>.
-Here we have to give more than one arguments. Arguments can be either number, name,logical values, arrays or cell references that contain numbers.
+**Parameters are any set of any real numbers.
-This function will give the result as error,
+*For e.g.,AVEDEV(-25..-12)
-#when the text couldn't convert in to numbers.
+{{#ev:youtube|_hYy71RCZxg|280|center|AVEDEV}}
+==Examples==
+*=AVEDEV(50,52, 54, 56, 58, 60) gives the result 3<br/>
+'''Steps'''
+#Mean = <math>\frac{50+52+ 54+ 56+ 58+ 60}{6} = \frac{330}{6} = 55</math>
+#Deviation =<math> |50-55|,|52-55|,|54-55|,|56-55|,|58-55|,|60-55| = 5,3,1,1,3,5</math>
+#Average Deviation = <math>\frac{5+3+1+1+3+5}{6} = 3</math>
+*=AVEDEV(-20,40,-30,50,60) = 36
+*=AVEDEV(-1.2,3.5,7,2,8.3,9.1) = 3.35
+*=AVEDEV(B2:B5) = 1.75
+==Related Videos==
+{{#ev:youtube|GdIkEngwGNU|280|center|Mean Absolute Deviation}}
+==See Also==
+*[[Manuals/calci/SUM | SUM]]
+*[[Manuals/calci/AVERAGE  | AVERAGE ]]
+*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
-Logical values and text representations of numbers are calculated.
+==References==
-Formula:-
+[http://en.wikipedia.org/wiki/Absolute_deviation   Average Deviation]
-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="sshl_f" |
-|- class="even"
-| class="  " | Row2
-| class=" " | 6
-| class="sshl_f SelectTD SelectTD" |
-| class="sshl_f" |
+*[[Z_API_Functions | List of Main Z Functions]]
-| class="sshl_f" |
-|- class="odd"
-| Row3
-| class=" " | 9
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="even"
-| Row4
-| class="sshl_f " | 3
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|- class="odd"
-| class=" " | Row5
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| 0
-|- class="even"
-| Row6
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-| class="sshl_f" |
-|}
-Where N1, N 2 ...   are positive integers.
+*[[ Z3 |   Z3 home ]]
-=AVEDEV (B2:B5) is 1.75

Difference between revisions of "Manuals/calci/AVEDEV"

Latest revision as of 01:34, 11 August 2020

Contents

Description

ZOS

Examples

Related Videos

See Also

References

Navigation menu

Search