FREQUENCY in Collabora Office: Count Observations in Upper-Bounded Bins

=FREQUENCY(Data; Classes)

Data is the range of values to count. Classes is the range of numeric upper limits. FREQUENCY returns a one-column array with one more result than the number of numeric class limits, because the final result counts observations above the last limit.

The first bin contains values less than or equal to the first limit. Each later bounded bin contains values greater than the previous limit and less than or equal to the current limit. These are disjoint interval counts, not cumulative totals.

The dedicated Collabora documentation describes array entry through the Function Wizard and says that text and empty cells within data ranges are ignored. This guide does not assume automatic dynamic spilling in every deployment.

Enter 12,8,24,11,5,20,16,9,7,16,33 in A1:A11. Put numeric class limits 5,10,15,20,25 in B1:B5. Reserve C1:C6, one output row more than the five limits.

Select C1:C6, use the Function Wizard for FREQUENCY with Data=A1:A11 and Classes=B1:B5, and select its Array option as described by the help. The independent expected output is 1,3,2,3,1,1 from top to bottom.

This is a documented entry procedure, not a claim that a new native workbook or GUI session was executed. If a deployment uses different array-entry behavior, verify its supported workflow rather than assuming the formula will spill automatically.

The first bin contains only 5. The second, greater than five and at most ten, contains 8,9,7. The third contains 12,11; the fourth contains 20,16,16; the fifth contains 24; the overflow bin contains 33.

The six counts sum to 11, matching the number of numeric observations. A missing overflow row would hide the observation 33 and reduce the visible total to ten.

Keep a label such as “>25” beside the overflow result, outside the numeric limit range. The official table uses such a text label for explanation; it is not an additional numeric upper bound.

Use data 5,10,15,20,25,26 with the same five limits. Independent counts are 1,1,1,1,1,1. Each exact boundary belongs to the bin ending at that boundary.

A value below five, such as -2, also belongs to the first bin. The first class does not automatically start at zero merely because its upper limit is positive.

State a separate lower-bound filter if negative observations are outside the intended reporting domain. FREQUENCY’s first interval alone does not enforce that policy.

For the original six counts in C1:C6, enter =SUM($C$1:C1) in D1 and fill down. Independent cumulative totals are 1,4,6,9,10,11.

Relative frequencies are the counts divided by eleven: approximately 0.090909091,0.272727273,0.181818182,0.272727273,0.090909091,0.090909091. Their sum targets one.

These derived columns have different meanings from the original interval counts. A cumulative histogram or percentage chart should use the appropriate derived series and clearly labeled intervals.

Use ordered numeric class limits in the reproducible fixture. Duplicate, unsorted or mixed-type class behavior is outside these controls. An output area with only five cells cannot display all six bins required by the stated setup.

Text and empty data cells are ignored under the documented range rule, but an actual numeric zero is counted in the first bin. Numeric-looking text can therefore make a total differ from the number of visibly populated rows.

FREQUENCY counts observations; it does not choose statistically appropriate bin widths, estimate a density or normalize by interval width automatically. Preserve the original data, numeric limits and overflow category so a chart’s meaning can be reconstructed.

The exact function is documented in Collabora Office 26.04 desktop help. The cited help snapshot was retrieved on 2026-10-13 and hash-verified October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduction and last functioning release are unknown in this evidence.

No native Collabora Office execution occurred. All numerical results are independent mathematical expectations, with English names and semicolon argument separators. Native error displays, all coercions and extreme numerical behavior are not certified.

• Collabora Office 26.04: FREQUENCY.
• Editorial testing standards.