red rozay RR X X AutoSave @ Off hypothesis_test_proportions (7) Search (Alt+Q) Comments Share File Home Insert Page Layout Formulas Data Review View Help Insert Calibri 11 ~A A" ab General Ap O Cell Delete Sort & Find & Analyze Paste BIU~ ~ ~A - $ ~ % " Conditional Format as Formatting Table Styles v Format Filter * Select v Data Number Styles Cells Undo Clipboard Font Alignment Editing Analysis D22 viXA S T A B C D E F G H I J K L M N O P Q R 22 47336.17208 23 44720.10297 24 29360.12547 25 34616.27351 26 1017.557502 27 47474.0926 28 60065.8519 29 13371.59926 30 23704.18652 31 19126.3776 32 62162.22339 33 48230.8969 34 20272.32811 35 60161.59658 36 29444.76198 37 44479.55104 38 6768.065853 39 19667.51704 40 32922.45117 41 90692.2755 42 44316.06317 30041 63637 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Sheet9 + + 100%% Ready Accessibility: Investigate 11:31 AM 87 F X W 9/12/2022 2 Mostly sunnyred rozay RR X X AutoSave @ Off hypothesis_test_proportions (7) Search (Alt+Q) Comments Share File Home Insert Page Layout Formulas Data Review View Help Insert Calibri 11 ~ A A" ab General Ap O EE $ ~ % " Conditional Format as Cell Delete Sort & Find & Analyze Paste Formatting Table Styles v Format Filter * Select v Data Analysis Clipboard Font Alignment Number Styles Cells Editing Undo D63 viXA A B C D E F G H I J K L M N O P Q R S T 43 28841.62637 44 43494.54116 45 10604.87441 46 7064.773213 47 31668.88433 48 10825.55844 49 50646.80234 50 30806.62003 51 56348.36418 52 628.1745048 53 20646.31227 54 49066.35498 55 34841.71043 56 25866.6015 57 20601.17964 58 34887.22349 59 20777.51475 60 31237.39411 OneDrive X 61 51193.98898 62 56770.12037 Screenshot saved 63 54597.87126 The screenshot was added to your 6A 20467 91661 Sheet9 OneDrive Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets + 1009 Ready Accessibility: Investigate 11:31 AM 87 F X W 9/12/2022 2 Mostly sunnyAutoSave @ Off red rozay RR X X hypothesis_test_proportions (7) Search (Alt+Q) Comments Share File Home Insert Page Layout Formulas Data Review View Help Insert Calibri 11 ~A A" ab General Ap O Cell Delete Sort & Find & Analyze Paste BIU~ ~ ~A - $ ~ % " Conditional Format as Formatting Table Styles v Format Filter * Select v Data Cells Undo Clipboard Font Alignment Number Styles Editing Analysis D64 viXA A B C D E F G H I J K L M N O P Q R S T 64 39467.21661 65 29068.49913 66 18234.09347 67 -6643.530219 68 17241.41923 69 3254.458632 70 50951.65933 71 41832.57903 72 42992.04916 73 55095.86621 74 19057.20606 75 42923.48012 76 77 33274.57194 Average 78 79 80 81 82 83 84 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Sheet9 + + 100% Ready Accessibility: Investigate 11:31 AM 87 F X W 9/12/2022 2 Mostly sunnyQ snhu stude x Home X Home X D21 7-2 Challe X zy Section 7.1 X * hypothesis x M Your answerurse He X * Course He X + X G https://learn.zybooks.com/zybook/MAT-240-J1566-OL-TRAD-UG.22EW1/chapter/7/section/1?content_resource_id=52309978 Amazon.com - Onli.. Booking.com _ McAfee Security LastPass password.. YouTube Maps M Gmail bbbbN1120. Amazon.com - Onli... .|LastPass Other favorites = zyBooks My library > MAT 240: Applied Statistics home > 7.1: Hypothesis test for a population proportion zyBooks catalog ? Help/FAQ @ Schwandala Cooksey CHALLENGE ACTIVITY 7.1.4: Excel: Hypothesis test for a population proportion. Click this link to download the spreadsheet for use in this activity. 426968.2697550.qx3zqy7 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 " " O - K 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 87'F 11:31 AM 9/12/2022 2 Mostly sunnyX AutoSave @ Off hypothesis_test_proportions (7) Search (Alt+Q) red rozay RR X File Insert Comments Share Home Page Layout Formulas Data Review View Help Insert Calibri 11 ~A A" ab General Ap O Cell Delete Sort & Find & Analyze Paste BIU~ ~ ~A - $ ~ % " Conditional Format as Formatting Table Styles v Format Filter * Select v Data Clipboard Font Alignment Number Styles Cells Editing Analysis Undo D1 viXA A B C D E F G H I J K L M N O P Q R S T 51539.29919 8052.016591 35716.31651 37010.68615 31172.5786 31088.99026 20288.64299 52734.51646 1 00 -5422.706014 10 128.8534293 11 48485.9593 12 30025.21757 13 19891.47232 14 26803.72091 15 51758.66724 16 88069.44647 17 51200.96717 18 34994.21226 19 20571.92917 20 51976.89938 21 4703.651572 17326 17209 Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheets Sheet9 + + 100%% Ready Accessibility: Investigate 87 F X W 11:31 AM 9/12/2022 2 Mostly sunny