Top Description Fields Constructors Methods
org.apache.poi.ss.formula.functions

public final Class Slope

extends Fixed2ArgFunction
Class Inheritance
Imports
org.apache.poi.ss.formula.eval.ValueEval, org.apache.poi.ss.formula.functions.LinearRegressionFunction.FUNCTION
Implementation of Excel function SLOPE()

Calculates the SLOPE of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html) Syntax:
SLOPE(arrayX, arrayY)

Field Summary

Modifier and TypeField and Description
private final LinearRegressionFunction
func

Constructor Summary

AccessConstructor and Description
public
Slope()

Method Summary

Modifier and TypeMethod and Description
public ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)

Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Inherited from org.apache.poi.ss.formula.functions.Fixed2ArgFunction:
evaluate

Field Detail

funcback to summary
private final LinearRegressionFunction func

Constructor Detail

Slopeback to summary
public Slope()

Method Detail

evaluateback to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)

Implements org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function2Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

Annotations
@Override