Sheet number 5 from the excel spreadsheet is copied underneath the question.

CHALLENGE ACTIVITY 7.1.4: Excel: Hypothesis test for a population proportion. Click this link to download the spreadsheet for use in this activity. 427020.2697174.qx3zqy7 Start In order for a candy company to claim that a bridge mix is mostly chocolate stars, a proportion of at least 0.8 of the packages must contain 3 ounces or more of chocolate stars. Quality control tests a random sample of 50 packages to determine if the proportion is less than 0.8 at a significance level of 0.05 Use Sheet 5 of the Excel file, which gives the weight of chocolate stars in each of the 50 packages, 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 v evidence exists that the proportion of packages with 3 ounces or more of chocolate stars is less than 0.8. 1 Check Next Feedback