Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > DEVSQ
 

DEVSQ(number1 [,number2] [,…])

 
 Returns the sum of squares of deviations of data points from their average (or mean).

 number1The first number.
 number2The second optional number.

 REMARKS
 
  		• This function is sometimes referred to as the Deviation Squares function.
     
  		• The arguments must be numbers, or names, arrays, or references that contain numbers.
     
  		• You can also use a single array or a reference to an array instead of arguments separated by commas.
     
  		• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
     
  		• This function can return large values when you have a large number of arguments.
     
  		• The Variance is the value returned from this function divided by the number of arguments.
     
  		• The value returned is often called the pooled standard deviation.
     
  		• You can have a maximum of 30 arguments.

     EXAMPLES
     
     A
    1=DEVSQ(1,2,3,4,5) = 10
    2=((3-1)*(3-1))+((3-2)*(3-2))+0+((4-3)*(4-3))+((5-3)*(5-3)) = 10
    3=DEVSQ(1,2,3,4,5)/5 = 2
    4=VARP(1,2,3,4,5) = 2
    		 
     Functions - D | Index - D | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top