Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

FREQUENCY(data_array,bins_array) returns a frequency distribution as a vertical array

Input the formula: =FREQUENCY(B2:B6,C2:C6). Press Enter to get the result. Referenced from Excel Help