CHALLENGE ACTIVITY / 1.4 Excel Hypothesis test for a population proportion. Click thin link to download the spreadsheet for use in this activity A bank has a policy that the proportion of loans made to poople 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 significance level of 0.05 Use Sheet 1 of the Excel file to "caloulate po, the #-soore and the pievalue. D = 1:173833 # 2457 Since the p-value is greater than the significance level 0.05, the null hypothesis | fails to be rejected insufficient evidence exists that the proportion of loans to people with more than $50,000 in debt is more than 0.15. Next