org.apache.poi.ss.formula.functions
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

public final class Sumxmy2
extends XYNumericFunction

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}(x_i-y_i)²

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

Sumxmy2()

Method Summary

protected XYNumericFunction.Accumulator

createAccumulator() Constructs a new instance of the Accumulator used to calculated this function

Methods inherited from class org.apache.poi.ss.formula.functions.XYNumericFunction

evaluate

Methods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction

evaluate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Sumxmy2

public Sumxmy2()

Method Detail

createAccumulator

protected XYNumericFunction.Accumulator createAccumulator()

Description copied from class: XYNumericFunction

Constructs a new instance of the Accumulator used to calculated this function

Specified by:

createAccumulator in class XYNumericFunction