Class Sumxmy2
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed2ArgFunction
org.apache.poi.ss.formula.functions.XYNumericFunction
org.apache.poi.ss.formula.functions.Sumxmy2
- All Implemented Interfaces:
Function
,Function2Arg
Implementation of Excel function SUMXMY2()
Calculates the sum of squares of differences between two arrays of the same size.
Syntax:
SUMXMY2(arrayX, arrayY)
result = Σi: 0..n(xi-yi)2
- Author:
- Amol S. Deshmukh < amolweb at ya hoo dot com >
-
Nested Class Summary
Nested classes/interfaces inherited from class org.apache.poi.ss.formula.functions.XYNumericFunction
XYNumericFunction.Accumulator
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected XYNumericFunction.Accumulator
Constructs a new instance of the Accumulator used to calculated this functionMethods inherited from class org.apache.poi.ss.formula.functions.XYNumericFunction
evaluate
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction
evaluate
-
Constructor Details
-
Sumxmy2
public Sumxmy2()
-
-
Method Details
-
createAccumulator
Description copied from class:XYNumericFunction
Constructs a new instance of the Accumulator used to calculated this function- Specified by:
createAccumulator
in classXYNumericFunction
-