Q snhu stu X Home X Home X D2L 7-2 Chal X zy Section X x hypothe x M Yourans X * Course X Course X * Coursel X + X C 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 V 1 V A charity claims that a proportion of 0.75 of donations go to communities where the average family income 2 is less than $20,000 a year. A watchdog group checks a random sample of 60 communities that received funds from the charity to determine if the proportion is different than 0.75 at a significance level of 0.05. w Use Sheet 9 of the Excel file, which gives the average family incomes for the 60 communities, to calculate p the z-score, and the p-value. p = Ex: 1.234 # P = Since the p-value is Pick * than the significance level 0.05, the null hypothesis Pick Pick evidence exists that the proportion of donations to communities with an average family income of less than $20,000 a year is different from 0.75. 3 87'F 12:23 PM A Sunny 9/12/2022 2Q snhus X Home X Home X D21 7-2 Ch x zy Section X xhypoth X x hypotl x M Youra X * Course X * Course X * Course X + X C https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fstatic-resources.zybooks.com%2Fhypothesis_test... A" Amazon.com - Onli.. Booking.com McAfee Security _ LastPass password... ) YouTube ) Maps M Gmail bbbbN1120. _ Amazon.com - Onli.. .|LastPass Other favorites We've opened your file for quick and easy viewing right in Microsoft Edge. Choose Download file if you want to use it later. Download file X Excel hypothesis_test_proportions - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments 12 v B vavAv ... Ev ab General .00 . .. A1 " X V f* 26412.3045045181 A B C D E F G H I J K L M N O P Q R S T U 26412.3 13064.89 11386.09 18264.83 26187.4 15941.98 20922.07 27491.03 12306.65 10 25552.96 11 12430.87 12 21922.07 13 20550.99 14 14911.38 15 15055.07 16 17912.32 17 6484.898 = Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8 Sheet9 + Workbook Statistics Give Feedback to Microsoft 100% + 87.F X 12:24 PM Sunny 9/12/2022 2Q snhus X Home X Home X D21 7-2 Ch x zy Section X xhypoth X x hypotl x M Youra X * Course X * Course X * Course X + X C https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fstatic-resources.zybooks.com%2Fhypothesis_test... A" Amazon.com - Onli.. Booking.com McAfee Security _ LastPass password... ) YouTube ) Maps M Gmail bbbbN1120. _ Amazon.com - Onli.. .|LastPass Other favorites We've opened your file for quick and easy viewing right in Microsoft Edge. Choose Download file if you want to use it later. Download file X Excel hypothesis_test_proportions - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments 12 v B vavAv ... Ev ab General .00 . .. A1 " X V f* 26412.3045045181 A B C D E F G H I J K L M N O P Q R S T U 17 6484.898 18 24222.59 19 18844.7 20 22596.76 21 21972.53 22 10630.45 23 16379.1 24 26677.71 25 13317.8 26 11402.53 27 23439.22 28 15478.03 29 19673.94 30 15552.22 31 17514.23 32 23359.72 33 16204.59 = Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8 Sheet9 + Workbook Statistics Give Feedback to Microsoft 100% + 87.F X 12:24 PM 2 Sunny 9/12/2022Q snhus X Home X Home X D21 7-2 Ch x zy Section X xhypoth X x hypotl x M Youra X * Course X * Course X * Course X + X C https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fstatic-resources.zybooks.com%2Fhypothesis_test... A" Amazon.com - Onli.. Booking.com McAfee Security _ LastPass password... ) YouTube ) Maps M Gmail bbbbN1120. _ Amazon.com - Onli.. .|LastPass Other favorites We've opened your file for quick and easy viewing right in Microsoft Edge. Choose Download file if you want to use it later. Download file X Excel hypothesis_test_proportions - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments v B vavAv ... Ev ab General .00 . .. A50 * X V fx 19536.7361530515 A B C D E F G H I J K L M N O P Q R S T U 34 12740.85 35 25661.79 36 14178.26 37 17972.93 38 17101.02 39 17705.07 40 12972.75 41 9598.044 42 20364.33 43 19207.27 44 15566.48 45 15973.51 46 21740.1 47 23631.44 48 27108.18 49 20401.24 50 19536.74 = Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8 Sheet9 + Workbook Statistics Give Feedback to Microsoft 100% + 87.F X 12:24 PM ())) O 9/12/2022 2 SunnyQ snhus X Home X Home X D21 7-2 Ch x zy Section X xhypoth X x hypotl x M Youra X * Course X * Course X * Course X + X C https://view.officeapps.live.com/op/view.aspx?src=https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fstatic-resources.zybooks.com%2Fhypothesis_test... A" Amazon.com - Onli.. Booking.com McAfee Security _ LastPass password... ) YouTube ) Maps M Gmail bbbbN1120. _ Amazon.com - Onli.. .|LastPass Other favorites We've opened your file for quick and easy viewing right in Microsoft Edge. Choose Download file if you want to use it later. Download file X Excel hypothesis_test_proportions - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Viewing Comments 12 v B vavAv ... Ev ab General .00 . .. A65 * X V fx A B C D E F G H I J K L M N O P Q R S T U 49 20401.24 50 19536.74 51 19373.72 52 24825.52 53 24134.17 54 9490.176 55 18902.36 56 14482.23 57 14735.54 58 11402.11 59 18576.12 60 17019.63 61 62 63 64 65 = Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8 Sheet9 + Workbook Statistics Give Feedback to Microsoft 100% + 87 F X 12:24 PM ())) 0 2 Sunny 9/12/2022