Difference between revisions of "Manuals/calci/AVEDEV"
Jump to navigation
Jump to search
| Line 10: | Line 10: | ||
#To find the deviation of each value, subtract all numbers with its mean value. | #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 number of given set of numbers. | ||
| − | + | <math>\frac{\sum_{i=1}^n xi-x}{n}</math> | |
<math> AVERAGE DEVIATION=SUMMATION(I=1 TO N)xi-x(bar)[mean]/n<math>. Here xi is the observation,x(bar) is the mean and n is the number of given set of observations.Here we have to give more than one arguments and arguments can be either numbers , names,logical values, arrays or cell refercences that contain numbers.This function will give the result as error,when the text couldn't convert in to numbers. | <math> AVERAGE DEVIATION=SUMMATION(I=1 TO N)xi-x(bar)[mean]/n<math>. Here xi is the observation,x(bar) is the mean and n is the number of given set of observations.Here we have to give more than one arguments and arguments can be either numbers , names,logical values, arrays or cell refercences that contain numbers.This function will give the result as error,when the text couldn't convert in to numbers. | ||
Revision as of 03:09, 21 November 2013
AVEDEV(n1,n2,n3)
- are any real numbers.
are any real numbers.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 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.
- 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.
<math> AVERAGE DEVIATION=SUMMATION(I=1 TO N)xi-x(bar)[mean]/n<math>. Here xi is the observation,x(bar) is the mean and n is the number of given set of observations.Here we have to give more than one arguments and arguments can be either numbers , names,logical values, arrays or cell refercences that contain numbers.This function will give the result as error,when the text couldn't convert in to numbers.
<math> AVERAGE DEVIATION=SUMMATION(I=1 TO N)xi-x(bar)[mean]/n<math>. Here xi is the observation,x(bar) is the mean and n is the number of given set of observations.Here we have to give more than one arguments and arguments can be either numbers , names,logical values, arrays or cell refercences that contain numbers.This function will give the result as error,when the text couldn't convert in to numbers.
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