Class Frequency
- java.lang.Object
-
- org.apache.poi.ss.formula.functions.Fixed2ArgFunction
-
- org.apache.poi.ss.formula.functions.Frequency
-
- All Implemented Interfaces:
Function
,Function2Arg
public class Frequency extends Fixed2ArgFunction
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical arraySyntax
FREQUENCY(data_array, bins_array)data_array Required. An array of or reference to a set of values for which you want to count frequencies. If data_array contains no values, FREQUENCY returns an array of zeros.
bins_array Required. An array of or reference to intervals into which you want to group the values in data_array. If bins_array contains no values, FREQUENCY returns the number of elements in data_array.
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
-
Methods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction
evaluate
-
-
-
-
Field Detail
-
instance
public static final Function instance
-
-
Method Detail
-
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
Description copied from interface:Function2Arg
-
-