Spreadsheet: 727323d1617836116-weighted-average-credit-score-excel-formula-test
Sheet: Details

 |  |  |  |  |  |  | LoanBalance |  |  |  |  |  |  |  |  |  |  |  |  | Credit Score |  |  |  |  |  |  |  |  |  |  |  |  |  | DealerNumberFullDescription
 |  |  |  |  |  |  | 27317.25 |  |  |  |  |  |  |  |  |  |  |  |  | 553 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 9554.73 |  |  |  |  |  |  |  |  |  |  |  |  | 617 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 7934.71 |  |  |  |  |  |  |  |  |  |  |  |  | 783 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 6571.16 |  |  |  |  |  |  |  |  |  |  |  |  | 607 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 4852.85 |  |  |  |  |  |  |  |  |  |  |  |  | 756 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 748 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 328.18 |  |  |  |  |  |  |  |  |  |  |  |  | 725 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 84235.04 |  |  |  |  |  |  |  |  |  |  |  |  | 738 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 378.04 |  |  |  |  |  |  |  |  |  |  |  |  | 640 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 15805.8 |  |  |  |  |  |  |  |  |  |  |  |  | 800 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 2
 |  |  |  |  |  |  | 12189.09 |  |  |  |  |  |  |  |  |  |  |  |  | 718 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 12632.32 |  |  |  |  |  |  |  |  |  |  |  |  | 579 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 5833.39 |  |  |  |  |  |  |  |  |  |  |  |  | 645 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 36792.76 |  |  |  |  |  |  |  |  |  |  |  |  | 583 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 18476.93 |  |  |  |  |  |  |  |  |  |  |  |  | 617 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 2
 |  |  |  |  |  |  | 20453.83 |  |  |  |  |  |  |  |  |  |  |  |  | 744 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 23316.8 |  |  |  |  |  |  |  |  |  |  |  |  | 648 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 2366.98 |  |  |  |  |  |  |  |  |  |  |  |  | 731 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 11670.75 |  |  |  |  |  |  |  |  |  |  |  |  | 728 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 3960.46 |  |  |  |  |  |  |  |  |  |  |  |  | 785 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 2
 |  |  |  |  |  |  | 5843.1 |  |  |  |  |  |  |  |  |  |  |  |  | 773 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 29837.4 |  |  |  |  |  |  |  |  |  |  |  |  | 772 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 16509.08 |  |  |  |  |  |  |  |  |  |  |  |  | 807 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 22298.27 |  |  |  |  |  |  |  |  |  |  |  |  | 710 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 14493.11 |  |  |  |  |  |  |  |  |  |  |  |  | 696 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 2
 |  |  |  |  |  |  | 18686.03 |  |  |  |  |  |  |  |  |  |  |  |  | 691 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 3
 |  |  |  |  |  |  | 7576.14 |  |  |  |  |  |  |  |  |  |  |  |  | 756 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 4
 |  |  |  |  |  |  | 7133.82 |  |  |  |  |  |  |  |  |  |  |  |  | 716 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 12545.64 |  |  |  |  |  |  |  |  |  |  |  |  | 793 |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 7773.71 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 8308.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 6797.24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 12055.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1
 |  |  |  |  |  |  | 14547.86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dealer 1