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

public Class Frequency

extends Fixed2ArgFunction
Class Inheritance
Imports
org.apache.poi.ss.formula.CacheAreaEval, org.apache.poi.ss.formula.eval.EvaluationException, .NumberEval, .ValueEval, java.util.Arrays

Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical array

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

Field Summary

Modifier and TypeField and Description
public static final Function

Constructor Summary

AccessConstructor and Description
private

Method Summary

Modifier and TypeMethod and Description
public ValueEval
pack-priv static int
findBin(double value, double[] bins)

pack-priv static int[]
histogram(double[] values, double[] bins)

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

Field Detail

instanceback to summary
public static final Function instance

Constructor Detail

Frequencyback to summary
private Frequency()

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
findBinback to summary
pack-priv static int findBin(double value, double[] bins)
histogramback to summary
pack-priv static int[] histogram(double[] values, double[] bins)