Exercise 3 Excel data visualization (11 points) Go find the loan dataset posted on the online site (data taken from Evans' book) It is data about loan applications to a bank The data displays the purpose of the loan, the checking and saving accounts balances, number of months as customers of the bank, months employed, gender, marital status, housing status and the credit risk estimated by the bank 1 Sum checking and savings for each record and then build a scatter plot to try to see if there is a correlation between assets per customer and time as a customer in the bank Is there a correlation 2 Create a box plot showing the variation in the checking saving combination Make sure it is easy to read 3 Construct a PivotTable showing counts per marital status (columns) per purpose of loan (rows) 4 Create a bar chart based on the PivotTable in 3 5 What happens to the chart if you add a filter to the PivotTable and manipulate it Loan Purpose Checking Savings Months Customer Marital Status Credit Risk Months Employed Gender Housing Small Appliance $298 $3,326 73 Single Low 41 M Own New Car $11,072 $891 61 Divorced High 2 F Own Other $852 $3,613 61 Single Low 35 M Own Education $713 $784 61 Single Low 35 M Own Small Appliance $795 $16,804 49 Divorced High 2 F Rent New Car $0 $9,016 49 Married Low 119 M Own Business $2,715 $1,435 49 Divorced High 3 F Own Business $674 $2,886 49 Divorced Low 14 F Own Used Car $2,484 $0 49 Divorced High 1 F Own Education $996 $837 49 Divorced Low 18 F Own Business $778 $861 49 Single High 8 M Rent Furniture $652 $732 49 Divorced High 5 F Rent Business $0 $989 49 Single Low 100 M Own Used Car $0 $973 49 Divorced High 2 F Own Small Appliance $955 $0 49 Divorced High 3 F Own New Car $949 $0 49 Married Low 42 M Own Small Appliance $514 $405 49 Single Low 70 M Own Small Appliance $152 $757 49 Divorced Low 53 F Own Used Car $0 $904 49 Single High 3 M Own New Car $0 $862 49 Single Low 21 M Rent Business $0 $800 49 Single Low 13 M Own Business $257 $460 49 Married Low 14 M Rent Used Car $0 $612 49 Married High 4 M Own Large Appliance $0 $409 49 Single High 90 M Own Used Car $0 $396 49 Single Low 26 M Rent Small Appliance $0 $323 49 Single High 0 M Own Used Car $0 $309 49 Single Low 23 M Other Other $218 $0 49 Divorced High 52 F Other Business $177 $0 49 Single Low 51 M Rent Business $0 $150 49 Single Low 39 M Own New Car $0 $116 49 Married High 4 M Other New Car $0 $821 48 Divorced Low 40 F Own Small Appliance $956 $1,482 46 Divorced High 12 F Own Small Appliance $911 $823 46 Divorced High 0 F Rent Small Appliance $0 $192 46 Married Low 14 M Rent Used Car $219 $841 43 Single Low 81 M Own Small Appliance $0 $813 43 Divorced Low 65 F Own Repairs $0 $626 43 Single Low 16 M Own Small Appliance $0 $148 43 Divorced High 2 F Own Small Appliance $0 $0 43 Single Low 66 M Own Education $0 $497 41 Single High 19 M Other Education $963 $4,754 40 Single High 3 M Own Used Car $0 $1,519 40 Divorced High 61 F Own Furniture $0 $0 40 Single Low 13 M Own Small Appliance $16,935 $189 37 Divorced High 18 F Own New Car $0 $14,190 37 Single High 30 M Rent Furniture $0 $12,721 37 Single Low 99 M Rent Small Appliance $6,509 $493 37 Single Low 89 M Rent Small Appliance $0 $6,628 37 Single High 40 M Rent New Car $4,802 $0 37 Divorced Low 24 F Own New Car $682 $2,017 37 Married Low 13 M Own Small Appliance $900 $1,732 37 Single Low 15 M Rent New Car $889 $1,583 37 Single Low 15 M Own Used Car $2,472 $0 37 Divorced High 6 F Own Education $335 $1,708 37 Divorced Low 14 M Own New Car $624 $785 37 Single High 13 M Own Used Car $1,336 $0 37 Single Low 34 M Own Business $498 $598 37 Single High 5 M Rent Furniture $0 $987 37 Divorced High 54 F Rent Education $0 $922 37 Single Low 21 M Own New Car $296 $591 37 Single Low 47 M Own Education $842 $0 37 Single High 10 M Own New Car $0 $770 37 Divorced High 5 F Own Business $0 $750 37 Divorced High 5 F Own Furniture $0 $734 37 Single High 0 M Own Furniture $0 $717 37 Single Low 22 M Own Used Car $0 $674 37 Single Low 12 M Own Small Appliance $0 $656 37 Single High 14 M Own Small Appliance $651 $0 37 Married Low 16 M Own Used Car $109 $540 37 Single Low 26 M Other Used Car $0 $609 37 Single Low 33 M Own Used Car $0 $607 37 Divorced High 3 F Own New Car $0 $605 37 Divorced High 6 F Own New Car $122 $460 37 Single High 74 M Own Other $0 $523 37 Divorced Low 16 F Own Furniture $0 $485 37 Divorced Low 46 F Rent Repairs $216 $262 37 Single Low 31 M Own Small Appliance $237 $236 37 Single High 69 M Own Furniture $0 $367 37 Divorced High 3 F Own Education $197 $0 37 Divorced High 5 F Own Furniture $0 $154 37 Divorced High 3 F Own New Car $135 $0 37 Divorced High 21 F Other Used Car $0 $104 37 Single Low 88 M Own Education $0 $0 37 Single High 22 M Own Used Car $0 $0 37 Single High 89 M Rent Furniture $0 $17,545 34 Divorced Low 21 F Own Business $8,948 $110 31 Single High 0 M Own Small Appliance $8,249 $0 31 Single Low 73 M Own Business $670 $4,014 31 Single Low 94 M Other Small Appliance $3,565 $0 31 Divorced High 2 F Own Furniture $876 $1,533 31 Married High 8 M Rent New Car $789 $989 31 Single High 89 M Own New Car $382 $883 31 Single High 17 M Own Furniture $664 $537 31 Married High 4 M Own Furniture $617 $411 31 Single Low 63 M Own Small Appliance $0 $867 31 Divorced Low 14 F Own Used Car $0 $859 31 Single High 111 M Other Furniture $0 $706 31 Divorced High 1 F Own Repairs $0 $609 31 Married High 6 M Own Small Appliance $0 $519 31 Divorced Low 48 F Own Used Car $399 $0 31 Divorced High 0 F Own Furniture $0 $204 31 Single High 6 M Own Used Car $0 $129 31 Divorced High 7 F Own Furniture $0 $127 31 Single Low 23 M Own Furniture $0 $0 31 Divorced High 15 F Other New Car $0 $667 29 Divorced High 7 F Rent Used Car $0 $14,717 28 Divorced High 0 F Own Small Appliance $959 $7,876 28 Single Low 21 M Rent Business $870 $917 28 Divorced High 24 F Other Business $986 $578 28 Divorced Low 12 F Other Business $444 $921 28 Divorced High 58 F Rent New Car $0 $500 28 Divorced High 11 F Own Used Car $105 $320 28 Divorced Low 71 F Own Business $0 $322 28 Single High 9 M Other Repairs $207 $0 28 Divorced High 10 F Own New Car $19,812 $0 25 Single Low 38 M Own Furniture $19,155 $131 25 Divorced Low 65 F Rent Business $15,328 $0 25 Married High 35 M Own Small Appliance $0 $12,242 25 Divorced High 15 F Own Business $0 $11,481 25 Single High 14 M Own Small Appliance $0 $10,853 25 Divorced High 24 F Own New Car $9,621 $308 25 Single High 119 M Own Furniture $0 $8,944 25 Single High 29 M Own Furniture $0 $8,357 25 Single Low 62 M Own Furniture $0 $7,710 25 Single Low 67 M Own Used Car $271 $7,090 25 Single High 4 M Own Used Car $0 $6,345 25 Married Low 16 M Other Small Appliance $0 $5,564 25 Single Low 111 M Rent Business $0 $4,973 25 Divorced Low 27 F Own Small Appliance $0 $4,449 25 Single Low 14 M Rent Business $859 $3,305 25 Divorced High 10 F Rent New Car $942 $3,036 25 Married Low 95 M Own Small Appliance $0 $3,870 25 Married High 40 M Own Furniture $0 $3,369 25 Married High 27 M Own New Car $1,613 $0 25 Divorced High 65 F Own Other $645 $855 25 Divorced High 4 M Own Other $560 $887 25 Single Low 23 M Own Furniture $0 $1,230 25 Divorced High 40 M Rent Small Appliance $265 $947 25 Single Low 106 M Own Used Car $0 $999 25 Divorced High 0 M Own Furniture $0 $979 25 Divorced High 4 F Own Small Appliance $966 $0 25 Divorced High 1 M Rent Furniture $757 $208 25 Single High 8 M Other Small Appliance $0 $956 25 Married High 5 M Own Education $798 $137 25 Divorced High 57 M Own Furniture $0 $909 25 Single Low 34 M Own Furniture $0 $836 25 Divorced Low 36 F Own Small Appliance $0 $836 25 Single Low 115 M Own Small Appliance $0 $823 25 Single High 59 M Rent New Car $0 $821 25 Married High 4 M Own Repairs $0 $807 25 Single Low 94 M Own Small Appliance $0 $798 25 Married High 20 M Own Used Car $0 $789 25 Single High 5 M Own Repairs $0 $772 25 Single Low 14 M Own New Car $0 $771 25 Single Low 12 M Other New Car $0 $761 25 Divorced High 3 F Rent Business $509 $241 25 Single Low 108 M Own Business $0 $724 25 Divorced Low 19 F Own Business $522 $194 25 Divorced High 5 F Other Small Appliance $0 $710 25 Divorced High 11 F Own Education $705 $0 25 Single Low 83 M Rent Small Appliance $0 $680 25 Divorced High 3 F Rent Used Car $646 $0 25 Divorced High 0 F Rent Small Appliance $0 $552 25 Single High 21 M Own New Car $332 $214 25 Single Low 40 M Rent New Car $0 $544 25 Single High 0 M Own Furniture $0 $538 25 Single High 75 M Own Furniture $0 $506 25 Single High 119 M Own Business $0 $500 25 Single High 58 M Rent New Car $0 $466 25 Single Low 12 M Own New Car $0 $412 25 Divorced High 4 F Rent Furniture $192 $199 25 Single High 1 M Own Used Car $374 $0 25 Single Low 32 M Own Small Appliance $0 $337 25 Single High 0 M Own Used Car $0 $276 25 Single Low 17 M Own Used Car $0 $270 25 Divorced High 2 F Own Used Car $0 $260 25 Divorced High 20 F Own Business $172 $0 25 Single Low 108 M Own Furniture $0 $162 25 Single High 14 M Own Furniture $0 $146 25 Single High 6 M Own New Car $0 $113 25 Married High 14 M Own Used Car $0 $109 25 Single High 20 M Own New Car $0 $108 25 Divorced Low 15 F Own Business $0 $104 25 Divorced High 7 F Own Furniture $0 $0 25 Single High 56 M Own Other $0 $0 25 Single High 10 M Own New Car $0 $0 25 Divorced High 13 F Own New Car $0 $0 25 Divorced High 0 F Rent New Car $3,880 $0 23 Single High 15 M Own Small Appliance $0 $17,653 22 Divorced High 3 M Own Furniture $468 $14,186 22 Divorced High 5 M Own New Car $0 $11,587 22 Single Low 93 M Rent Education $8,122 $136 22 Married High 0 M Own New Car $5,588 $0 22 Single Low 85 M Rent Business $0 $5,180 22 Single High 9 M Own Business $339 $2,790 22 Divorced High 42 F Own Business $898 $177 22 Single High 7 M Own New Car $0 $886 22 Divorced High 11 F Own New Car $162 $595 22 Single Low 57 M Other Small Appliance $0 $717 22 Divorced High 9 F Own Used Car $0 $701 22 Single Low 29 M Own Furniture $0 $636 22 Single High 2 M Own New Car $0 $579 22 Married High 1 M Own Business $141 $245 22 Divorced Low 71 F Own New Car $0 $0 22 Divorced Low 22 F Rent Small Appliance $0 $18,716 19 Divorced High 2 M Own Furniture $13,496 $650 19 Single High 23 M Own New Car $8,060 $607 19 Single Low 20 M Own Small Appliance $0 $6,490 19 Divorced High 2 F Rent Furniture $0 $5,857 19 Divorced High 90 F Own Small Appliance $5,133 $698 19 Single High 7 M Own New Car $3,329 $0 19 Single High 28 M Other Education $0 $3,281 19 Single High 13 M Rent New Car $644 $1,571 19 Single High 33 M Own New Car $939 $496 19 Divorced High 3 F Rent New Car $0 $1,366 19 Divorced High 16 F Rent Small Appliance $296 $818 19 Single High 2 M Own Repairs $271 $759 19 Married Low 93 M Own Furniture $0 $957 19 Single High 13 M Own Furniture $0 $948 19 Single High 4 M Own Business $0 $922 19 Single Low 33 M Own Small Appliance $0 $914 19 Single High 0 M Own Small Appliance $483 $415 19 Divorced High 4 F Rent Small Appliance $0 $897 19 Divorced High 2 F Own Repairs $0 $897 19 Divorced High 55 M Rent Business $0 $859 19 Single Low 24 M Other Furniture $0 $835 19 Single Low 96 M Own Furniture $0 $815 19 Divorced Low 2 F Own New Car $0 $806 19 Single Low 0 M Own Furniture $305 $492 19 Divorced Low 41 F Own Furniture $457 $318 19 Single Low 108 M Own Large Appliance $0 $775 19 Married Low 2 M Own Small Appliance $0 $726 19 Divorced Low 46 F Own Repairs $0 $718 19 Divorced High 105 F Own New Car $0 $716 19 Single Low 2 M Own New Car $0 $693 19 Married Low 70 M Rent Business $663 $0 19 Divorced Low 37 F Rent New Car $0 $659 19 Married Low 5 M Other Small Appliance $0 $643 19 Divorced Low 0 F Own New Car $461 $140 19 Single High 63 M Own Business $0 $565 19 Married High 23 M Rent Furniture $0 $544 19 Divorced Low 5 F Own New Car $0 $541 19 Single Low 26 M Own Small Appliance $0 $485 19 Divorced Low 0 F Own New Car $0 $483 19 Divorced Low 5 F Rent Furniture $0 $479 19 Single Low 28 M Rent Furniture $0 $435 19 Married Low 1 M Own New Car $425 $0 19 Divorced Low 3 F Own Small Appliance $0 $418 19 Divorced Low 3 F Own New Car $0 $389 19 Divorced Low 4 F Rent New Car $0 $343 19 Divorced High 79 M Other Furniture $0 $340 19 Divorced Low 1 F Own Small Appliance $0 $325 19 Single Low 93 M Own Furniture $0 $299 19 Single High 41 M Rent Small Appliance $242 $0 19 Single High 14 M Own Furniture $216 $0 19 Single Low 24 M Own Furniture $0 $169 19 Divorced Low 81 F Own Used Car $0 $0 19 Single Low 14 M Rent New Car $0 $660 17 Single High 53 M Own Business $16,647 $895 16 Single High 42 M Own Small Appliance $17,366 $0 16 Single High 87 M Own Large Appliance $0 $15,800 16 Single High 54 M Other Small Appliance $0 $14,643 16 Married Low 23 M Rent Used Car $7,885 $6,330 16 Single Low 99 M Own Furniture $0 $12,632 16 Single Low 6 M Other Used Car $0 $10,099 16 Single Low 25 M Own New Car $698 $4,033 16 Single Low 78 M Rent Furniture $4,256 $0 16 Single Low 36 M Other Education $0 $3,105 16 Single Low 19 M Own New Car $585 $2,223 16 Divorced Low 0 F Own New Car $497 $888 16 Single High 48 M Rent Small Appliance $946 $0 16 Divorced Low 19 M Own Small Appliance $893 $0 16 Divorced Low 2 F Own Furniture $0 $836 16 Divorced Low 9 F Own New Car $0 $759 16 Single Low 36 M Other New Car $0 $712 16 Divorced High 19 F Own New Car $0 $509 16 Divorced Low 6 M Own Small Appliance $0 $408 16 Single Low 47 M Own Furniture $0 $347 16 Single High 20 M Own Small Appliance $0 $296 16 Divorced Low 7 F Own New Car $0 $648 15 Divorced Low 10 F Other Small Appliance $0 $3,529 14 Divorced Low 0 F Other Business $0 $533 14 Single High 17 M Other Small Appliance $12,974 $19,568 13 Single High 37 M Other New Car $10,417 $19,811 13 Divorced Low 4 F Own New Car $18,408 $212 13 Single Low 26 M Rent Business $12,760 $4,873 13 Single Low 66 M Own Small Appliance $0 $17,124 13 Single Low 75 M Own Furniture $0 $13,970 13 Divorced Low 9 F Rent Small Appliance $317 $10,980 13 Single High 18 M Own Business $9,783 $885 13 Single High 52 M Own New Car $0 $9,125 13 Divorced High 31 F Rent Furniture $352 $7,525 13 Married Low 118 M Own Small Appliance $6,851 $901 13 Divorced High 36 M Own Small Appliance $5,960 $129 13 Single Low 3 M Own Furniture $101 $3,871 13 Single Low 107 M Other Business $758 $2,665 13 Divorced Low 24 F Own Small Appliance $0 $3,273 13 Single Low 114 M Own Repairs $3,111 $0 13 Single High 42 M Own New Car $193 $2,684 13 Single High 59 M Own Small Appliance $2,846 $0 13 Married Low 7 M Own New Car $2,641 $0 13 Single High 46 M Other Furniture $983 $950 13 Single Low 2 M Rent New Car $708 $683 13 Single High 22 M Own Large Appliance $0 $1,238 13 Single Low 17 M Own Small Appliance $0 $1,218 13 Single Low 17 M Own Small Appliance $303 $899 13 Single High 92 M Rent Small Appliance $895 $243 13 Single Low 91 M Own New Car $166 $922 13 Divorced High 25 F Rent Furniture $638 $347 13 Divorced High 103 F Own Small Appliance $0 $970 13 Single Low 116 M Other Furniture $0 $945 13 Divorced Low 0 F Rent Furniture $0 $941 13 Single Low 28 M Rent New Car $538 $344 13 Single High 20 M Own Small Appliance $0 $861 13 Divorced Low 9 F Own Used Car $819 $0 13 Single Low 54 M Own Furniture $0 $803 13 Single Low 3 M Own Furniture $0 $800 13 Single Low 8 M Own New Car $315 $466 13 Divorced High 51 F Own Small Appliance $0 $763 13 Divorced Low 5 F Own New Car $0 $750 13 Single Low 4 M Own Furniture $0 $746 13 Single Low 32 M Other Small Appliance $0 $739 13 Single High 33 M Other Furniture $0 $736 13 Married Low 5 M Own New Car $0 $713 13 Divorced Low 14 M Own Furniture $161 $524 13 Divorced High 21 F Rent Retraining $644 $0 13 Divorced Low 1 F Own Furniture $642 $0 13 Single Low 6 M Other New Car $0 $637 13 Single High 90 M Own New Car $396 $228 13 Divorced High 35 F Rent Retraining $0 $603 13 Single Low 89 M Own Small Appliance $0 $596 13 Divorced Low 27 F Other Small Appliance $586 $0 13 Single Low 77 M Own Small Appliance $0 $552 13 Divorced High 20 F Own New Car $0 $547 13 Divorced Low 23 F Other New Car $0 $531 13 Divorced Low 2 F Own New Car $0 $508 13 Divorced High 21 F Own Small Appliance $0 $503 13 Single Low 4 M Own Furniture $0 $493 13 Single High 53 M Own New Car $0 $490 13 Divorced High 16 F Own New Car $0 $470 13 Single Low 11 M Own Furniture $0 $461 13 Divorced High 23 F Own New Car $0 $457 13 Single Low 24 M Own Small Appliance $0 $425 13 Divorced Low 0 F Rent Small Appliance $0 $407 13 Single Low 60 M Own Small Appliance $0 $364 13 Single High 114 M Rent Furniture $0 $322 13 Single High 60 M Own Business $0 $265 13 Single Low 85 M Own Education $0 $238 13 Single High 25 M Rent New Car $0 $229 13 Single Low 6 M Own Small Appliance $0 $208 13 Divorced Low 10 M Own New Car $0 $207 13 Single Low 79 M Other Used Car $0 $178 13 Divorced Low 4 F Own Education $0 $164 13 Single Low 9 M Own Used Car $0 $160 13 Divorced Low 1 F Rent Small Appliance $156 $0 13 Single Low 3 M Other New Car $0 $128 13 Divorced High 20 F Own Education $0 $127 13 Single Low 0 M Own Furniture $0 $0 13 Divorced High 14 M Other Furniture $150 $6,520 12 Single Low 2 M Rent Small Appliance $0 $1,851 12 Single High 111 M Own New Car $0 $904 12 Single High 85 M Own New Car $0 $486 12 Single High 49 M Own New Car $19,766 $2,141 11 Married Low 17 M Own Small Appliance $16,630 $0 11 Single Low 65 M Own New Car $0 $10,723 11 Single High 103 M Other Furniture $8,636 $214 11 Single Low 22 M Other New Car $0 $3,305 11 Divorced Low 9 M Own Furniture $2,827 $0 11 Single Low 7 M Own Small Appliance $0 $959 11 Single Low 12 M Other New Car $0 $857 11 Single High 101 M Own Furniture $113 $692 11 Single Low 102 M Other New Car $580 $0 11 Divorced Low 31 F Own Furniture $0 $463 11 Divorced Low 1 F Own Used Car $0 $0 11 Single Low 92 M Own Small Appliance $765 $10,406 10 Divorced Low 8 M Rent New Car $478 $4,071 10 Single Low 41 M Rent Furniture $0 $4,486 10 Single High 109 M Other Repairs $0 $2,688 10 Single High 17 M Own Education $977 $463 10 Single Low 69 M Other Small Appliance $565 $863 10 Married Low 3 M Own Furniture $759 $596 10 Single Low 45 M Own Education $1,257 $0 10 Single Low 74 M Own Small Appliance $256 $954 10 Single Low 30 M Own Small Appliance $231 $702 10 Single High 24 M Own Education $522 $385 10 Single Low 6 M Own Business $322 $578 10 Divorced Low 9 F Own Small Appliance $0 $762 10 Divorced High 28 F Own New Car $0 $374 10 Single High 28 M Own New Car $0 $369 10 Single Low 11 M Own Small Appliance $0 $302 10 Single High 13 M Other Small Appliance $940 $715 9 Divorced Low 0 M Own Furniture $828 $391 9 Single High 19 M Own Business $929 $124 9 Single Low 9 M Own Small Appliance $211 $822 8 Single Low 0 M Rent New Car $8,176 $12,230 7 Single Low 0 M Other Used Car $0 $13,428 7 Single Low 46 M Rent Education $287 $12,348 7 Divorced High 46 F Own Small Appliance $0 $11,838 7 Married High 42 M Own New Car $305 $4,553 7 Divorced Low 5 F Own Furniture $4,089 $0 7 Single Low 32 M Own Business $0 $3,285 7 Divorced High 13 F Own Small Appliance $829 $583 7 Single High 45 M Own Small Appliance $887 $519 7 Single High 15 M Own Repairs $273 $904 7 Single Low 37 M Other Small Appliance $734 $348 7 Divorced High 14 M Other Furniture $0 $991 7 Single High 45 M Own Furniture $513 $442 7 Single Low 0 M Rent New Car $0 $912 7 Single High 21 M Own Small Appliance $0 $707 7 Single High 22 M Rent Small Appliance $0 $576 7 Single High 40 M Own Small Appliance $497 $0 7 Divorced Low 36 F Own Education $0 $471 7 Divorced High 81 F Rent Education $0 $403 7 Single High 119 M Own Furniture $0 $369 7 Single Low 9 M Rent New Car $0 $272 7 Single High 83 M Rent New Car $0 $192 7 Divorced High 75 F Own Furniture $0 $142 7 Single Low 29 M Other Small Appliance $0 $138 7 Single High 32 M Own New Car $0 $127 7 Single High 62 M Own New Car $0 $102 7 Single High 73 M Other Business $0 $406 6 Single High 17 M Own Small Appliance $0 $490 5 Divorced High 83 F Own Small Appliance $0 $364 5 Single Low 17 M Own Furniture $0 $180 5 Married High 15 M Own

The Answer is in the image, click to view ...

Question: Exercise 3: Excel data visualization (11 points) Go find the loan dataset posted on the online site (data taken from Evans' book). It is data

Exercise 3: Excel data visualization (11 points) Go find the loan dataset posted on the online site (data taken from Evans' book). It is data about loan applications to a bank. The data displays the purpose of the loan, the checking and saving accounts balances, number of months as customers of the bank, months employed, gender, marital status, housing status and the credit risk estimated by the bank.

1. Sum checking and savings for each record and then build a scatter plot to try to see if there is a correlation between assets per customer and time as a customer in the bank. Is there a correlation?

2. Create a box plot showing the variation in the checking+saving combination. Make sure it is easy to read.

3. Construct a PivotTable showing counts per marital status (columns) per purpose of loan (rows).

4. Create a bar chart based on the PivotTable in 3.

5. What happens to the chart if you add a filter to the PivotTable and manipulate it?

Loan Purpose	Checking	Savings	Months Customer	Marital Status	Credit Risk	Months Employed	Gender	Housing
Small Appliance	$298	$3,326	73	Single	Low	41	M	Own
New Car	$11,072	$891	61	Divorced	High	2	F	Own
Other	$852	$3,613	61	Single	Low	35	M	Own
Education	$713	$784	61	Single	Low	35	M	Own
Small Appliance	$795	$16,804	49	Divorced	High	2	F	Rent
New Car	$0	$9,016	49	Married	Low	119	M	Own
Business	$2,715	$1,435	49	Divorced	High	3	F	Own
Business	$674	$2,886	49	Divorced	Low	14	F	Own
Used Car	$2,484	$0	49	Divorced	High	1	F	Own
Education	$996	$837	49	Divorced	Low	18	F	Own
Business	$778	$861	49	Single	High	8	M	Rent
Furniture	$652	$732	49	Divorced	High	5	F	Rent
Business	$0	$989	49	Single	Low	100	M	Own
Used Car	$0	$973	49	Divorced	High	2	F	Own
Small Appliance	$955	$0	49	Divorced	High	3	F	Own
New Car	$949	$0	49	Married	Low	42	M	Own
Small Appliance	$514	$405	49	Single	Low	70	M	Own
Small Appliance	$152	$757	49	Divorced	Low	53	F	Own
Used Car	$0	$904	49	Single	High	3	M	Own
New Car	$0	$862	49	Single	Low	21	M	Rent
Business	$0	$800	49	Single	Low	13	M	Own
Business	$257	$460	49	Married	Low	14	M	Rent
Used Car	$0	$612	49	Married	High	4	M	Own
Large Appliance	$0	$409	49	Single	High	90	M	Own
Used Car	$0	$396	49	Single	Low	26	M	Rent
Small Appliance	$0	$323	49	Single	High	0	M	Own
Used Car	$0	$309	49	Single	Low	23	M	Other
Other	$218	$0	49	Divorced	High	52	F	Other
Business	$177	$0	49	Single	Low	51	M	Rent
Business	$0	$150	49	Single	Low	39	M	Own
New Car	$0	$116	49	Married	High	4	M	Other
New Car	$0	$821	48	Divorced	Low	40	F	Own
Small Appliance	$956	$1,482	46	Divorced	High	12	F	Own
Small Appliance	$911	$823	46	Divorced	High	0	F	Rent
Small Appliance	$0	$192	46	Married	Low	14	M	Rent
Used Car	$219	$841	43	Single	Low	81	M	Own
Small Appliance	$0	$813	43	Divorced	Low	65	F	Own
Repairs	$0	$626	43	Single	Low	16	M	Own
Small Appliance	$0	$148	43	Divorced	High	2	F	Own
Small Appliance	$0	$0	43	Single	Low	66	M	Own
Education	$0	$497	41	Single	High	19	M	Other
Education	$963	$4,754	40	Single	High	3	M	Own
Used Car	$0	$1,519	40	Divorced	High	61	F	Own
Furniture	$0	$0	40	Single	Low	13	M	Own
Small Appliance	$16,935	$189	37	Divorced	High	18	F	Own
New Car	$0	$14,190	37	Single	High	30	M	Rent
Furniture	$0	$12,721	37	Single	Low	99	M	Rent
Small Appliance	$6,509	$493	37	Single	Low	89	M	Rent
Small Appliance	$0	$6,628	37	Single	High	40	M	Rent
New Car	$4,802	$0	37	Divorced	Low	24	F	Own
New Car	$682	$2,017	37	Married	Low	13	M	Own
Small Appliance	$900	$1,732	37	Single	Low	15	M	Rent
New Car	$889	$1,583	37	Single	Low	15	M	Own
Used Car	$2,472	$0	37	Divorced	High	6	F	Own
Education	$335	$1,708	37	Divorced	Low	14	M	Own
New Car	$624	$785	37	Single	High	13	M	Own
Used Car	$1,336	$0	37	Single	Low	34	M	Own
Business	$498	$598	37	Single	High	5	M	Rent
Furniture	$0	$987	37	Divorced	High	54	F	Rent
Education	$0	$922	37	Single	Low	21	M	Own
New Car	$296	$591	37	Single	Low	47	M	Own
Education	$842	$0	37	Single	High	10	M	Own
New Car	$0	$770	37	Divorced	High	5	F	Own
Business	$0	$750	37	Divorced	High	5	F	Own
Furniture	$0	$734	37	Single	High	0	M	Own
Furniture	$0	$717	37	Single	Low	22	M	Own
Used Car	$0	$674	37	Single	Low	12	M	Own
Small Appliance	$0	$656	37	Single	High	14	M	Own
Small Appliance	$651	$0	37	Married	Low	16	M	Own
Used Car	$109	$540	37	Single	Low	26	M	Other
Used Car	$0	$609	37	Single	Low	33	M	Own
Used Car	$0	$607	37	Divorced	High	3	F	Own
New Car	$0	$605	37	Divorced	High	6	F	Own
New Car	$122	$460	37	Single	High	74	M	Own
Other	$0	$523	37	Divorced	Low	16	F	Own
Furniture	$0	$485	37	Divorced	Low	46	F	Rent
Repairs	$216	$262	37	Single	Low	31	M	Own
Small Appliance	$237	$236	37	Single	High	69	M	Own
Furniture	$0	$367	37	Divorced	High	3	F	Own
Education	$197	$0	37	Divorced	High	5	F	Own
Furniture	$0	$154	37	Divorced	High	3	F	Own
New Car	$135	$0	37	Divorced	High	21	F	Other
Used Car	$0	$104	37	Single	Low	88	M	Own
Education	$0	$0	37	Single	High	22	M	Own
Used Car	$0	$0	37	Single	High	89	M	Rent
Furniture	$0	$17,545	34	Divorced	Low	21	F	Own
Business	$8,948	$110	31	Single	High	0	M	Own
Small Appliance	$8,249	$0	31	Single	Low	73	M	Own
Business	$670	$4,014	31	Single	Low	94	M	Other
Small Appliance	$3,565	$0	31	Divorced	High	2	F	Own
Furniture	$876	$1,533	31	Married	High	8	M	Rent
New Car	$789	$989	31	Single	High	89	M	Own
New Car	$382	$883	31	Single	High	17	M	Own
Furniture	$664	$537	31	Married	High	4	M	Own
Furniture	$617	$411	31	Single	Low	63	M	Own
Small Appliance	$0	$867	31	Divorced	Low	14	F	Own
Used Car	$0	$859	31	Single	High	111	M	Other
Furniture	$0	$706	31	Divorced	High	1	F	Own
Repairs	$0	$609	31	Married	High	6	M	Own
Small Appliance	$0	$519	31	Divorced	Low	48	F	Own
Used Car	$399	$0	31	Divorced	High	0	F	Own
Furniture	$0	$204	31	Single	High	6	M	Own
Used Car	$0	$129	31	Divorced	High	7	F	Own
Furniture	$0	$127	31	Single	Low	23	M	Own
Furniture	$0	$0	31	Divorced	High	15	F	Other
New Car	$0	$667	29	Divorced	High	7	F	Rent
Used Car	$0	$14,717	28	Divorced	High	0	F	Own
Small Appliance	$959	$7,876	28	Single	Low	21	M	Rent
Business	$870	$917	28	Divorced	High	24	F	Other
Business	$986	$578	28	Divorced	Low	12	F	Other
Business	$444	$921	28	Divorced	High	58	F	Rent
New Car	$0	$500	28	Divorced	High	11	F	Own
Used Car	$105	$320	28	Divorced	Low	71	F	Own
Business	$0	$322	28	Single	High	9	M	Other
Repairs	$207	$0	28	Divorced	High	10	F	Own
New Car	$19,812	$0	25	Single	Low	38	M	Own
Furniture	$19,155	$131	25	Divorced	Low	65	F	Rent
Business	$15,328	$0	25	Married	High	35	M	Own
Small Appliance	$0	$12,242	25	Divorced	High	15	F	Own
Business	$0	$11,481	25	Single	High	14	M	Own
Small Appliance	$0	$10,853	25	Divorced	High	24	F	Own
New Car	$9,621	$308	25	Single	High	119	M	Own
Furniture	$0	$8,944	25	Single	High	29	M	Own
Furniture	$0	$8,357	25	Single	Low	62	M	Own
Furniture	$0	$7,710	25	Single	Low	67	M	Own
Used Car	$271	$7,090	25	Single	High	4	M	Own
Used Car	$0	$6,345	25	Married	Low	16	M	Other
Small Appliance	$0	$5,564	25	Single	Low	111	M	Rent
Business	$0	$4,973	25	Divorced	Low	27	F	Own
Small Appliance	$0	$4,449	25	Single	Low	14	M	Rent
Business	$859	$3,305	25	Divorced	High	10	F	Rent
New Car	$942	$3,036	25	Married	Low	95	M	Own
Small Appliance	$0	$3,870	25	Married	High	40	M	Own
Furniture	$0	$3,369	25	Married	High	27	M	Own
New Car	$1,613	$0	25	Divorced	High	65	F	Own
Other	$645	$855	25	Divorced	High	4	M	Own
Other	$560	$887	25	Single	Low	23	M	Own
Furniture	$0	$1,230	25	Divorced	High	40	M	Rent
Small Appliance	$265	$947	25	Single	Low	106	M	Own
Used Car	$0	$999	25	Divorced	High	0	M	Own
Furniture	$0	$979	25	Divorced	High	4	F	Own
Small Appliance	$966	$0	25	Divorced	High	1	M	Rent
Furniture	$757	$208	25	Single	High	8	M	Other
Small Appliance	$0	$956	25	Married	High	5	M	Own
Education	$798	$137	25	Divorced	High	57	M	Own
Furniture	$0	$909	25	Single	Low	34	M	Own
Furniture	$0	$836	25	Divorced	Low	36	F	Own
Small Appliance	$0	$836	25	Single	Low	115	M	Own
Small Appliance	$0	$823	25	Single	High	59	M	Rent
New Car	$0	$821	25	Married	High	4	M	Own
Repairs	$0	$807	25	Single	Low	94	M	Own
Small Appliance	$0	$798	25	Married	High	20	M	Own
Used Car	$0	$789	25	Single	High	5	M	Own
Repairs	$0	$772	25	Single	Low	14	M	Own
New Car	$0	$771	25	Single	Low	12	M	Other
New Car	$0	$761	25	Divorced	High	3	F	Rent
Business	$509	$241	25	Single	Low	108	M	Own
Business	$0	$724	25	Divorced	Low	19	F	Own
Business	$522	$194	25	Divorced	High	5	F	Other
Small Appliance	$0	$710	25	Divorced	High	11	F	Own
Education	$705	$0	25	Single	Low	83	M	Rent
Small Appliance	$0	$680	25	Divorced	High	3	F	Rent
Used Car	$646	$0	25	Divorced	High	0	F	Rent
Small Appliance	$0	$552	25	Single	High	21	M	Own
New Car	$332	$214	25	Single	Low	40	M	Rent
New Car	$0	$544	25	Single	High	0	M	Own
Furniture	$0	$538	25	Single	High	75	M	Own
Furniture	$0	$506	25	Single	High	119	M	Own
Business	$0	$500	25	Single	High	58	M	Rent
New Car	$0	$466	25	Single	Low	12	M	Own
New Car	$0	$412	25	Divorced	High	4	F	Rent
Furniture	$192	$199	25	Single	High	1	M	Own
Used Car	$374	$0	25	Single	Low	32	M	Own
Small Appliance	$0	$337	25	Single	High	0	M	Own
Used Car	$0	$276	25	Single	Low	17	M	Own
Used Car	$0	$270	25	Divorced	High	2	F	Own
Used Car	$0	$260	25	Divorced	High	20	F	Own
Business	$172	$0	25	Single	Low	108	M	Own
Furniture	$0	$162	25	Single	High	14	M	Own
Furniture	$0	$146	25	Single	High	6	M	Own
New Car	$0	$113	25	Married	High	14	M	Own
Used Car	$0	$109	25	Single	High	20	M	Own
New Car	$0	$108	25	Divorced	Low	15	F	Own
Business	$0	$104	25	Divorced	High	7	F	Own
Furniture	$0	$0	25	Single	High	56	M	Own
Other	$0	$0	25	Single	High	10	M	Own
New Car	$0	$0	25	Divorced	High	13	F	Own
New Car	$0	$0	25	Divorced	High	0	F	Rent
New Car	$3,880	$0	23	Single	High	15	M	Own
Small Appliance	$0	$17,653	22	Divorced	High	3	M	Own
Furniture	$468	$14,186	22	Divorced	High	5	M	Own
New Car	$0	$11,587	22	Single	Low	93	M	Rent
Education	$8,122	$136	22	Married	High	0	M	Own
New Car	$5,588	$0	22	Single	Low	85	M	Rent
Business	$0	$5,180	22	Single	High	9	M	Own
Business	$339	$2,790	22	Divorced	High	42	F	Own
Business	$898	$177	22	Single	High	7	M	Own
New Car	$0	$886	22	Divorced	High	11	F	Own
New Car	$162	$595	22	Single	Low	57	M	Other
Small Appliance	$0	$717	22	Divorced	High	9	F	Own
Used Car	$0	$701	22	Single	Low	29	M	Own
Furniture	$0	$636	22	Single	High	2	M	Own
New Car	$0	$579	22	Married	High	1	M	Own
Business	$141	$245	22	Divorced	Low	71	F	Own
New Car	$0	$0	22	Divorced	Low	22	F	Rent
Small Appliance	$0	$18,716	19	Divorced	High	2	M	Own
Furniture	$13,496	$650	19	Single	High	23	M	Own
New Car	$8,060	$607	19	Single	Low	20	M	Own
Small Appliance	$0	$6,490	19	Divorced	High	2	F	Rent
Furniture	$0	$5,857	19	Divorced	High	90	F	Own
Small Appliance	$5,133	$698	19	Single	High	7	M	Own
New Car	$3,329	$0	19	Single	High	28	M	Other
Education	$0	$3,281	19	Single	High	13	M	Rent
New Car	$644	$1,571	19	Single	High	33	M	Own
New Car	$939	$496	19	Divorced	High	3	F	Rent
New Car	$0	$1,366	19	Divorced	High	16	F	Rent
Small Appliance	$296	$818	19	Single	High	2	M	Own
Repairs	$271	$759	19	Married	Low	93	M	Own
Furniture	$0	$957	19	Single	High	13	M	Own
Furniture	$0	$948	19	Single	High	4	M	Own
Business	$0	$922	19	Single	Low	33	M	Own
Small Appliance	$0	$914	19	Single	High	0	M	Own
Small Appliance	$483	$415	19	Divorced	High	4	F	Rent
Small Appliance	$0	$897	19	Divorced	High	2	F	Own
Repairs	$0	$897	19	Divorced	High	55	M	Rent
Business	$0	$859	19	Single	Low	24	M	Other
Furniture	$0	$835	19	Single	Low	96	M	Own
Furniture	$0	$815	19	Divorced	Low	2	F	Own
New Car	$0	$806	19	Single	Low	0	M	Own
Furniture	$305	$492	19	Divorced	Low	41	F	Own
Furniture	$457	$318	19	Single	Low	108	M	Own
Large Appliance	$0	$775	19	Married	Low	2	M	Own
Small Appliance	$0	$726	19	Divorced	Low	46	F	Own
Repairs	$0	$718	19	Divorced	High	105	F	Own
New Car	$0	$716	19	Single	Low	2	M	Own
New Car	$0	$693	19	Married	Low	70	M	Rent
Business	$663	$0	19	Divorced	Low	37	F	Rent
New Car	$0	$659	19	Married	Low	5	M	Other
Small Appliance	$0	$643	19	Divorced	Low	0	F	Own
New Car	$461	$140	19	Single	High	63	M	Own
Business	$0	$565	19	Married	High	23	M	Rent
Furniture	$0	$544	19	Divorced	Low	5	F	Own
New Car	$0	$541	19	Single	Low	26	M	Own
Small Appliance	$0	$485	19	Divorced	Low	0	F	Own
New Car	$0	$483	19	Divorced	Low	5	F	Rent
Furniture	$0	$479	19	Single	Low	28	M	Rent
Furniture	$0	$435	19	Married	Low	1	M	Own
New Car	$425	$0	19	Divorced	Low	3	F	Own
Small Appliance	$0	$418	19	Divorced	Low	3	F	Own
New Car	$0	$389	19	Divorced	Low	4	F	Rent
New Car	$0	$343	19	Divorced	High	79	M	Other
Furniture	$0	$340	19	Divorced	Low	1	F	Own
Small Appliance	$0	$325	19	Single	Low	93	M	Own
Furniture	$0	$299	19	Single	High	41	M	Rent
Small Appliance	$242	$0	19	Single	High	14	M	Own
Furniture	$216	$0	19	Single	Low	24	M	Own
Furniture	$0	$169	19	Divorced	Low	81	F	Own
Used Car	$0	$0	19	Single	Low	14	M	Rent
New Car	$0	$660	17	Single	High	53	M	Own
Business	$16,647	$895	16	Single	High	42	M	Own
Small Appliance	$17,366	$0	16	Single	High	87	M	Own
Large Appliance	$0	$15,800	16	Single	High	54	M	Other
Small Appliance	$0	$14,643	16	Married	Low	23	M	Rent
Used Car	$7,885	$6,330	16	Single	Low	99	M	Own
Furniture	$0	$12,632	16	Single	Low	6	M	Other
Used Car	$0	$10,099	16	Single	Low	25	M	Own
New Car	$698	$4,033	16	Single	Low	78	M	Rent
Furniture	$4,256	$0	16	Single	Low	36	M	Other
Education	$0	$3,105	16	Single	Low	19	M	Own
New Car	$585	$2,223	16	Divorced	Low	0	F	Own
New Car	$497	$888	16	Single	High	48	M	Rent
Small Appliance	$946	$0	16	Divorced	Low	19	M	Own
Small Appliance	$893	$0	16	Divorced	Low	2	F	Own
Furniture	$0	$836	16	Divorced	Low	9	F	Own
New Car	$0	$759	16	Single	Low	36	M	Other
New Car	$0	$712	16	Divorced	High	19	F	Own
New Car	$0	$509	16	Divorced	Low	6	M	Own
Small Appliance	$0	$408	16	Single	Low	47	M	Own
Furniture	$0	$347	16	Single	High	20	M	Own
Small Appliance	$0	$296	16	Divorced	Low	7	F	Own
New Car	$0	$648	15	Divorced	Low	10	F	Other
Small Appliance	$0	$3,529	14	Divorced	Low	0	F	Other
Business	$0	$533	14	Single	High	17	M	Other
Small Appliance	$12,974	$19,568	13	Single	High	37	M	Other
New Car	$10,417	$19,811	13	Divorced	Low	4	F	Own
New Car	$18,408	$212	13	Single	Low	26	M	Rent
Business	$12,760	$4,873	13	Single	Low	66	M	Own
Small Appliance	$0	$17,124	13	Single	Low	75	M	Own
Furniture	$0	$13,970	13	Divorced	Low	9	F	Rent
Small Appliance	$317	$10,980	13	Single	High	18	M	Own
Business	$9,783	$885	13	Single	High	52	M	Own
New Car	$0	$9,125	13	Divorced	High	31	F	Rent
Furniture	$352	$7,525	13	Married	Low	118	M	Own
Small Appliance	$6,851	$901	13	Divorced	High	36	M	Own
Small Appliance	$5,960	$129	13	Single	Low	3	M	Own
Furniture	$101	$3,871	13	Single	Low	107	M	Other
Business	$758	$2,665	13	Divorced	Low	24	F	Own
Small Appliance	$0	$3,273	13	Single	Low	114	M	Own
Repairs	$3,111	$0	13	Single	High	42	M	Own
New Car	$193	$2,684	13	Single	High	59	M	Own
Small Appliance	$2,846	$0	13	Married	Low	7	M	Own
New Car	$2,641	$0	13	Single	High	46	M	Other
Furniture	$983	$950	13	Single	Low	2	M	Rent
New Car	$708	$683	13	Single	High	22	M	Own
Large Appliance	$0	$1,238	13	Single	Low	17	M	Own
Small Appliance	$0	$1,218	13	Single	Low	17	M	Own
Small Appliance	$303	$899	13	Single	High	92	M	Rent
Small Appliance	$895	$243	13	Single	Low	91	M	Own
New Car	$166	$922	13	Divorced	High	25	F	Rent
Furniture	$638	$347	13	Divorced	High	103	F	Own
Small Appliance	$0	$970	13	Single	Low	116	M	Other
Furniture	$0	$945	13	Divorced	Low	0	F	Rent
Furniture	$0	$941	13	Single	Low	28	M	Rent
New Car	$538	$344	13	Single	High	20	M	Own
Small Appliance	$0	$861	13	Divorced	Low	9	F	Own
Used Car	$819	$0	13	Single	Low	54	M	Own
Furniture	$0	$803	13	Single	Low	3	M	Own
Furniture	$0	$800	13	Single	Low	8	M	Own
New Car	$315	$466	13	Divorced	High	51	F	Own
Small Appliance	$0	$763	13	Divorced	Low	5	F	Own
New Car	$0	$750	13	Single	Low	4	M	Own
Furniture	$0	$746	13	Single	Low	32	M	Other
Small Appliance	$0	$739	13	Single	High	33	M	Other
Furniture	$0	$736	13	Married	Low	5	M	Own
New Car	$0	$713	13	Divorced	Low	14	M	Own
Furniture	$161	$524	13	Divorced	High	21	F	Rent
Retraining	$644	$0	13	Divorced	Low	1	F	Own
Furniture	$642	$0	13	Single	Low	6	M	Other
New Car	$0	$637	13	Single	High	90	M	Own
New Car	$396	$228	13	Divorced	High	35	F	Rent
Retraining	$0	$603	13	Single	Low	89	M	Own
Small Appliance	$0	$596	13	Divorced	Low	27	F	Other
Small Appliance	$586	$0	13	Single	Low	77	M	Own
Small Appliance	$0	$552	13	Divorced	High	20	F	Own
New Car	$0	$547	13	Divorced	Low	23	F	Other
New Car	$0	$531	13	Divorced	Low	2	F	Own
New Car	$0	$508	13	Divorced	High	21	F	Own
Small Appliance	$0	$503	13	Single	Low	4	M	Own
Furniture	$0	$493	13	Single	High	53	M	Own
New Car	$0	$490	13	Divorced	High	16	F	Own
New Car	$0	$470	13	Single	Low	11	M	Own
Furniture	$0	$461	13	Divorced	High	23	F	Own
New Car	$0	$457	13	Single	Low	24	M	Own
Small Appliance	$0	$425	13	Divorced	Low	0	F	Rent
Small Appliance	$0	$407	13	Single	Low	60	M	Own
Small Appliance	$0	$364	13	Single	High	114	M	Rent
Furniture	$0	$322	13	Single	High	60	M	Own
Business	$0	$265	13	Single	Low	85	M	Own
Education	$0	$238	13	Single	High	25	M	Rent
New Car	$0	$229	13	Single	Low	6	M	Own
Small Appliance	$0	$208	13	Divorced	Low	10	M	Own
New Car	$0	$207	13	Single	Low	79	M	Other
Used Car	$0	$178	13	Divorced	Low	4	F	Own
Education	$0	$164	13	Single	Low	9	M	Own
Used Car	$0	$160	13	Divorced	Low	1	F	Rent
Small Appliance	$156	$0	13	Single	Low	3	M	Other
New Car	$0	$128	13	Divorced	High	20	F	Own
Education	$0	$127	13	Single	Low	0	M	Own
Furniture	$0	$0	13	Divorced	High	14	M	Other
Furniture	$150	$6,520	12	Single	Low	2	M	Rent
Small Appliance	$0	$1,851	12	Single	High	111	M	Own
New Car	$0	$904	12	Single	High	85	M	Own
New Car	$0	$486	12	Single	High	49	M	Own
New Car	$19,766	$2,141	11	Married	Low	17	M	Own
Small Appliance	$16,630	$0	11	Single	Low	65	M	Own
New Car	$0	$10,723	11	Single	High	103	M	Other
Furniture	$8,636	$214	11	Single	Low	22	M	Other
New Car	$0	$3,305	11	Divorced	Low	9	M	Own
Furniture	$2,827	$0	11	Single	Low	7	M	Own
Small Appliance	$0	$959	11	Single	Low	12	M	Other
New Car	$0	$857	11	Single	High	101	M	Own
Furniture	$113	$692	11	Single	Low	102	M	Other
New Car	$580	$0	11	Divorced	Low	31	F	Own
Furniture	$0	$463	11	Divorced	Low	1	F	Own
Used Car	$0	$0	11	Single	Low	92	M	Own
Small Appliance	$765	$10,406	10	Divorced	Low	8	M	Rent
New Car	$478	$4,071	10	Single	Low	41	M	Rent
Furniture	$0	$4,486	10	Single	High	109	M	Other
Repairs	$0	$2,688	10	Single	High	17	M	Own
Education	$977	$463	10	Single	Low	69	M	Other
Small Appliance	$565	$863	10	Married	Low	3	M	Own
Furniture	$759	$596	10	Single	Low	45	M	Own
Education	$1,257	$0	10	Single	Low	74	M	Own
Small Appliance	$256	$954	10	Single	Low	30	M	Own
Small Appliance	$231	$702	10	Single	High	24	M	Own
Education	$522	$385	10	Single	Low	6	M	Own
Business	$322	$578	10	Divorced	Low	9	F	Own
Small Appliance	$0	$762	10	Divorced	High	28	F	Own
New Car	$0	$374	10	Single	High	28	M	Own
New Car	$0	$369	10	Single	Low	11	M	Own
Small Appliance	$0	$302	10	Single	High	13	M	Other
Small Appliance	$940	$715	9	Divorced	Low	0	M	Own
Furniture	$828	$391	9	Single	High	19	M	Own
Business	$929	$124	9	Single	Low	9	M	Own
Small Appliance	$211	$822	8	Single	Low	0	M	Rent
New Car	$8,176	$12,230	7	Single	Low	0	M	Other
Used Car	$0	$13,428	7	Single	Low	46	M	Rent
Education	$287	$12,348	7	Divorced	High	46	F	Own
Small Appliance	$0	$11,838	7	Married	High	42	M	Own
New Car	$305	$4,553	7	Divorced	Low	5	F	Own
Furniture	$4,089	$0	7	Single	Low	32	M	Own
Business	$0	$3,285	7	Divorced	High	13	F	Own
Small Appliance	$829	$583	7	Single	High	45	M	Own
Small Appliance	$887	$519	7	Single	High	15	M	Own
Repairs	$273	$904	7	Single	Low	37	M	Other
Small Appliance	$734	$348	7	Divorced	High	14	M	Other
Furniture	$0	$991	7	Single	High	45	M	Own
Furniture	$513	$442	7	Single	Low	0	M	Rent
New Car	$0	$912	7	Single	High	21	M	Own
Small Appliance	$0	$707	7	Single	High	22	M	Rent
Small Appliance	$0	$576	7	Single	High	40	M	Own
Small Appliance	$497	$0	7	Divorced	Low	36	F	Own
Education	$0	$471	7	Divorced	High	81	F	Rent
Education	$0	$403	7	Single	High	119	M	Own
Furniture	$0	$369	7	Single	Low	9	M	Rent
New Car	$0	$272	7	Single	High	83	M	Rent
New Car	$0	$192	7	Divorced	High	75	F	Own
Furniture	$0	$142	7	Single	Low	29	M	Other
Small Appliance	$0	$138	7	Single	High	32	M	Own
New Car	$0	$127	7	Single	High	62	M	Own
New Car	$0	$102	7	Single	High	73	M	Other
Business	$0	$406	6	Single	High	17	M	Own
Small Appliance	$0	$490	5	Divorced	High	83	F	Own
Small Appliance	$0	$364	5	Single	Low	17	M	Own
Furniture	$0	$180	5	Married	High	15	M	Own

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Entrepreneurship and innovation The keys to global economic recovery invention Executive summary At a time when entire economies and industries are reeling from the nancial crisis, business leaders...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Describe the types of cybercrimes facing organizations and critical infrastructures, explain the motives of cybercriminals, and evaluate the financial Explain both low-tech and high-tech methods...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

IN REGARDS TO THE TWO CASES PROVIDED BELOW, For this assignment, please draft on the following topic: UNAUTHORIZED PRACTICE OF LAW ( UPL) and the practical applications of UPL in the real world The...

1 Exercise 3: Lift and Airfoils The first part of this week's assignment is to choose and research a reciprocating engine powered (i.e. propeller type) aircraft. You will further use your selected...

cook was publicly criticized by the German data protect commissioner and the consumer protection minister. Chapter 20 . Corporate Social Responsibility 591 'Hamburg state data protection supervisor...

Kensignton Ltd. is a CCPC with a December 31 taxation year end. The company was incorporated ten years ago. Due to increased competition and an inability to adapt to the rapidly changing...

Propose a mechanism for each of the following reactions: a. b. c. d. Br -, CH _CH3 0 H20 ( HOCH,CH,CH2 CHCH SCH2CH CH,CH-SH + --> CHCH2CCH3 N 2. HCI, H20

( b ) In what amount, if any, is The White Star Line liable to pay the plaintiff for the loss of Hans Peder Jensen's future wages for the remainder of his work life? A = Amount of $ 1 0 0 0 PER MONTH

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....