FREQUENCY in WPS Spreadsheet: Bin Counts and the Overflow Row

=FREQUENCY(data_array, bins_array)

The first argument contains the observations; the second supplies the bin limits. With three bin limits, the documented output has four rows and one column. This guide uses strictly ascending, distinct numeric limits and fully numeric data.

The WPS lesson demonstrates integer score groups with limits 59, 69, 79 and 89. Its displayed labels correspond to successive score bands and its fifth output contains scores above 89. The published observations do not equal a bin limit. The original examples below also avoid equality, so they do not independently verify exact-limit behavior or floating-point equality classification.

Enter A2:A7 as 2, 7, 12, 18, 25, 35. Enter C2:C4 as 10, 20, 30. Leave E2:E5 available for four results.

1. Use =FREQUENCY(A2:A7,C2:C4).
2. In the historical workflow documented by WPS, select all four output cells before entering the array formula and confirm with Ctrl+Shift+Enter.
3. The independent expected vertical result is 2; 2; 1; 1: two observations below 10, two between 10 and 20, one between 20 and 30, and one above 30.
4. Check that the four counts total six, the number of observations.

These are documented workflow instructions and independently calculated results. No current spill interface, array-entry operation or output formatting was exercised for this guide.

Repeated observations each contribute to their group. Reordering the observations does not change these counts. Changing the number of bins changes the required output height; it does not remove the overflow row.

For the first dataset, the independent relative frequencies are 2/6, 2/6, 1/6 and 1/6. They sum to one. A table should show the bin definitions as well as those fractions; different bin widths can make equally tall count bars misleading if interpreted as density.

If the question is how many observations are at most the highest tested boundary of 30, the first three counts total five, while the overflow count is one. This particular dataset has no observation equal to 30. Exact boundary inclusion should be checked separately when it affects a real classification policy.

The official score example lists 78, 90, 51, 62, 78, 68, 100, 43, 56, 46, 60, 76, 62, 88 and 92. Its four limits produce the displayed five counts 4, 4, 3, 1 and 3. Independent grouping reproduces all fifteen observations and confirms the overflow purpose.

The lesson says text and blank cells are ignored and describes special no-numeric-input cases. The original controls do not cover those cases, unsorted limits, duplicate limits or error-bearing arrays. No particular invalid-input error token is established here. Use COUNT and SUM as appropriate cross-checks for a clean numeric distribution, keeping the same source range.

The official WPS lesson is dated 2019-05-30. The lesson explicitly applies to WPS Office for Windows Personal. A numeric build is not specified. The lesson date is a documented-by date, not a first-release date. First introduction, last functioning version and retirement or deprecation history remain unestablished. No cross-platform parity is inferred.

The complete lesson and its formula images or walkthrough were inspected on October 18, 2026. Original examples in this guide were independently calculated from the documented model; they were not executed in WPS or another spreadsheet engine. Historical vendor demonstrations are identified separately. Numeric approximations below are independent expectations, not promises about WPS display precision.