Class Frequency
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed2ArgFunction
org.apache.poi.ss.formula.functions.Frequency
- All Implemented Interfaces:
Function
,Function2Arg
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical array
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.
- Author:
- Yegor Kozlov
-
Field Summary
Fields -
Method Summary
Modifier and TypeMethodDescriptionMethods inherited from class org.apache.poi.ss.formula.functions.Fixed2ArgFunction
evaluate
-
Field Details
-
instance
-
-
Method Details
-
evaluate
Description copied from interface:Function2Arg
-