51539.3

8052.017

35716.32

37010.69

31172.58

31088.99

20288.64

52734.52

-5422.71

128.8534

48485.96

30025.22

19891.47

26803.72

51758.67

88069.45

51200.97

34994.21

20571.93

51976.9

4703.652

47336.17

44720.1

29360.13

34616.27

1017.558

47474.09

60065.85

13371.6

23704.19

19126.38

62162.22

48230.9

20272.33

60161.6

29444.76

44479.55

6768.066

19667.52

32922.45

90692.28

44316.06

28841.63

43494.54

10604.87

7064.773

31668.88

10825.56

50646.8

30806.62

56348.36

628.1745

20646.31

49066.35

34841.71

25866.6

20601.18

34887.22

20777.51

31237.39

51193.99

56770.12

54597.87

39467.22

29068.5

18234.09

-6643.53

17241.42

3254.459

50951.66

41832.58

42992.05

55095.87

19057.21

42923.48

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^=

z=

p=

Since the p-value is Pick greater OR less than the significance level 0.05, the null hypothesis Pick fails to be rejected OR is rejected

Pick Sufficient Insufficientevidence exists that the proportion of loans to people with more than $50,000 in debt is more than 0.15.