Case #1: (50 pts.) Complete the required data analysis for the following variables: V4 (Income) V6 (Credit Card Debt) V9 (Interest + Penalties and V10 (Credit Score) . Your analysis must address the following tasks (10 pts. each): 1. Complete a Descriptive Statistics analysis for the variables identified above. Include the following for each variable: the mean median sample SD Discuss if you see variations in the dispersion of each variable. 2. Calculate the Confidence Interval for three Confidence Levels (90%, 95% and 99%). You must identify all three Confidence intervals (and the calculations you used to determine each of the Intervals). 3. Discuss what you observed as the Confidence Level increased from 90% up to 99%? What causes this result to occur? Explain. 4. How would you describe the meaning of the Ci to your client? What Confidence Level would you recommend to your client and why? 5. Finally, do you think the Ci is a better estimate than the mean? Defend your answer. Gen V2_Gen 1 1 2 2 2 1 2 2 1 HH Age Total CC # of # of Interest + Credit ST Debt Debt C Cards Late Pay Penalties Score V3. Age V4 Inc V5 ST Debt V6 CC Dett V W CCS VW UP V9_Int+ Pen V10 CS 67 $92,489 $9,086 $6,935 2 0 $88 820 32 $33,150 $22,376 $18,955 4 7 $6,193 506 59 $54,782 $26,258 $6,094 3 0 $535 760 66 $71,960 $46,753 $19,642 3 0 $831 687 32 $48,900 $29,398 $22,307 5 3 $4,902 565 27 $37,750 $19,044 $9.987 3 4 $4,574 593 63 $51,387 $7,454 $2,275 2 1 $590 846 35 $44,250 $20,670 $17,443 3 2 $2,606 653 28 $63,761 $34,898 $12,026 3 2 $3,488 638 66 $60,420 $36,625 $11,870 3 2 $414 667 59 $70,264 $11,323 $10,230 3 2 $841 789 48 $51,304 $19,465 $10,917 3 3 $2,165 626 34 $42,169 $27.907 $19,118 4 3 $1,698 615 71 $44.950 $7,747 $3.910 2 2 $164 755 38 $60.264 $22,323 $18,230 5 4 $2.841 597 55 $47.300 $19,805 $5,529 2 2 $1,927 739 55 $101.210 $67 622 $31,794 6 6 $6,566 447 58 $72.942 $22.435 $4.746 1 1 $854 775 42 $52.750 $15,748 $14.860 3 4 $1.988 576 25 $34.750 $18.178 $10.637 3 5 $4.985 50 $52.750 $9.748 $3.536 3 1 $982 789 35 $46,860 $24.343 $17.888 5 5 $3.956 655 2 1 1 2 1 1 1 1 2 1 607 1 2 2 UNU C G K H N 5 5 4 2 1 3 4 2 2 2 3 1 2 1 N 2. 3 2 0 6 1 1 2 2 1 1 1 1 2 2 2 D F 33 $48,890 $28,247 $22,385 27 $53,000 $41,643 $14,467 34 $66,192 $24,280 $18,743 56 $49,948 $17,193 $6,038 26 $38,115 $18,098 $3,200 25 $31,840 $13,383 $7,247 31 $38,325 $31,138 $18,089 45 $48,100 $27,886 $14,089 64 $86,232 $16,161 $8,587 25 $39,500 $27.600 $24,649 55 $71,598 $17,449 $14,695 30 $62,806 $17,505 $11,354 52 $76,250 $55,863 $25,164 58 $43,615 $6,978 $5,849 53 $54,000 $8,640 $5,468 20 $52,338 $40,227 $29,165 58 $103,150 $40,185 $21,043 75 $33,791 $7,706 $7,176 29 $60,124 $28,125 $15.875 66 $30,790 $3,326 $1,726 39 $48,700 $33,066 $28,649 27 $32,806 $8,544 $6,905 57 $66,287 $32,606 $19,691 34 $43,850 $21,519 $18,821 27 $51,830 $22.733 $20,990 21 $32,500 $18,261 $14,236 36 $59.900 $39,374 $23,551 2 1 2 6 3 2 4 3 2 4 2 3 $4,260 $2,264 $1,820 $1,386 $948 $817 $2,732 $1,686 $185 $5,671 $1,197 $969 $1,990 $153 $351 $6,260 $5,375 $307 $2,958 $247 $11,805 $326 $1,149 $3,391 $856 $4,334 $2.371 0 2 2 1 6 3 0 3 1 9 590 682 602 748 768 760 603 689 835 558 725 656 588 758 773 420 560 703 626 790 430 701 635 605 666 577 550 4 3 2 5 1 1 2 1 6 2 2 3 2 4 3 2 1 1 2 4 0 6 2 1 1 mm G 20 B C 4 5 2 2. 3 .6 4 57 58 59 2 2 60 61 2 2 2 2 62 63 1 2 3 3 4 3 2 3 2 1 1 64 65 66 D F 29 $47,900 $24,345 $16,977 20 $28,850 $16,239 $10,246 21 $30,750 $18,044 $14,187 56 $57,225 $38,450 $29,301 27 $34,450 $14,045 $8,565 51 $49,950 $28,433 $11,493 50 $54,398 $11,813 $11,813 47 $85,400 $49,162 $25,164 22 $37,600 $12,961 $10,095 30 $64,750 $38,044 $18,987 36 $63,995 $48,934 $15,449 74 $34,398 $15,813 $11.981 59 $54,333 $15,977 $4,607 70 $35.400 $5,360 $2.373 23 $24,800 $14,961 $6,095 59 $54,300 $8,910 $4,304 51 $61,850 $22 472 58,333 63 $58,574 $17.212 $8,623 45 $48,200 $25.129 $8.974 75 $33,500 $22,648 $18.960 68 $35.975 $8.449 $3.449 59 $102,500 S43,985 $29,553 49 563.730 $29.025 $23.618 30 $44.500 $39.700 $29.876 65 $66,690 $14 284 $8.341 50 $55.900 $46,540 $31044 67 $39.930 $18.753 $9.853 2 2 3 $3,563 6 $5,462 4 $3,174 6 $9,468 0 $837 1 $908 3 $1,175 7 $10,759 2 $2.987 4 $3,074 2 $789 1 $1,853 1 $467 1 $191 $2,487 1 $186 3 $1,453 0 $912 0 $675 $1,245 0 $249 5 $2.188 2 $1,877 7 58.245 1 $116 6 $8.189 $907 621 563 593 532 662 700 698 501 570 510 741 697 808 809 680 782 729 760 695 608 840 590 612 510 802 491 691 67 2 68 69 4 2 2 2 1 1 3 1 3 4 70 71 72 73 74 75 76 77 78 79 80 81 1 2 2 1 1 2 2 1 1 1 4 5 5 1 4 N- G H E 3 2 0 2 2 2 3 1 2 1 1 1 1 4 4 1 0 1 2 4 1 1 2 2 1 1 1 1 2 2 1 2 1 1 2 1 2 2 2 2 2 2 2 1 D E F 22 $28,650 $8,744 $2,665 66 $35,035 $5,921 $2,003 51 $63,800 $10,782 $5,234 31 $63,750 $29,465 $21,792 69 $34,250 $12,458 $10,235 70 $33,740 $8,569 $2,817 60 $60,261 $10,594 $8,452 49 $52,750 $36,100 $19,441 57 $59,767 $49,860 $34,850 52 $46,452 $25,015 $14,141 62 $50,325 $9,052 $4,070 52 $52,910 $27,175 $16,050 + 55 $58,251 $24.464 $15,012 70 $31,820 $16,280 $8,692 61 $49,900 $6,491 $5,521 42 $61,185 $28,668 $18,907 61 $54,400 $9.910 $5,304 54 $54,750 $8,760 $3,392 60 $87.353 $59,283 $25,800 67 $72.285 $8.951 $7.738 25 $34,200 $23,602 $15.236 62 $81,625 $30.217 $24.107 52 $82,139 $45,928 $21,374 48 $57,600 $37.520 $29,089 54 S105.750 $32.788 $13,068 45 $48.900 $10.129 $6,693 62 $52.338 $24.227 $18.165 4 3 3 2 1 3 2 2 3 3 1 3 4 2 5 3 5 1 4 3 1 2 0 1 1 4 2 2 2 2 5 5 1 3 $215 $564 $800 $933 $3,377 $170 $923 $1,210 $3,432 $411 $964 $2,500 $269 $810 $877 $863 $186 $433 $931 $933 $6,334 $2.999 $4,434 $5,420 $4,506 $477 $4.260 769 764 725 661 640 782 786 634 520 732 761 620 704 658 788 754 762 776 580 730 561 642 555 592 630 703 603 4 2 2 4 AR X fix M 16 K G H B 2 3 3 2 2 1 2 1 3 1 1 5 1 1 2 2 1 2 1 1 1 2 2 0 1 12 13 14 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 D E F 27 $61,650 $28,349 $14,941 51 561,775 $30,046 $18,274 51 $88,588 $32,238 $28,017 43 $45,275 $7,244 $2,885 23 $33.175 $13,154 $12,197 31 561,398 $15,813 $9,111 67 $44.748 $28,576 513,402 32 $38,500 $23,900 $12,750 52 $57,000 $9.920 24.203 34 $60.513 $9.09 $7,772 26 $42,950 $38,376 $28.955 24 $37,850 $19,805 $11,275 55 $56,499 $38.917 $28.945 49 S54,740 $12.948 $2,160 40 $44,800 $33.654 $27.957 43 $45,278 $11,644 $8,877 69 $36.750 $9.185 $1.991 45 $41.562 $11.419 $4.008 46 $62.400 $35 462 $23.598 60 $48,325 $7,674 $1.573 67 $42.806 $8.726 $3 239 39 S62.750 $28.902 $17.077 44 $41,159 $10.110 57.600 69 534 803 $7 274 $2.451 44 $59,400 $29.039 $3.527 70 $33.175 $9,814 $3.049 45 $49.100 $10.129 58,849 2 4 2 2 3 2 3 5 4 6 3 6 2 2 3 4 1 4 1 2 1 3 6 3 8 1 4 $3,169 $947 $968 $419 $6,433 $296 $1,937 $1,848 $339 $701 $5.993 $1,057 $8.973 $788 $6,439 $158 $806 $1,863 $3.543 $419 $421 $513 $952 $550 5569 $279 5589 0 672 702 592 764 544 793 695 541 730 783 492 631 533 789 552 768 777 730 649 774 830 654 651 810 784 736 690 1 1 2 1 2 1 2 2 2 2 2 2 1 1 0 1 3 2 2 1 0 3 1 1 3 1 0 2 3 1 0 1 5 4 4 1 1 1 540 659 595 753 2 4 4 2 1 2 3 2 686 0 2 1 2 2 2 3 5 1 1 3 1 2. 4 2 1 1 2 2 4 1 70 $37,693 $33,844 $26,685 66 $46,950 $26,747 $22,339 66 563,550 $31,406 $15.760 35 $48,950 $32,345 $19,977 58 $56,300 $17,990 $13,655 66 $29,480 $11,306 $10,761 73 $35,750 $18.465 $8,592 22 $27,690 $23,690 $18,650 28 $41,850 $8,383 $3.764 55 $57,035 514,153 $9.885 57 $54,633 $5,977 $2,607 66 $72,650 $19,281 $7,316 35 $63,833 $28,753 $18,390 39 $44,745 $5,400 $1,974 24 $38,750 $28,385 $26,776 68 $64,750 $28,900 $7.155 31 $64.750 $39,385 $26.776 69 $43,755 $8.978 $1.412 50 $53,670 $9.997 $8,892 36 $57,000 $28,455 $16,198 36 $63.759 $19,482 $14,570 41 $49,500 $43,700 $33,776 72 $37 400 $4.099 $1.933 27 $33.600 $23,602 $10,236 49 $58.970 $32.345 $15.977 74 $31.850 $8.383 $3.764 $1,167 $519 $4,563 $781 $541 $1,933 $6,406 $469 $301 $297 $447 $1,451 $279 $8,314 $378 $3,314 $155 $321 $820 $663 $11,033 $112 $4,334 $10,563 $469 1 1 2 6 1 1 2 1 2 6 644 455 726 815 807 810 642 773 517 805 547 792 675 735 718 482 793 610 490 726 4 0 1 2 1 1 1 1 2 2 3 3 6 2 5 2 6 0 1 1 4 5 *6 17 78 79 80 NN 4 2 6 1 1 1 Case #1: (50 pts.) Complete the required data analysis for the following variables: V4 (Income) V6 (Credit Card Debt) V9 (Interest + Penalties and V10 (Credit Score) . Your analysis must address the following tasks (10 pts. each): 1. Complete a Descriptive Statistics analysis for the variables identified above. Include the following for each variable: the mean median sample SD Discuss if you see variations in the dispersion of each variable. 2. Calculate the Confidence Interval for three Confidence Levels (90%, 95% and 99%). You must identify all three Confidence intervals (and the calculations you used to determine each of the Intervals). 3. Discuss what you observed as the Confidence Level increased from 90% up to 99%? What causes this result to occur? Explain. 4. How would you describe the meaning of the Ci to your client? What Confidence Level would you recommend to your client and why? 5. Finally, do you think the Ci is a better estimate than the mean? Defend your answer. Gen V2_Gen 1 1 2 2 2 1 2 2 1 HH Age Total CC # of # of Interest + Credit ST Debt Debt C Cards Late Pay Penalties Score V3. Age V4 Inc V5 ST Debt V6 CC Dett V W CCS VW UP V9_Int+ Pen V10 CS 67 $92,489 $9,086 $6,935 2 0 $88 820 32 $33,150 $22,376 $18,955 4 7 $6,193 506 59 $54,782 $26,258 $6,094 3 0 $535 760 66 $71,960 $46,753 $19,642 3 0 $831 687 32 $48,900 $29,398 $22,307 5 3 $4,902 565 27 $37,750 $19,044 $9.987 3 4 $4,574 593 63 $51,387 $7,454 $2,275 2 1 $590 846 35 $44,250 $20,670 $17,443 3 2 $2,606 653 28 $63,761 $34,898 $12,026 3 2 $3,488 638 66 $60,420 $36,625 $11,870 3 2 $414 667 59 $70,264 $11,323 $10,230 3 2 $841 789 48 $51,304 $19,465 $10,917 3 3 $2,165 626 34 $42,169 $27.907 $19,118 4 3 $1,698 615 71 $44.950 $7,747 $3.910 2 2 $164 755 38 $60.264 $22,323 $18,230 5 4 $2.841 597 55 $47.300 $19,805 $5,529 2 2 $1,927 739 55 $101.210 $67 622 $31,794 6 6 $6,566 447 58 $72.942 $22.435 $4.746 1 1 $854 775 42 $52.750 $15,748 $14.860 3 4 $1.988 576 25 $34.750 $18.178 $10.637 3 5 $4.985 50 $52.750 $9.748 $3.536 3 1 $982 789 35 $46,860 $24.343 $17.888 5 5 $3.956 655 2 1 1 2 1 1 1 1 2 1 607 1 2 2 UNU C G K H N 5 5 4 2 1 3 4 2 2 2 3 1 2 1 N 2. 3 2 0 6 1 1 2 2 1 1 1 1 2 2 2 D F 33 $48,890 $28,247 $22,385 27 $53,000 $41,643 $14,467 34 $66,192 $24,280 $18,743 56 $49,948 $17,193 $6,038 26 $38,115 $18,098 $3,200 25 $31,840 $13,383 $7,247 31 $38,325 $31,138 $18,089 45 $48,100 $27,886 $14,089 64 $86,232 $16,161 $8,587 25 $39,500 $27.600 $24,649 55 $71,598 $17,449 $14,695 30 $62,806 $17,505 $11,354 52 $76,250 $55,863 $25,164 58 $43,615 $6,978 $5,849 53 $54,000 $8,640 $5,468 20 $52,338 $40,227 $29,165 58 $103,150 $40,185 $21,043 75 $33,791 $7,706 $7,176 29 $60,124 $28,125 $15.875 66 $30,790 $3,326 $1,726 39 $48,700 $33,066 $28,649 27 $32,806 $8,544 $6,905 57 $66,287 $32,606 $19,691 34 $43,850 $21,519 $18,821 27 $51,830 $22.733 $20,990 21 $32,500 $18,261 $14,236 36 $59.900 $39,374 $23,551 2 1 2 6 3 2 4 3 2 4 2 3 $4,260 $2,264 $1,820 $1,386 $948 $817 $2,732 $1,686 $185 $5,671 $1,197 $969 $1,990 $153 $351 $6,260 $5,375 $307 $2,958 $247 $11,805 $326 $1,149 $3,391 $856 $4,334 $2.371 0 2 2 1 6 3 0 3 1 9 590 682 602 748 768 760 603 689 835 558 725 656 588 758 773 420 560 703 626 790 430 701 635 605 666 577 550 4 3 2 5 1 1 2 1 6 2 2 3 2 4 3 2 1 1 2 4 0 6 2 1 1 mm G 20 B C 4 5 2 2. 3 .6 4 57 58 59 2 2 60 61 2 2 2 2 62 63 1 2 3 3 4 3 2 3 2 1 1 64 65 66 D F 29 $47,900 $24,345 $16,977 20 $28,850 $16,239 $10,246 21 $30,750 $18,044 $14,187 56 $57,225 $38,450 $29,301 27 $34,450 $14,045 $8,565 51 $49,950 $28,433 $11,493 50 $54,398 $11,813 $11,813 47 $85,400 $49,162 $25,164 22 $37,600 $12,961 $10,095 30 $64,750 $38,044 $18,987 36 $63,995 $48,934 $15,449 74 $34,398 $15,813 $11.981 59 $54,333 $15,977 $4,607 70 $35.400 $5,360 $2.373 23 $24,800 $14,961 $6,095 59 $54,300 $8,910 $4,304 51 $61,850 $22 472 58,333 63 $58,574 $17.212 $8,623 45 $48,200 $25.129 $8.974 75 $33,500 $22,648 $18.960 68 $35.975 $8.449 $3.449 59 $102,500 S43,985 $29,553 49 563.730 $29.025 $23.618 30 $44.500 $39.700 $29.876 65 $66,690 $14 284 $8.341 50 $55.900 $46,540 $31044 67 $39.930 $18.753 $9.853 2 2 3 $3,563 6 $5,462 4 $3,174 6 $9,468 0 $837 1 $908 3 $1,175 7 $10,759 2 $2.987 4 $3,074 2 $789 1 $1,853 1 $467 1 $191 $2,487 1 $186 3 $1,453 0 $912 0 $675 $1,245 0 $249 5 $2.188 2 $1,877 7 58.245 1 $116 6 $8.189 $907 621 563 593 532 662 700 698 501 570 510 741 697 808 809 680 782 729 760 695 608 840 590 612 510 802 491 691 67 2 68 69 4 2 2 2 1 1 3 1 3 4 70 71 72 73 74 75 76 77 78 79 80 81 1 2 2 1 1 2 2 1 1 1 4 5 5 1 4 N- G H E 3 2 0 2 2 2 3 1 2 1 1 1 1 4 4 1 0 1 2 4 1 1 2 2 1 1 1 1 2 2 1 2 1 1 2 1 2 2 2 2 2 2 2 1 D E F 22 $28,650 $8,744 $2,665 66 $35,035 $5,921 $2,003 51 $63,800 $10,782 $5,234 31 $63,750 $29,465 $21,792 69 $34,250 $12,458 $10,235 70 $33,740 $8,569 $2,817 60 $60,261 $10,594 $8,452 49 $52,750 $36,100 $19,441 57 $59,767 $49,860 $34,850 52 $46,452 $25,015 $14,141 62 $50,325 $9,052 $4,070 52 $52,910 $27,175 $16,050 + 55 $58,251 $24.464 $15,012 70 $31,820 $16,280 $8,692 61 $49,900 $6,491 $5,521 42 $61,185 $28,668 $18,907 61 $54,400 $9.910 $5,304 54 $54,750 $8,760 $3,392 60 $87.353 $59,283 $25,800 67 $72.285 $8.951 $7.738 25 $34,200 $23,602 $15.236 62 $81,625 $30.217 $24.107 52 $82,139 $45,928 $21,374 48 $57,600 $37.520 $29,089 54 S105.750 $32.788 $13,068 45 $48.900 $10.129 $6,693 62 $52.338 $24.227 $18.165 4 3 3 2 1 3 2 2 3 3 1 3 4 2 5 3 5 1 4 3 1 2 0 1 1 4 2 2 2 2 5 5 1 3 $215 $564 $800 $933 $3,377 $170 $923 $1,210 $3,432 $411 $964 $2,500 $269 $810 $877 $863 $186 $433 $931 $933 $6,334 $2.999 $4,434 $5,420 $4,506 $477 $4.260 769 764 725 661 640 782 786 634 520 732 761 620 704 658 788 754 762 776 580 730 561 642 555 592 630 703 603 4 2 2 4 AR X fix M 16 K G H B 2 3 3 2 2 1 2 1 3 1 1 5 1 1 2 2 1 2 1 1 1 2 2 0 1 12 13 14 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 D E F 27 $61,650 $28,349 $14,941 51 561,775 $30,046 $18,274 51 $88,588 $32,238 $28,017 43 $45,275 $7,244 $2,885 23 $33.175 $13,154 $12,197 31 561,398 $15,813 $9,111 67 $44.748 $28,576 513,402 32 $38,500 $23,900 $12,750 52 $57,000 $9.920 24.203 34 $60.513 $9.09 $7,772 26 $42,950 $38,376 $28.955 24 $37,850 $19,805 $11,275 55 $56,499 $38.917 $28.945 49 S54,740 $12.948 $2,160 40 $44,800 $33.654 $27.957 43 $45,278 $11,644 $8,877 69 $36.750 $9.185 $1.991 45 $41.562 $11.419 $4.008 46 $62.400 $35 462 $23.598 60 $48,325 $7,674 $1.573 67 $42.806 $8.726 $3 239 39 S62.750 $28.902 $17.077 44 $41,159 $10.110 57.600 69 534 803 $7 274 $2.451 44 $59,400 $29.039 $3.527 70 $33.175 $9,814 $3.049 45 $49.100 $10.129 58,849 2 4 2 2 3 2 3 5 4 6 3 6 2 2 3 4 1 4 1 2 1 3 6 3 8 1 4 $3,169 $947 $968 $419 $6,433 $296 $1,937 $1,848 $339 $701 $5.993 $1,057 $8.973 $788 $6,439 $158 $806 $1,863 $3.543 $419 $421 $513 $952 $550 5569 $279 5589 0 672 702 592 764 544 793 695 541 730 783 492 631 533 789 552 768 777 730 649 774 830 654 651 810 784 736 690 1 1 2 1 2 1 2 2 2 2 2 2 1 1 0 1 3 2 2 1 0 3 1 1 3 1 0 2 3 1 0 1 5 4 4 1 1 1 540 659 595 753 2 4 4 2 1 2 3 2 686 0 2 1 2 2 2 3 5 1 1 3 1 2. 4 2 1 1 2 2 4 1 70 $37,693 $33,844 $26,685 66 $46,950 $26,747 $22,339 66 563,550 $31,406 $15.760 35 $48,950 $32,345 $19,977 58 $56,300 $17,990 $13,655 66 $29,480 $11,306 $10,761 73 $35,750 $18.465 $8,592 22 $27,690 $23,690 $18,650 28 $41,850 $8,383 $3.764 55 $57,035 514,153 $9.885 57 $54,633 $5,977 $2,607 66 $72,650 $19,281 $7,316 35 $63,833 $28,753 $18,390 39 $44,745 $5,400 $1,974 24 $38,750 $28,385 $26,776 68 $64,750 $28,900 $7.155 31 $64.750 $39,385 $26.776 69 $43,755 $8.978 $1.412 50 $53,670 $9.997 $8,892 36 $57,000 $28,455 $16,198 36 $63.759 $19,482 $14,570 41 $49,500 $43,700 $33,776 72 $37 400 $4.099 $1.933 27 $33.600 $23,602 $10,236 49 $58.970 $32.345 $15.977 74 $31.850 $8.383 $3.764 $1,167 $519 $4,563 $781 $541 $1,933 $6,406 $469 $301 $297 $447 $1,451 $279 $8,314 $378 $3,314 $155 $321 $820 $663 $11,033 $112 $4,334 $10,563 $469 1 1 2 6 1 1 2 1 2 6 644 455 726 815 807 810 642 773 517 805 547 792 675 735 718 482 793 610 490 726 4 0 1 2 1 1 1 1 2 2 3 3 6 2 5 2 6 0 1 1 4 5 *6 17 78 79 80 NN 4 2 6 1 1 1