writer
5,435
edits
Changes
no edit summary
#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-\bar{x}}{n}</math>
<math>Average Deviation =\sum_{i=1}^n \frac{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.