Changes

This function gives the average absolute deviation of a given set of numbers.

This function gives the average absolute deviation of a given set of numbers.

The Average deviation is calculated in three steps:

The Average deviation is calculated in three steps:

#We have to find the mean.

#We have to find the mean <math>\bar{x}</math>.

#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>\frac{\sum_{i=1}^n xi-\bar{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.