hypothesis_test_proportions (1) - Excel nate whitson NW File Home Insert Page Layout Formulas Data Review View Help Acrobat Tell me what you want to do Share zyBooks My library > MAT 240: Applied Statistics home > 7.1: Hypothesis test for a population proportion zyBooks catalog ? Help/FAQ @ Nate Whitson Cut Calibri - 11 - A A = =2 2 Wrap Text General AutoSum ~ AYO Hypothesis testing Since p is greater than the significance level (0.178 > 0.01), insufficient statistical evidence exists to reject Paste Copy Conditional Format as Cell Insert Delete Format Fill ~ Sort & Find & 5.2 Hypothesis test for a the null hypothesis. Format Painter Merge & Center ~ $ ~ % " 38 48 Formatting * Table " Styles Clear Filter ~ Select population mean Feedback? Clipboard Font Alignment Number Styles cells Editing Print chapter A1 1 X V fx 3.27352542920152 6) Module 6 - Confidence Intervals CHALLENGE 7.1.4: Excel: Hypothesis test for a population proportion. A B C D E G H K L M N P Q R S T U V W 6.1 Confidence intervals Click this link to download the spreadsheet for use in this activity. 9 3.202865 6.2 Confidence intervals for 10 3.760863 population means 11 3.648738 Print chapter Jump to level 1 U 12 3.155042 Module 7 - Hypothesis 13 3.047772 Testing with Population In order for a candy company to claim that a bridge mix is mostly chocolate stars, a proportion of at least 14 2.331491 Proportions 0.8 of the packages must contain 3 ounces or more of chocolate stars. Quality control tests a random 15 2.434267 7.1 Hypothesis test for a sample of 50 packages to determine if the proportion is less than 0.8 at a significance level of 0.05. Use population proportion Sheet 5 of the Excel file to calculate p, the z-score, and the p-value. 16 3.316263 17 3.335704 7.2 Confidence intervals for population proportions P = Ex: 1.234 8 3.123784 19 1.983015 Print chapter 20 4.026382 8) Module 8 - Hypothesis 21 2.819852 Testing with Two 22 3.020835 Population Since the p-value is Pick |than the significance level 0.05, the null hypothesis |Pick 23 3.963952 Hypothesis tests for the 24 3.434813 population means Pick |evidence exists that the proportion of packages with 3 ounces or more of chocolate stars is less than 0.8. 25 2.530151 B.2 26 3.501124 difference between two 27 2.723868 population proportions 28 3.734019 8.3 Misleading statistics Check 29 3.074854 8.4 Abuse of the p-value Next 30 2.94544 Print chapter 31 2.963046 Appendix A: Distribution Feedback? 32 3.301251 9) Tables 33 3.806637 References 34 2.49562 10) Appendix B: Data Sets 35 2.990224 11) Appendix C: Calculators (*1) Grech, Victor, et al. "Unexplained differences in sex ratios at birth in Europe and North America." BMJ, 324(7344), 27 April 2002, 36 2.548798 www.ncbi.nim.nih.gov/pmc/articles/PMC102777/ Sheet1 | Sheet2 | Sheet3 | Sheet4 Sheets Sheet6 | Sheet7 | Sheet8 | Sheet9| + 12) How to use a zyBook How was this section? I ! Provide feedback Ready Average: 3.27928409 Count: 50 Sum: 163.9642045 Display Settings 8 - 100% :# 99. 79.F Rain coming ~ O