11.4: Excel: Hypothesis test for a population proportion. nk to download the spreadsheet for use in this activity. .-:|.-.E:c,_ 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, which gives the customer's debt amounts for the 75 people in the sample, to calculate f)\" the zscore, and the pvalue. =- N '6) P Since thepvalue is -than 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