A bank has a policy that the proportion of loans made to people with more than $50,000 in debt should no 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 z = n=

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.6: Summarizing Categorical Data
Problem 30PPS
icon
Related questions
Question
20171.18
46831.5
21789.85
4828.121
14684.72
-12813.6
24519.65
73135.66
29135.23
42180.99
2261.035
52749.12
41403.37
26760.47
32546.79
17728.36
-2407.25
39998.17
9780.605
45741.21
37178.78
33696.61
43259.29
26814.31
31291.52
37175.38
50136.51
55886.29
8696.373
30507.27
69778.96
52346.39
-13641.8
24661.96
9746.476
50024.07
78575.84
26692.57
38463.91
30145.11
40459.87
10816.03
14662.31
44380.93
34686.81
30315.94
18222.65
39422.52
43345.67
-2355.16
49109.01
21361.93
32708.77
50170.42
11337.63
36858.01
19704.15
34739.6
10822.38
-1332.56
70582.65
45813.68
27238.56
36232.78
29583.19
51432.22
70353.96
49991.42
37953.37
24107.22
19944.66
22744.9
31955.78
53442.8
36301.04

Spreadsheet 2

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
Z
P =
Since the p-value is Pick ✓than the significance level 0.05, the null hypothesis Pick
Pick
✓evidence exists that the proportion of loans to people with more than $50,000 in debt is
more than 0.15.
Transcribed Image Text: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 Z P = Since the p-value is Pick ✓than the significance level 0.05, the null hypothesis Pick Pick ✓evidence exists that the proportion of loans to people with more than $50,000 in debt is more than 0.15.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt