CHALLENGE ACTIVITY 7.1.4: Excel: Hypothesis test for a population proportion. Click this link to download the spreadsheet for use in this activity. 402294.2602416.qx3zqy7 Jump to level 1 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 6 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 + Z = P= Since the p-value is Pick than the significance level 0.05, the null hypothesis Pick v Pick v evidence exists that the proportion of packages with 3 ounces or more of chocolate stars is less than 0.8