CHALLENGE . . . I ACTIVITY I 7.14: Excel: Hypothe3is test for a population proportion. Click this link to download the spreadsheet for use in this activity. [-0504 200' 655.c2x32qv" Jump to level 1 A bank has a policy that the proportion of loans made to people with more than $50,000 in debt should not be more than 0.15. The bank checks a randomly chosen sample of 75 customer's debt amounts to determine if the proportion is more than 0.15 at a signicance level of 0.05. Use Sheet 3 of the Excel le to calculate 15, the zscore, and the p-value. 13 = IEx:1.234 : z = p = Since the pvalue is t-han the signicance level 0.05, the null hypothesis . evidence exists that the proportion of loans to people with more than $50,000 in debt is more than 0.15. A B 4.014612 2.639621 W N 3.450417 4 3.358356 UT 2.84696 6 2.780427 3.300524 8 3.553771 9 3.260947 10 3.840587 11 2.860518 12 3.006942 13 3.49015 14 3.294381 15 3.072383 16 3.187383 17 2.820845 18 3.546399 19 3.544942 20 2.748968 21 2.652408 22 4.197403 23 3.796142 24 2.955329 25 3.778145 26 3.168329 27 3.270481 28 3.61453 29 2.927849 30 2.850947 31 3.667464 32 3.365819 33 3.74556 34 2.468051 35 2.555468 36 3.992926 37 2.74653 38 3.888629 39 3.1468 40 3.717876 41 2.963146 42 4.062454 43 2.957488 44 3.088457 45 3.220619 46 2.732203 47 2.279176 48 2.565911 49 2.884355 50 2.702268 51