Please use sheet 2!

Please use the link below to download the spreadsheet for this question:

https://s3-us-west-2.amazonaws.com/static-resources.zybooks.com/hypothesis_test_proportions.xlsx

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 significance level of 0.05 Use Sheet 2 of the Excel file, which gives the customer's debt amounts for the 75 people in the sample, to calculate p, the z-score, and the p-value. p = Ex: 1.234 2 = p Since the p-value is Pick than the significance level 0.05, the null hypothesis Pick Pick v evidence exists that the proportion of loans to people with more than $50,000 in debt is more than 0.15