Operation content of frequency fractional function in Excel

1. Frequency function syntax

FREQUENCY(data_array,bins_array)

Parameter description:

Data_array is an array or a reference to a set of values, used for calculation frequency. If data_array does not contain any numeric values, the function FREQUENCY returns an array of zeros.

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

2. Frequency usage instructions

are the same as the table below.

A column is the original data, B column is the setting of each score segment, and C column is the result of each score segment to be counted.

It is very simple to calculate the results, just use the FREQUENCY function and the array formula.

As shown in the picture above, select the cells in the range C2:C6, and in the FX function input column, enter the formula: =FREQUENCY(A2:A9,B2:B6 and press Ctrl together Shift Enter these three keys. In this way, the above formula will automatically become {=FREQUENCY(A2:A9,B2:B6}) and a pair of braces. Note that this pair of braces is not entered directly through the keyboard, but through The three keys Ctrl Shift Enter were pressed just now.

The result comes out.

But there is a question, how to determine this fraction? Many people are like me. They can't figure out from which value to which value at first. Does it include the equal symbol?

To avoid you falling into chaos when determining the fractional segment, I have prepared the corresponding instructions for you. Please look at the picture above to explain clearly from which fraction segment to which fraction segment and where the equal symbol should appear

.

The above is the detailed content of Operation content of frequency fractional function in Excel. For more information, please follow other related articles on the PHP Chinese website!