Evaluate each field of the given dataset. Identify what type of data each field is and explain
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Financial Accounting A User Perspective
ISBN: 978-0470676608
6th Canadian Edition
Authors: Robert E Hoskin, Maureen R Fizzell, Donald C Cherry
Posted Date:
Students also viewed these accounting questions
-
Researchers have studied the ecology of ponds in rural Bangladesh. Of particular interest in such studies are the zooplankton, phytoplankton, and copepod counts (per liter of water) in these ponds....
-
The raw data for Problem 22, from Freund (1979), appear below. For the model of Problem 22, a. Fit the model. b. What discrepancies do you note between the results of (a) and the data summary...
-
The following data on air pollution in 41 U. S. cities are from Biometry (Sokal and Rohlf, 1981). The type of air pollution under study is the annual mean concentration of sulfur dioxide. The values...
-
An automobile is traveling at 60.0 km/h. Its tires have a radius of 33.0 cm. (a) Find the angular speed of the tires (in rad/s). (b) Find the angular displacement of the tires in 30.0 s. (c) Find the...
-
List some factors that would be difficult to monitor.
-
Can an accelerated frame of reference be distinguished from a gravitational field?
-
An unheated garage is placed on the north wall of a building to act as a thermal buffer zone. If the garage has roof area \(A_{p}\), window area \(A_{w i}\) door area \(A_{d}\), and wall area \(A_{w...
-
New equipment purchase, income taxes Innovation, Inc., is considering the purchase of a new industrial electric motor to improve efficiency at its Fremont plant. The motor has an estimated useful...
-
Ethnocentrism is the tendency of people toput their own culture at the center, and to use their culturalstandards to judge the behavior and beliefs of people of differentcultures. People who are...
-
Orion Controls is a leading manufacturer of industrial valve systems, and Nathan Armstrong, head of Marketing, had been contacted by Andre Gide, EVP of Avion Chemical to place an order for 50 of...
-
The process of designing and implementing a website for commercial use can be described as follows. First, the customer and the web design team have an informational meeting for half a business day....
-
What is the duration of a bond with 4 years to maturity and a coupon of 9 per cent paid annually if the bond sells at par?
-
Using the same scenario as question 6, which timing schedule would you choose to use for each communication? Why? Question 6, Imagine you are the project manager of a team tasked with building a new...
-
During the Great Depression years of 19301933, bank panics led to a dramatic rise in the currency and excess reserves ratios, while the monetary base rose by 20%. Explain how banks and depositors...
-
If you grabbed a Burger King for lunch, did some shopping at Neiman Marcus, munched at Outback Steakhouse for dinner, enjoyed a Budweiser, checked into a Hilton hotel, took a ride on an elevator made...
-
Mitsi Inventory Systems has announced a rights offer. The company has announced that it will take four rights to buy a new share in the offering at a subscription price of 40. At the close of...
-
Integer numVals is read from input and integer array student Numbers is declared with size numVals. Then, numVals integers are read from input and stored in studentNumbers. For each element in...
-
Government is advised to tax goods whose demand curves are inelastic if the goal is to raise tax revenues. If the goal is to discourage consumption, then it ought to tax goods whose demand curves are...
-
The Wizard's Corner, a company that sells video games and related items, had the following account balances at the end of June 2011: Cost of goods sold$103,000 Share capital.. 33,000 Advertising...
-
Juan Hernadez had seen many signs advertising house painters during the previous summers. Between his third and fourth year of university, he decided that he would start a painting business so that...
-
Jason Equipment Ltd. issued 10%, five-year bonds with a face value of $2,800,000 on October 1, 2011. The bonds were issued at par and pay interest on April 1 and October 1 each year. The company's...
-
Figure 7.15 shows a steel stepped cantilever beam. The steps have square cross sections of size \(100 \mathrm{~mm} \times 100 \mathrm{~mm}\) and \(50 \mathrm{~mm} \times 50 \mathrm{~mm}\) each with a...
-
A uniform simply supported beam of length \(2.5 \mathrm{~m}\) with a hollow rectangular section is shown in Fig. 7.16. Assuming a deflection shape of \[y(x)=C \sin \frac{\pi x}{l}\] find the natural...
-
A uniform fixed-fixed beam of length \(l\) with a rectangular cross section \(w \times h\) is shown in Fig. 7.17. Assuming the Young's modulus as \(E\) and unit weight as \(\gamma\) for the material...
Study smarter with the SolutionInn App