Sumxmy2 (POI API Documentation)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

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
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