org.apache.poi.hssf.record.formula.functions
Class Sumx2py2

java.lang.Object
  org.apache.poi.hssf.record.formula.functions.XYNumericFunction
      org.apache.poi.hssf.record.formula.functions.Sumx2py2

All Implemented Interfaces:

Function

public final class Sumx2py2
extends XYNumericFunction

Implementation of Excel function SUMX2PY2()

Calculates the sum of squares in two arrays of the same size.
Syntax:
SUMX2PY2(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.hssf.record.formula.functions.XYNumericFunction

XYNumericFunction.DoubleArrayPair

Field Summary

Fields inherited from class org.apache.poi.hssf.record.formula.functions.XYNumericFunction

X, Y

Constructor Summary

Sumx2py2()

Method Summary

protected double

evaluate(double[] xArray, double[] yArray)

Methods inherited from class org.apache.poi.hssf.record.formula.functions.XYNumericFunction

evaluate

Methods inherited from class java.lang.Object

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

Constructor Detail

Sumx2py2

public Sumx2py2()

Method Detail

evaluate

protected double evaluate(double[] xArray,
                          double[] yArray)

Specified by:

evaluate in class XYNumericFunction