Definition

Calculates the sum of the differences of the squares of values in two arrays.

Sample Usage

Syntax
SUMX2MY2(array_x, array_y)
  • array_x - The array or range of values whose squares will be reduced by the squares of corresponding entries inarray_y and added together.
  • array_y - The array or range of values whose squares will be subtracted from the squares of corresponding entries inarray_x and added together.
See Also
SUMXMY2: Calculates the sum of the squares of differences of values in two arrays.
SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.
In order to use the SUMX2MY2 formula, start with your edited Excellentable:
   
 
 
 


  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More