Excel Frequency Fractional Segment function

First, frequency function syntax

FREQUENCY (Data_array,bins_array)

Parameter description:

Data_array is an array or reference to a set of values that is used to calculate frequencies. If the data_array does not contain any numeric values, the function FREQUENCY returns to the zero group.

Bins_array is an array of intervals or a reference to an interval that is used to group the values in Data_array. If the Bins_array does not contain any numeric values, the function FREQUENCY returns the number of elements in the data_array.

Second, the use of frequency guidance

The rest is not much to say, let's look at the examples below.

The same as the following table.

A is listed as the original data, B is the set of each fractional segment, and C is the result of each fractional segment to be counted.

To calculate the result is very simple, through the frequency function with the array formula can be.

Computer Tutorials

As shown above, first select the cell that c2:c6 this range, and then in the FX function input field, enter the formula: =frequency (A2:a9,b2:b6 Then, press the Ctrl+shift+enter three keys together, so that the formula above automatically becomes {= FREQUENCY (A2:a9,b2:b6} More than a pair of curly braces, note oh, this pair of curly braces is not directly input through the keyboard, but through the ctrl+shift+enter of these three keys to press out.

In this way, the result came out.

But the question is, how do you determine this fraction? I think a lot of people like me, at first I don't understand which value to which value, whether it contains equals symbol?

In order to avoid you in the determination of the score section of the time into chaos, I have prepared the corresponding instructions for you, please see the map, from which fraction to which fraction, equal to where the symbol should appear, all said a clear.