Hi,
I have a set of data (total number of record = 144,122), and I would like to
use gamma-glm with log link to set up a model.
IC is number of records
IL is paid amount
The table below shows that I have
30.578% of the data in the level of "1 - 1000" paid amount
20.320% of the data in the level of "1001 - 2000" paid amount
and so on
My question is could i use the whole data set to model ?
or may be i have to use the data up to 10,000 paid amount ?
Level IL Avg IL Sum IC 1-1000 539.60 44,069 30.578% 1001
- 2000 1,444.81 29,285 20.320% 2001 - 3000 2,457.72 15,343
10.646% 3001 - 4000 3,473.40 8,497 5.896% 4001 - 5000 4,496.47
5,838 4.051% 5001 - 6000 5,476.28 3,831 2.658% 6001 -
7000
6,482.82 2,889 2.005% 7001 - 8000 7,500.97 2,323 1.612% 8001
- 9000 8,492.07 1,772 1.230% 9001 - 10000 9,542.60 1,736
1.205% 10001 - 11000 10,490.19 1,291 0.896% 11001 - 12000 11,516.00
1,104 0.766% 12001 - 13000 12,508.65 915 0.635% 13001 -
14000 13,501.24 869 0.603% 14001 - 15000 14,562.99 876
0.608% 15001 - 16000 15,502.50 650 0.451% 16001 - 17000 16,498.90
585 0.406% 17001 - 18000 17,511.23 573 0.398% 18001 -
19000 18,529.04 512 0.355% 19001 - 20000 19,605.73 615
0.427% 21001 - 22000 21,518.71 448 0.311% 22001 - 23000 22,489.74
389 0.270% 23001 - 24000 23,493.52 340 0.236% 24001 -
25000 24,603.33 413 0.287% 25001 - 26000 25,516.57 324
0.225% 26001 - 27000 26,514.70 297 0.206% 27001 - 28000 27,509.62
272 0.189% 28001 - 29000 28,486.77 238 0.165% 29001 -
30000 29,591.02 312 0.216% 30001 - 31000 30,460.08 238
0.165% 31001 - 32000 31,527.67 240 0.167% 32001 - 33000 32,526.25
213 0.148% 33001 - 34000 33,496.41 208 0.144% 34001 -
35000 34,556.44 235 0.163% 35001 - 36000 35,476.62 190
0.132% 36001 - 37000 36,512.92 155 0.108% 37001 - 38000 37,524.77
191 0.133% 38001 - 39000 38,469.21 152 0.105% 39001 -
40000 39,554.93 176 0.122% 40001 - 41000 40,501.28 171
0.119% 41001 - 42000 41,521.06 182 0.126% 42001 - 43000 42,525.54
156 0.108% 43001 - 44000 43,541.32 118 0.082% 44001 -
45000 44,549.38 131 0.091% 45001 - 46000 45,513.78 125
0.087% 46001 - 47000 46,532.88 128 0.089% 47001 - 48000 47,528.92
121 0.084% 48001 - 49000 48,472.52 115 0.080% 49001 -
50000 49,684.14 191 0.133% 50001 - 51000 50,556.99 104
0.072% 51001 - 52000 51,527.56 119 0.083% 52001 - 53000 52,519.82
120 0.083% 53001 - 54000 53,504.29 105 0.073% 54001 -
55000 54,527.36 126 0.087% 55001 - 56000 55,566.20 94
0.065% 56001 - 57000 56,533.86 98 0.068% 57001 - 58000
57,494.78
112 0.078% 58001 - 59000 58,555.27 100 0.069% 59001 -
60000 59,592.80 134 0.093% 60001 - 61000 60,540.90 94
0.065% 61001 - 62000 61,488.11 93 0.065% 62001 - 63000
62,543.60
95 0.066% 63001 - 64000 63,509.94 95 0.066% 64001 -
65000 64,578.59 97 0.067% 65001 - 66000 65,486.95 82
0.057% 66001 - 67000 66,518.80 72 0.050% 67001 - 68000
67,507.95
85 0.059% 68001 - 69000 68,516.98 86 0.060% 69001 -
70000 69,541.52 89 0.062% 70001 - 71000 70,519.49 77
0.053% 71001 - 72000 71,488.88 74 0.051% 72001 - 73000
72,483.43
72 0.050% 73001 - 74000 73,489.59 82 0.057% 74001 -
75000 74,601.14 92 0.064% 75001 - 76000 75,467.29 78
0.054% 76001 - 77000 76,550.53 74 0.051% 77001 - 78000
77,525.18
76 0.053% 78001 - 79000 78,481.88 74 0.051% 79001 -
80000 79,555.44 78 0.054% 80001 - 81000 80,443.24 72
0.050% 81001 - 82000 81,504.18 67 0.046% 82001 - 83000
82,510.68
78 0.054% 83001 - 84000 83,483.89 78 0.054% 84001 -
85000 84,566.99 84 0.058% 85001 - 86000 85,504.36 86
0.060% 86001 - 87000 86,584.49 67 0.046% 87001 - 88000
87,540.17
60 0.042% 88001 - 89000 88,483.13 73 0.051% 89001 -
90000 89,532.23 70 0.049% 90001 - 91000 90,521.94 73
0.051% 91001 - 92000 91,597.56 62 0.043% 92001 - 93000
92,499.65
75 0.052% 93001 - 94000 93,515.79 64 0.044% 94001 -
95000 94,524.84 76 0.053% 95001 - 96000 95,469.49 81
0.056% 96001 - 97000 96,492.13 55 0.038% 97001 - 98000
97,454.56
62 0.043% 98001 - 99000 98,493.23 57 0.040% 99001 -
100000 99,593.13 90 0.062%
IL > 100,000 is 6.85%
Thank you
[[alternative HTML version deleted]]
