writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 10:
Line 10: − <math>\frac{\sum_{i=1}^n xi-x}/n</math>+
→Description
#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.