Log In
IBM Docs wiki
All Wikis
All Forums
Home
Product Documentation
Community Articles
Learning Center
IBM Redbooks
API Documentation
Community Articles
Product Documentation
Learning Center
IBM Redbooks
API Documentation
This category
Custom Search Scope...
Search
Share
▼
Subscribe
▼
Share
▼
Subscribe
▼
Installing and deploying IBM Docs 1.0.4
Select version
1.0.4 Installing and Deploying
1.0.4 Using IBM Docs
Using IBM Docs 1.0.4 documentation
Information
You are currently viewing machine translated content. IBM translation might be available. Click
IBM Translated Product Documentation
to see what is available.
X
FREQUENCY function
Added by
IBM
on
September 24, 2013

Version 1
(
Original
)
Edit
More Actions
▼
Abstract
Abstract
FREQUENCY indicates the frequency distribution in a set of values.
Syntax
FREQUENCY (
NumberSequenceList_data
,
NumberSequenceList_bins
)
NumberSequenceList_data
represents the set of values to be counted.
NumberSequenceList_bins
represents the intervals into which you want to divide the data
Example
In the following table, column A lists unsorted measurement values. Column B contains the intervals you entered for the classes into which you want to divide the data in column A. According to the interval entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of measured values that are greater than 5 and less than or equal to 10. The text you entered in B6,
>25
, is for reference purposes only.
Table 1. FREQUENCY function example
A
B
C
1
12
5
1
2
8
10
3
3
24
15
2
4
11
20
2
5
5
25
1
6
20
25
1
7
16
8
9
9
7
10
16
11
33
Use a single column range in which to enter the frequency function according to the class limits. You must enter the function in one field more than the class ceiling. In this example, use the range C1:C6. Enter the function
{=FREQUENCY(A1:A11,B1:B5)}
in each cell in the range. You will see the frequency count results in C1:C5.
Parent topic:
List of functions
Related reference
Array functions
Inline array constants in formulas
Conditional array calculations
Edit
More Actions
▼
Attachments (0)
Attachments (0)
Edit the article to add or modify attachments.
Versions (1)
Versions (1)
Version Comparison
Compare version
Current 1
with version
Current 1
Compare selected versions
Version
Date
Changed by
Summary of changes
This version (1)
Sep 24, 2013 9:03:41 AM
IBM
Comments (0)
Comments (0)
Add comment
Copy and paste this wiki markup to link to this article from another article in this wiki.
Link:
Close