Parameter descriptions
known_y's, known_x's, new_x's	typically area references, possibly cell references or scalar values
constant	TRUE or FALSE: determines whether the regression line should include an intercept term

Modifier and Type	Class and Description
private static class	Trend.TrendResults

Access	Constructor and Description
public	Trend()

Method Summary

Modifier and Type	Method and Description
private static double[][]	evalToArray(ValueEval arg)
public ValueEval	evaluate(ValueEval[] the evaluated function arguments. Empty values are represented with `BlankEval` or `MissingArgEval`, never `null`. args, int row index of the cell containing the formula under evaluation srcRowIndex, int column index of the cell containing the formula under evaluation srcColumnIndex) Implements org.apache.poi.ss.formula.functions.Function.evaluate.
private static double[]	flattenArray(double[][] twoD)
private static double[][]	flattenArrayToRow(double[][] twoD)
private static double[][]	getDefaultArrayOneD(int w)
private static Trend.TrendResults	getNewY(ValueEval[] args)
private static boolean	Returns: true if all columns contain the same value isAllColumnsSame(double[][] column-oriented matrix. A Row matrix should be transposed to column . matrix) Check if all columns in a matrix contain the same values.
private static double[][]	switchRowsColumns(double[][] array)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

Trend	back to summary
public Trend()

Method Detail

evalToArray	back to summary
private static double[][] evalToArray(ValueEval arg) throws EvaluationException

evaluate back to summary

evaluate	back to summary
public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) Implements org.apache.poi.ss.formula.functions.Function.evaluate. Parameters args:ValueEval[] Doc from org.apache.poi.ss.formula.functions.Function.evaluate. the evaluated function arguments. Empty values are represented with `BlankEval` or `MissingArgEval`, never `null`. srcRowIndex:int Doc from org.apache.poi.ss.formula.functions.Function.evaluate. row index of the cell containing the formula under evaluation srcColumnIndex:int Doc from org.apache.poi.ss.formula.functions.Function.evaluate. column index of the cell containing the formula under evaluation Returns:ValueEval Doc from org.apache.poi.ss.formula.functions.Function.evaluate. The evaluated result, possibly an `ErrorEval`, never `null` Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to `Double#NaN` be sure to translate the result to `ErrorEval#NUM_ERROR`. Annotations @Override

public ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)

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

Parameters

args:ValueEval[]

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

the evaluated function arguments. Empty values are represented with BlankEval or MissingArgEval, never null.

srcRowIndex:int

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

row index of the cell containing the formula under evaluation

srcColumnIndex:int

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

column index of the cell containing the formula under evaluation

Returns:ValueEval

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

The evaluated result, possibly an ErrorEval, never null

Note

- Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to Double#NaN be sure to translate the result to ErrorEval#NUM_ERROR.

Annotations

@Override

flattenArray	back to summary
private static double[] flattenArray(double[][] twoD)

flattenArrayToRow	back to summary
private static double[][] flattenArrayToRow(double[][] twoD)

getDefaultArrayOneD	back to summary
private static double[][] getDefaultArrayOneD(int w)

getNewY	back to summary
private static Trend.TrendResults getNewY(ValueEval[] args) throws EvaluationException

isAllColumnsSame	back to summary
private static boolean isAllColumnsSame(double[][] matrix) Check if all columns in a matrix contain the same values. Return true if the number of distinct values in each column is 1. Parameters matrix:double[][] column-oriented matrix. A Row matrix should be transposed to column . Returns:boolean true if all columns contain the same value

isAllColumnsSame

back to summary

private static boolean isAllColumnsSame(double[][] matrix)

Check if all columns in a matrix contain the same values. Return true if the number of distinct values in each column is 1.

Parameters

matrix:double[][]: column-oriented matrix. A Row matrix should be transposed to column .

Returns:boolean

true if all columns contain the same value

switchRowsColumns	back to summary
private static double[][] switchRowsColumns(double[][] array)

org.apache.poi.ss.formula.functions back to summary

private final Class Trend.TrendResults

Class Inheritance

extends Object

java.lang.Object
org.apache.poi.ss.formula.functions.Trend.TrendResults

Field Summary

Modifier and Type	Field and Description
private final int	resultHeight
private final int	resultWidth
private final double[]	vals

Constructor Summary

Access	Constructor and Description
public	TrendResults(double[] vals, int resultWidth, int resultHeight)

Method Summary

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

resultHeight	back to summary
private final int resultHeight

resultWidth	back to summary
private final int resultWidth

vals	back to summary
private final double[] vals

Constructor Detail

TrendResults	back to summary
public TrendResults(double[] vals, int resultWidth, int resultHeight)

public final Class Trend

Nested and Inner Type Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail

private final Class Trend.TrendResults

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail