Use the k-NN algorithm to classify the new records in the Excel file Credit Approval Decisions Classification Data using only Credit Score and Years of Credit History for k = 1 to 5.

ALL DATA HAS BEEN POSTED. Please show all work and explanations.

Credit Approval Decisions 774 555 100% Record HomeowneCredit Score'ears of Credit HistorRevolving BalancRevolving UtilizatiorDecision 1 1 725 20 $ 11,320 25% Approve 2 1 573 9 $ 7,200 70% Reject 3 1 677 11 $ 20.000 55% Approve 4 0 625 15 $ 12,800 65% Reject 5 0 527 12 $ 5,700 75% Reject 6 1 795 22 $ 9,000 12% Approve 7 0 733 7 $ 35,200 20% Approve 8 0 620 5 $ 22,800 62% Reject 9 1 591 17 $ 16,500 50% Reject 10 1 660 24 $ 9,200 35% Approve 11 1 700 19 $ 22,000 18% Approve 12 1 500 16 $ 12,500 83% Reject 13 1 565 6 $ 7,700 70% Reject 14 0 620 3 $ 37,400 87% Reject 15 1 13 $ 6,100 7% Approve 16 1 802 10 $ 10,500 5% Approve 17 0 640 7 $ 17,300 59% Reject 18 0 523 14 $ 27,000 79% Reject 19 1 811 20 $ 13,400 3% Approve 20 0 763 2 $ 11,200 70% Reject 21 0 4 $ 2,500 Reject 22 0 617 9 $ 8,400 34% Reject 23 1 642 13 $ 16,000 25% Approve 24 0 688 3 $ 3,300 11% Approve 25 1 649 12 $ 7,500 5% Approve 26 1 695 15 $ 20,300 22% Approve 27 1 701 9 $ 11,700 15% Approve 28 0 635 7 $ 29,100 85% Reject 29 0 507 2 $ 2,000 100% Reject 30 1 677 12 $ 7,600 9% Approve 31 0 485 5 $ 1,000 80% Reject 32 0 582 3 $ 8,500 65% Reject 33 1 699 17 $ 12,800 27% Approve 34 1 703 22 $ 10,000 20% Approve 35 0 585 18 $ 31,000 78% Reject 36 1 620 8 $ 16,200 55% Reject 37 1 695 16 $ 9,700 11% Approve 38 1 774 13 $ 6,100 7% Approve 39 1 802 10 $ 10,500 5% Approve 40 640 7 $ 17,300 59% Reject 41 0 536 14 $ 27,000 79% Reject 42 1 801 20 $ 13,400 3% Approve 43 0 760 2 $ 11,200 70% Reject 44 0 567 4 $ 2,200 95% Reject 45 0 600 10 $ 12,050 81% Reject 46 1 702 11 $ 11,700 15% Approve 47 1 636 8 $ 29,100 85% Reject 48 0 509 3 $ 2,000 100% Reject 49 0 595 18 $ 29,000 78% Reject 50 1 733 15 $ 13,000 24% Approve Mean Std. Dev. 0.54 0.503 652.28 90.025 11.24 6.073 13939.4 9009.520 0.4786 0.325 Normalized Data Record 5 Homeowne Credit Score'ears of Credit Historevolving BalancRevolving UtilizatiorDecision Distance 0.914 0.808 1.442 -0.291 -0.704 Approve 2.28710 0.914 -0.881 -0.369 -0.748 0.682 Reject 2.68896 0.914 0.275 -0.040 0.673 0.220 Approve 1.35578 -1.073 -0.303 0.619 -0.126 0.528 Reject 3.02751 -1.073 -1.392 0.125 -0.915 0.836 Reject 3.79052 0.914 1.585 1.772 -0.548 -1.104 Approve 2.86543 -1.073 0.897 -0.698 2.360 -0.858 Approve 2.57188 -1.073 -0.359 - 1.028 0.983 0.435 Reject 2.66695 0.914 -0.681 0.948 0.284 0.066 Reject 2.25230 0.914 0.086 2.101 -0.526 -0.396 Approve 3.03864 0.914 0.530 1.278 0.895 -0.919 Approve 1.81707 0.914 -1.692 0.784 -0.160 1.082 Reject 3.45596 0.914 -0.970 -0.863 -0.693 0.682 Reject 2.72095 -1.073 -0.359 -1.357 2.604 1.205 Reject 3.69320 0.914 1.352 0.290 -0.870 -1.258 Approve 2.03698 0.914 1.663 -0.204 -0.382 -1.320 Approve 1.68678 -1.073 -0.136 -0.698 0.373 0.343 Reject 2.53381 -1.073 -1.436 0.454 1.450 0.959 Reject 3.62116 0.914 1.763 1.442 -0.060 -1.381 Approve 2.50458 -1.073 1.230 -1.522 -0.304 0.682 Reject 3.07594 -1.073 - 1.081 -1.192 - 1.270 1.605 Reject 4.24708 -1.073 -0.392 -0.369 -0.615 -0.427 Reject 2.66841 0.914 -0.114 0.290 0.229 -0.704 Approve 1.22300 -1.073 0.397 -1.357 - 1.181 - 1.135 Approve 2.91816 0.914 -0.036 0.125 -0.715 -1.320 Approve 1.75921 0.914 0.475 0.619 0.706 -0.796 Approve 1.17652 0.914 0.541 -0.369 -0.249 -1.012 Approve 1.04535 -1.073 -0.192 -0.698 1.683 1.143 Reject 3.15377 -1.073 -1.614 -1.522 -1.325 1.605 Reject 4.56211 0.914 0.275 0.125 - 1.196 Approve 1.65691 -1.073 -1.858 - 1.028 -1.436 0.989 Reject 4.33881 -1.073 -0.781 -1.357 -0.604 0.528 Reject 3.26124 0.914 0.519 0.948 -0.126 -0.642 Approve 1.77800 0.914 0.563 1.772 -0.437 -0.858 Approve 2.61343 -1.073 -0.747 1.113 1.894 0.928 Reject 3.64450 0.914 -0.359 -0.534 0.251 0.220 Reject 1.60936 0.914 0.475 0.784 -0.471 - 1.135 Approve 1.82392 0.914 1.352 0.290 -0.870 -1.258 Approve 2.03698 0.914 1.663 -0.204 -0.382 -1.320 Approve 1.68678 -1.073 136 0.698 0.373 Reject 53381 -1.073 -1.292 0.454 1.450 0.959 Reject 3.54483 0.914 1.652 1.442 -0.060 -1.381 Approve 2.45180 -1.073 1.197 -1.522 -0.304 0.682 Reject 3.06853 -1.073 -0.947 - 1.192 -1.303 1.451 Reject 4.12092 - 1.073 -0.581 -0.204 -0.210 1.020 Reject 3.22538 0.914 0.552 -0.040 -0.249 -1.012 Approve 1.14457 0.914 -0.181 -0.534 1.683 1.143 Reject 2.44090 -1.073 -1.592 -1.357 -1.325 1.605 Reject 4.51883 - 1.073 -0.636 1.113 1.672 0.928 Reject 3.54506 0.914 0.897 0.619 -0.104 -0.735 Approve 1.52585 -0.704 Records to Classify Record Homeowne Credit Score'ears of Credit HistorRevolving BalancRevolving UtilizatiorDecision 51 1 700 8 $21,000 15% 52 0 520 1 $4,000 90% 53 1 650 10 $8,500.00 25% 54 0 602 7 $16,300.00 70% 55 0 549 2 $2,500.00 90% 1 742 15 $16,700.00 18% 56 Normalized Records Record HomeowneCredit Score'ears of Credit HistorRevolving BalancRevolving Utilizatio Decision 51 0.914 0.530 -0.534 0.784 -1.012 52 -1.073 -1.469 -1.686 -1.103 1.297 53 0.914 -0.025 -0.204 -0.604 -0.704 54 -1.073 -0.559 -0.698 0.262 0.682 55 -1.073 -1.147 -1.522 -1.270 1.297 56 0.914 0.997 0.619 0.306 -0.919 Nearest Neighbors k 1 2 3 4 5 Distance 1.04535 1.14457 1.17652 1.22300 1.35578 Record 27 46 26 23 3 Decision Approve Approve Approve Approve Approve Credit Approval Decisions 774 555 100% Record HomeowneCredit Score'ears of Credit HistorRevolving BalancRevolving UtilizatiorDecision 1 1 725 20 $ 11,320 25% Approve 2 1 573 9 $ 7,200 70% Reject 3 1 677 11 $ 20.000 55% Approve 4 0 625 15 $ 12,800 65% Reject 5 0 527 12 $ 5,700 75% Reject 6 1 795 22 $ 9,000 12% Approve 7 0 733 7 $ 35,200 20% Approve 8 0 620 5 $ 22,800 62% Reject 9 1 591 17 $ 16,500 50% Reject 10 1 660 24 $ 9,200 35% Approve 11 1 700 19 $ 22,000 18% Approve 12 1 500 16 $ 12,500 83% Reject 13 1 565 6 $ 7,700 70% Reject 14 0 620 3 $ 37,400 87% Reject 15 1 13 $ 6,100 7% Approve 16 1 802 10 $ 10,500 5% Approve 17 0 640 7 $ 17,300 59% Reject 18 0 523 14 $ 27,000 79% Reject 19 1 811 20 $ 13,400 3% Approve 20 0 763 2 $ 11,200 70% Reject 21 0 4 $ 2,500 Reject 22 0 617 9 $ 8,400 34% Reject 23 1 642 13 $ 16,000 25% Approve 24 0 688 3 $ 3,300 11% Approve 25 1 649 12 $ 7,500 5% Approve 26 1 695 15 $ 20,300 22% Approve 27 1 701 9 $ 11,700 15% Approve 28 0 635 7 $ 29,100 85% Reject 29 0 507 2 $ 2,000 100% Reject 30 1 677 12 $ 7,600 9% Approve 31 0 485 5 $ 1,000 80% Reject 32 0 582 3 $ 8,500 65% Reject 33 1 699 17 $ 12,800 27% Approve 34 1 703 22 $ 10,000 20% Approve 35 0 585 18 $ 31,000 78% Reject 36 1 620 8 $ 16,200 55% Reject 37 1 695 16 $ 9,700 11% Approve 38 1 774 13 $ 6,100 7% Approve 39 1 802 10 $ 10,500 5% Approve 40 640 7 $ 17,300 59% Reject 41 0 536 14 $ 27,000 79% Reject 42 1 801 20 $ 13,400 3% Approve 43 0 760 2 $ 11,200 70% Reject 44 0 567 4 $ 2,200 95% Reject 45 0 600 10 $ 12,050 81% Reject 46 1 702 11 $ 11,700 15% Approve 47 1 636 8 $ 29,100 85% Reject 48 0 509 3 $ 2,000 100% Reject 49 0 595 18 $ 29,000 78% Reject 50 1 733 15 $ 13,000 24% Approve Mean Std. Dev. 0.54 0.503 652.28 90.025 11.24 6.073 13939.4 9009.520 0.4786 0.325 Normalized Data Record 5 Homeowne Credit Score'ears of Credit Historevolving BalancRevolving UtilizatiorDecision Distance 0.914 0.808 1.442 -0.291 -0.704 Approve 2.28710 0.914 -0.881 -0.369 -0.748 0.682 Reject 2.68896 0.914 0.275 -0.040 0.673 0.220 Approve 1.35578 -1.073 -0.303 0.619 -0.126 0.528 Reject 3.02751 -1.073 -1.392 0.125 -0.915 0.836 Reject 3.79052 0.914 1.585 1.772 -0.548 -1.104 Approve 2.86543 -1.073 0.897 -0.698 2.360 -0.858 Approve 2.57188 -1.073 -0.359 - 1.028 0.983 0.435 Reject 2.66695 0.914 -0.681 0.948 0.284 0.066 Reject 2.25230 0.914 0.086 2.101 -0.526 -0.396 Approve 3.03864 0.914 0.530 1.278 0.895 -0.919 Approve 1.81707 0.914 -1.692 0.784 -0.160 1.082 Reject 3.45596 0.914 -0.970 -0.863 -0.693 0.682 Reject 2.72095 -1.073 -0.359 -1.357 2.604 1.205 Reject 3.69320 0.914 1.352 0.290 -0.870 -1.258 Approve 2.03698 0.914 1.663 -0.204 -0.382 -1.320 Approve 1.68678 -1.073 -0.136 -0.698 0.373 0.343 Reject 2.53381 -1.073 -1.436 0.454 1.450 0.959 Reject 3.62116 0.914 1.763 1.442 -0.060 -1.381 Approve 2.50458 -1.073 1.230 -1.522 -0.304 0.682 Reject 3.07594 -1.073 - 1.081 -1.192 - 1.270 1.605 Reject 4.24708 -1.073 -0.392 -0.369 -0.615 -0.427 Reject 2.66841 0.914 -0.114 0.290 0.229 -0.704 Approve 1.22300 -1.073 0.397 -1.357 - 1.181 - 1.135 Approve 2.91816 0.914 -0.036 0.125 -0.715 -1.320 Approve 1.75921 0.914 0.475 0.619 0.706 -0.796 Approve 1.17652 0.914 0.541 -0.369 -0.249 -1.012 Approve 1.04535 -1.073 -0.192 -0.698 1.683 1.143 Reject 3.15377 -1.073 -1.614 -1.522 -1.325 1.605 Reject 4.56211 0.914 0.275 0.125 - 1.196 Approve 1.65691 -1.073 -1.858 - 1.028 -1.436 0.989 Reject 4.33881 -1.073 -0.781 -1.357 -0.604 0.528 Reject 3.26124 0.914 0.519 0.948 -0.126 -0.642 Approve 1.77800 0.914 0.563 1.772 -0.437 -0.858 Approve 2.61343 -1.073 -0.747 1.113 1.894 0.928 Reject 3.64450 0.914 -0.359 -0.534 0.251 0.220 Reject 1.60936 0.914 0.475 0.784 -0.471 - 1.135 Approve 1.82392 0.914 1.352 0.290 -0.870 -1.258 Approve 2.03698 0.914 1.663 -0.204 -0.382 -1.320 Approve 1.68678 -1.073 136 0.698 0.373 Reject 53381 -1.073 -1.292 0.454 1.450 0.959 Reject 3.54483 0.914 1.652 1.442 -0.060 -1.381 Approve 2.45180 -1.073 1.197 -1.522 -0.304 0.682 Reject 3.06853 -1.073 -0.947 - 1.192 -1.303 1.451 Reject 4.12092 - 1.073 -0.581 -0.204 -0.210 1.020 Reject 3.22538 0.914 0.552 -0.040 -0.249 -1.012 Approve 1.14457 0.914 -0.181 -0.534 1.683 1.143 Reject 2.44090 -1.073 -1.592 -1.357 -1.325 1.605 Reject 4.51883 - 1.073 -0.636 1.113 1.672 0.928 Reject 3.54506 0.914 0.897 0.619 -0.104 -0.735 Approve 1.52585 -0.704 Records to Classify Record Homeowne Credit Score'ears of Credit HistorRevolving BalancRevolving UtilizatiorDecision 51 1 700 8 $21,000 15% 52 0 520 1 $4,000 90% 53 1 650 10 $8,500.00 25% 54 0 602 7 $16,300.00 70% 55 0 549 2 $2,500.00 90% 1 742 15 $16,700.00 18% 56 Normalized Records Record HomeowneCredit Score'ears of Credit HistorRevolving BalancRevolving Utilizatio Decision 51 0.914 0.530 -0.534 0.784 -1.012 52 -1.073 -1.469 -1.686 -1.103 1.297 53 0.914 -0.025 -0.204 -0.604 -0.704 54 -1.073 -0.559 -0.698 0.262 0.682 55 -1.073 -1.147 -1.522 -1.270 1.297 56 0.914 0.997 0.619 0.306 -0.919 Nearest Neighbors k 1 2 3 4 5 Distance 1.04535 1.14457 1.17652 1.22300 1.35578 Record 27 46 26 23 3 Decision Approve Approve Approve Approve Approve