Calculates how often values occur within a range of values and returns a vertical array of numbers.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
FREQUENCY(data_array, bins_array)The FREQUENCY function calculates the frequency distribution of data within specified bins. It returns an array that has one more element than the bins_array, representing the count of values above the highest bin.
=FREQUENCY({10,20,30,40}, {25})Kết quả: {2; 2}
Counts how many values are less than or equal to 25 (10, 20) and how many are greater than 25 (30, 40).
The extra row contains the count of all values in the data_array that are greater than the largest value in the bins_array.