Use my given data sample from the bank to determine if those who are home owners tend to have more years of credit history. Use an alpha of 5%. (to sort the data to more easily use the testing functions.) Also use the call formula in excel to show how you arrived to the answers. average years of credit history for non homeowners. average years of credit history for homeowners P value of comparison Do home owners have more years of credit history? Credit Approval Decisions Homeowner Y Y Y N N Y N N Y Y Y Y Y N Y Y redit Scor of Credit blving Baldving Utiliz Decision 20 $ 11,320 25% 9 $ 7,200 70% 55% 11 15 65% 12 75% 22 12% 7 20% 62% 50% 35% 725 573 677 625 527 795 733 620 591 660 700 500 565 620 774 802 5 17 24 19 16 66330 13 10 $ 20,000 $ 12,800 $ 5,700 $ 9,000 $ 35,200 $ 22,800 $ 16,500 $ 9,200 $ 22,000 $ 12,500 $ 7,700 $ 37,400 18% 83% 70% 87% Approve Deny Approve Deny Deny Approve Approve Deny Deny Approve Approve Deny Deny Deny Approve Approve 7% $ 6,100 $ 10,500 5% (it would be wise to test if variances are different in order to know what test to use here.)