Hello everyone, I am a never-ending old cow. There is a very practical function FREQUENCY in Excel, which is used to count interval frequencies. In layman's terms, it counts the number of times data appears in each interval. We have talked about other methods to count the number

Hello everyone, I am a never-ending old cow

There is a very practical function FREQUENCY in Excel, which is used to count interval frequencies. In layman's terms, it counts the number of times data appears in each interval. We have talked about other methods to count the number of intervals before, but the FREQUENCY function is very efficient and its use is very simple. The syntax of

FREQUENCY is:

FREQUENCY(data_array,bins_array)

data_array: required. A set of numeric values ​​or a reference to a set of numeric values ​​whose frequency is to be counted.

bins_array: required. An array of intervals or a reference to an interval into which the values ​​in data_array are to be inserted.

simply understands that data_array is the data to be counted, and bins_array is the interval, which means that the data of data_array is counted according to the interval divided by bins_array.

We use the data in the figure below to describe it. We want to count the number of times the customer satisfaction of D2:D9 appears in the interval represented by G2:G5. D2:D9 is data_array, and G2:G5 is bins_array. The rules of

bins_array are: greater than the previous number, less than or equal to the current number. Since there is no previous number, 70 means less than or equal to 70, 85 means greater than 70, less than or equal to 85, 95 means greater than 85, less than or equal to 95, 100 means greater than 95, less than or equal to 100.

Now we can easily write statistical formulas. Select H2:H5 and enter the formula

=FREQUENCY(D2:D9,G2:G5). Because it is an array operation, you need to press CTRL+SHIFT+ENTER to end.

is very simple and fast. It is worth clarifying this function.

At this time, some students may ask, can we count non-numeric content? For example, if we want to count the number of people in each group, we only need to use the CODE function to convert text into numerical codes, and then we can count. The formula is as follows:

=FREQUENCY(CODE(C2:C9),CODE(F7:F9))

We use the CODE function to convert C2:C9 and F7:F9 into numbers respectively, and then we can use the FREQUENCY function for statistics, which is very convenient. The detailed explanation of

Excel function is being continuously updated. Please pay attention and like to support it.