A bank has a policy that the proportion of loans made to people with more than $50,000in debt should not be more than .15. The bank checks a randomly chosen sample of 75customer's debt amounts to determine if the proportion is more than .15at a significance level of .05. Use Sheet 1 of the Excel file to calculate ^p, the z-score, and the p-value.Since the p-value is _________, than the significance level .05, the null hypothesis __________. __________ evidence exists that the proportion of loans to people with more than$50,000 in debt is more than .15.

Sheet 1:

20171.17917

46831.50212

21789.85197

4828.121442

14684.72199

-12813.62658

24519.64567

73135.65589

29135.23203

42180.99388

2261.035105

52749.11581

41403.37309

26760.47296

32546.78786

17728.36083

-2407.251974

39998.16503

9780.605279

45741.20777

37178.77657

33696.61461

43259.28676

26814.3061

31291.52295

37175.3762

50136.51484

55886.29476

8696.373353

30507.26797

69778.95931

52346.38534

-13641.80973

24661.95764

9746.475643

50024.06526

78575.843

26692.57359

38463.91388

30145.10746

40459.86837

10816.02791

14662.31166

44380.92984

34686.81102

30315.93897

18222.65474

39422.52312

43345.6669

-2355.16029

49109.01349

21361.93344

32708.76955

50170.42323

11337.62744

36858.00529

19704.15071

34739.59836

10822.37914

-1332.557786

70582.64779

45813.68148

27238.56072

36232.78065

29583.18781

51432.21531

70353.96439

49991.42481

37953.36908

24107.22091

19944.6577

22744.89512

31955.77634

53442.79738

36301.042