Calculates how often values occur within a range of values and returns a vertical array of numbers.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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})결과: {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.