CumFreqTable(column)

Top  Previous  Next

Calculates a cumulative frequency table for column and puts it into the two columns indicated by the location of the cursor or mouse when the formula is entered.

 

A cumulative frequency table shows the number of scores that are equal or less than each value in the table.

 

Score        cf        

10        2        

11        5        

12        12        

13        20        

 

This cumulative frequency table would be generated from this data:

 

10, 10, 11, 11, 11, 12, 12, 12, 12, 12, 12, 12, 13, 13, 13, 13, 13, 13, 13, 13

 

Example:  CumFreqTable(A)