Income Estimator Base BSC
TU
8/30/2021
1 AnĆ”lisis Resultados ProducciĆ³n
Anaizo los resultados de produccion, miro los segmentos.
1.1 Toda La base
## B_ENT$IND0065
## Frequency Percent
## DECEASED 6 0.04664
## NO HIT 2091 16.25466
## RECENT INACTIVE 873 6.78638
## TELCO ONLY 1816 14.11692
## WITH REVOLVING 6806 52.90734
## WITHOUT REVOLVING 1272 9.88806
## Total 12864 100.00000## 0% 5% 10% 15% 20% 25% 30% 35%
## 0.0 0.0 0.0 0.0 5279.0 6080.0 6471.0 8576.0
## 40% 45% 50% 55% 60% 65% 70% 75%
## 9810.2 11134.0 12165.0 13150.0 14586.0 16507.0 19707.0 24745.0
## 80% 85% 90% 95% 100%
## 30883.0 42859.0 61781.0 94201.4 166759.01.2 Revolventes
## 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50%
## 10603 10603 11368 12195 12837 13656 14506 15455 16666 18307 20233
## 55% 60% 65% 70% 75% 80% 85% 90% 95% 100%
## 22836 26261 29921 36617 43565 55461 69678 89208 113149 1667591.3 Only Telco
## 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50% 55% 60%
## 5005 5241 5243 5243 5243 5325 5325 5486 5634 6080 6080 6080 6080
## 65% 70% 75% 80% 85% 90% 95% 100%
## 6175 6175 6347 6471 6765 7665 9028 130812 Data Match Income Real - Income Estimado
Filtro los resultados por aquellos ids de los cuales tenemos el Ingreso Real proveniente de la base de 2019. Veo su distribucion con el ingreso estimado y el real
2.1 ParticipaciĆ³n Segmentos Income
## base_resume_REAL$IND0065
## Frequency Percent
## DECEASED 4 0.04564
## NO HIT 754 8.60338
## RECENT INACTIVE 552 6.29849
## TELCO ONLY 1018 11.61570
## WITH REVOLVING 5588 63.76084
## WITHOUT REVOLVING 848 9.67595
## Total 8764 100.000002.1.1 Percentiles Ingreso Estimado
## 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%
## 0 5243 6652 10603 12271 14530 18192 25932 40181 74100 1667592.1.2 Percentiles Ingreso Real
## 0% 10% 20% 30% 40% 50% 60% 70%
## 164.63 8393.89 10400.00 14000.00 15500.00 17067.20 20000.00 25934.51
## 80% 90% 100%
## 34247.51 54150.48 868350.002.2 Income Estimator Antiguo
Observamos la distribucion del income antiguo en esta base filtrada.
2.3 Estimado VS Real
Ahora revisamos los resultados del Income estimator nuevo vs el Income real.
2.4 Accuracy
Observo el porcentaje de hit y porcentaje de desviaciĆ³n entre el ingreso real y el income estimator. Observamos porcentajes de desviacion entre ambos valores.
## RI_dev_pva$diff
## Frequency Percent
## -10 6 0.06846
## -9 30 0.34231
## -8 87 0.99270
## -7 129 1.47193
## -6 237 2.70424
## -5 303 3.45733
## -4 480 5.47695
## -3 750 8.55774
## -2 1019 11.62711
## -1 1337 15.25559
## 0 1736 19.80831
## 1 1013 11.55865
## 2 615 7.01734
## 3 302 3.44592
## 4 220 2.51027
## 5 154 1.75719
## 6 137 1.56321
## 7 90 1.02693
## 8 74 0.84436
## 9 45 0.51346
## Total 8764 100.00000observed_group | n | pct | avg_observed | avg_new_predicted |
< DOP 8K | 850 | 9.6988 | 5,207.1 | 13,482 |
8K - 10.5K | 933 | 10.6458 | 9,608.1 | 14,774 |
10.5K - 14K | 856 | 9.7672 | 12,226.5 | 14,718 |
14K - 15.5K | 1,039 | 11.8553 | 15,282.6 | 14,496 |
15.5K - 17K | 698 | 7.9644 | 16,309.4 | 17,749 |
17K - 20K | 952 | 10.8626 | 18,784.3 | 20,665 |
20K - 26K | 839 | 9.5733 | 23,236.0 | 24,006 |
26K - 35K | 958 | 10.9311 | 30,387.4 | 31,308 |
35K - 55K | 800 | 9.1283 | 44,519.8 | 45,085 |
>DOP 55K | 839 | 9.5733 | 109,151.1 | 78,721 |
group | n_new_inc | pct_new_inc |
< - 30% | 3,433 | 39.1716 |
-30% - -25% | 371 | 4.2332 |
-25% - -20% | 429 | 4.8950 |
-20% - -15% | 304 | 3.4687 |
-15% - -10% | 322 | 3.6741 |
-10% - -5% | 276 | 3.1492 |
-5% - 0% | 260 | 2.9667 |
0% - 5% | 216 | 2.4646 |
5% - 10% | 208 | 2.3733 |
10% - 15% | 176 | 2.0082 |
15% - 20% | 141 | 1.6089 |
20% - 25% | 151 | 1.7230 |
25% - 30% | 147 | 1.6773 |
> 30% | 2,330 | 26.5860 |