FREQUENCY(data_array,bins_array) returns a frequency distribution as a vertical array : FREQUENCY « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. FREQUENCY
Input the formula: =FREQUENCY(B2:B6,C2:C6). Press Enter to get the result.
Input the formula: =FREQUENCY(B2:B6,C2:C6)

Referenced from Excel Help

21.28.FREQUENCY
21.28.1.FREQUENCY(data_array,bins_array) returns a frequency distribution as a vertical arrayFREQUENCY(data_array,bins_array) returns a frequency distribution as a vertical array