org.apache.poi.ss.formula.functions

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

(Excel 'Analysis ToolPak' 函数的实现 FREQUENCY() 以垂直数组形式返回频率分布 语法 FREQUENCY(data_array, bins_array) data_array 必需。要计算频率的一组值的数组或引用。如果 data_array 不包含任何值，则 FREQUENCY 返回一个零数组。 bins_array 必需。要将 data_array 中的值分组到其中的区间数组或引用。如果 bins_array 不包含任何值，则 FREQUENCY 返回 data_array 中的元素数。)

Author:

Yegor Kozlov

Field Summary

Fields

Modifier and Type	Field and Description
static Function	instance

Method Summary

Modifier and Type	Method and Description
ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1) see Function.evaluate(ValueEval[], int, int) (见 Function.evaluate(ValueEval[], int, int))

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

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

see Function.evaluate(ValueEval[], int, int) (见 Function.evaluate(ValueEval[], int, int))