Days past due analysis, two condition sum, bucketing data, frequency function Here I have carried out a days past due (DPD) analysis. This requires organizing data in various days bucket and makes use of conditional sum function. 14 cases are presented. Each case has a days past due and a corresponding amount. The objective is [...]
Posts Tagged ‘frequency’
DPD analysis using two condition sum
Posted in Tip, tagged array formula, frequency, If, sum on June 10, 2009 | Leave a Comment »
Frequency distribution
Posted in Uncategorized, tagged array, frequency on June 26, 2008 | Leave a Comment »
The objective is to create a frequency distribution of the data The given list is in column A Frequency is to be calculate for data in bins of 0-1, 1-2, 2-3 etc 1. Create bin in Column C {1,2,3,4,5} in above 2. D2:D6 is selected and frequency array formula is entered {=FREQUENCY(A2:A12,C2:C6)} Array formula is [...]
Author
Search blog
-
Recent posts
-
Blog Stats
- 15,059 hits
Share with others!
What have I used most
Get down to work!
May 2012 M T W T F S S « Jul 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
