Evaluate each field of the given dataset.

Identify what type of data each field is and explain your answer.

Formulate 10 analytical questions(reports) that can be answered based on the given dataset.

What are the anomalies present on the given data? Provide basic steps in solving those anomalies.

 

Transcribed Image Text:

1 AMOUNT_TRANSACTION_CURRENT MONTHS_REMAIN_MIN MONTHS_REMAIN_MAX COUNT_LOANTRANS_CURRENT AMOUNT_LOANTRANS_CURRENT AGE_MONTHS TENURE_NMONTHS_CNT_LN_TOTF LOAN_BALANCE AGE_MONTHS TENURE_MONTHS LOAN_AMO 2 41 614.8564 3 4 90 245.9426 41 1967.541 41 614.8564 99 5 6 7 8 90 614.8564 49 541.0736 96 614.8564 9 10 95 20000 11 88 12 93 13 30 614.8564 14 77 15 43 93 16 17 28 614.8564 18 24 7100 19 30 20 34 614.8564 21 26 860.799 22 81 23 81 491.8851 24 81 245.9426 25 26 27 28 29 30 31 32 33 34 35 36 37 8.853912 24.5942 97.1716842 9.1244482 0.991884 33.079199 504.2548826 33.079199 821.773768 0.983768 9.222825 129.81 309 562 33.079199 248.19 31.234634 62.71521 2.4348258 0.983768 662.567748 99.01 1046.492488 96.8519596 9.222825 1010 8.116086 7.37826 8 8 11 9 8 13 9 21 6 25 33 53 9 12 un w 12 3 11 6 44 6 17 6 6 8 8 11 9 8 13 9 21 6 25 33 53 9 24 3 11 12 3 11 19 44 6 17 6 6 1 1 2 1 1 1 1 1 1 1 1 1 1 4 1 2 1 1 5 1 1 1 1 1 8.853912 2.7545504 97.1716842 9.1244482 8.484999 504.2548826 8.484999 820.79 9.222825 117.02 308.77 561.19 8.484999 248.19 6.640434 38.12101 2.4348258 98.68 1046.452488 96.8519596 9.222825 1009.76 8.116086 7.37826 602 841 482 445 684 625 604 689 749 769 563 461 581 668 494 688 419 475 449 687 762 675 622 624 770 704 939 706 587 743 589 478 694 508 664 648 41 90 41 41 99 90 49 96 95 88 93 30 77 43 93 28 24 30 34 26 81 81 81 90 93 81 97 37 82 90 90 90 99 99 90 90 7 5 10 9 9 7 for 6 4 2 1 2 8 3 6 3 1 4 5 2 2 1 5 7 590.2608 160.2804014 899.655836 607,47674 541.0724 541.0724 541.0724 13997 614.855 2076 6865 17662 541.0724 3524 418.1014 538.858922 491.884 161.09201 908 7398.504435 2696.139175 614.855 14162 541.0724 491.884 684 749 769 563 581 668 494 419 475 762 624 770 704 480 706 743 694 664 90 93 3000 10000 20000 81 97 37 2000 82 19426.97 90 90 6886.392 90 614.8564 99 20000 99 541.0736 90 90 491.8851 1 AMOUNT_TRANSACTION_CURRENT MONTHS_REMAIN_MIN MONTHS_REMAIN_MAX COUNT_LOANTRANS_CURRENT AMOUNT_LOANTRANS_CURRENT AGE_MONTHS TENURE_NMONTHS_CNT_LN_TOTF LOAN_BALANCE AGE_MONTHS TENURE_MONTHS LOAN_AMO 2 41 614.8564 3 4 90 245.9426 41 1967.541 41 614.8564 99 5 6 7 8 90 614.8564 49 541.0736 96 614.8564 9 10 95 20000 11 88 12 93 13 30 614.8564 14 77 15 43 93 16 17 28 614.8564 18 24 7100 19 30 20 34 614.8564 21 26 860.799 22 81 23 81 491.8851 24 81 245.9426 25 26 27 28 29 30 31 32 33 34 35 36 37 8.853912 24.5942 97.1716842 9.1244482 0.991884 33.079199 504.2548826 33.079199 821.773768 0.983768 9.222825 129.81 309 562 33.079199 248.19 31.234634 62.71521 2.4348258 0.983768 662.567748 99.01 1046.492488 96.8519596 9.222825 1010 8.116086 7.37826 8 8 11 9 8 13 9 21 6 25 33 53 9 12 un w 12 3 11 6 44 6 17 6 6 8 8 11 9 8 13 9 21 6 25 33 53 9 24 3 11 12 3 11 19 44 6 17 6 6 1 1 2 1 1 1 1 1 1 1 1 1 1 4 1 2 1 1 5 1 1 1 1 1 8.853912 2.7545504 97.1716842 9.1244482 8.484999 504.2548826 8.484999 820.79 9.222825 117.02 308.77 561.19 8.484999 248.19 6.640434 38.12101 2.4348258 98.68 1046.452488 96.8519596 9.222825 1009.76 8.116086 7.37826 602 841 482 445 684 625 604 689 749 769 563 461 581 668 494 688 419 475 449 687 762 675 622 624 770 704 939 706 587 743 589 478 694 508 664 648 41 90 41 41 99 90 49 96 95 88 93 30 77 43 93 28 24 30 34 26 81 81 81 90 93 81 97 37 82 90 90 90 99 99 90 90 7 5 10 9 9 7 for 6 4 2 1 2 8 3 6 3 1 4 5 2 2 1 5 7 590.2608 160.2804014 899.655836 607,47674 541.0724 541.0724 541.0724 13997 614.855 2076 6865 17662 541.0724 3524 418.1014 538.858922 491.884 161.09201 908 7398.504435 2696.139175 614.855 14162 541.0724 491.884 684 749 769 563 581 668 494 419 475 762 624 770 704 480 706 743 694 664 90 93 3000 10000 20000 81 97 37 2000 82 19426.97 90 90 6886.392 90 614.8564 99 20000 99 541.0736 90 90 491.8851

Answer rating: 100% (QA)

ANSWER a The given dataset contains 37 rows and 11 columns The fields in the dataset are as follows 1 AMOUNT TRANSACTIONCURRENT The amount of current ... View the full answer