FREQUENCY

計算單欄陣列的頻率分佈並且分成指定類別。

使用範本

FREQUENCY(A2:A40,B2:B5)

語法

FREQUENCY(資料, 類別)

• data 包含值的陣列或範圍個數。

• 類別 包含類別集合的陣列或範圍。

  • 類別 should be sorted for clarity, but FREQUENCY will sort the values specified internally if they are not and return correct results.

附註

• The output of FREQUENCY will be a vertical range of size one 大於 類別 as the final value is the number of elements 特別要注意data greater than any of the class boundaries.

範例