As always, be sure you've reviewed the Instructions tab first! A Sample Proportion (p-hat) Expected Proportion (p) 1-p Sample Size (n) Formula Data Entry Formula For these questions, you may use any values that you have already calculated to calculate future values. For instance, when finding "1-p" for question 1A, enter =1-C3 to let Excel calculate the value for you. When finding the z-score, use the values from the cells above it to calculate it, rather than entering everything in by hand. Data Entry Z-Score Formula Probability (right tailed) Function A. Females participated in every event at the 2012 Summer Olympic Games. Prior to 2012, there had been a steady increase in the female participation rate. The International Olympic Committee states that the female participation in the 2004 Summer Olympic Games was 40%, even with new sports such as weight lifting, hammer throw, and modern pentathlon recently added to the Games. Broadcasting and clothing companies wanted to change their advertising and marketing strategies if the female participation increased at the next games. Prior to the 2008 games, an independent sports expert arranged for a random sample of pre-Olympic exhibitions. The sports expert reported that 197 of 457 athletes in the random sample were women. Is this strong evidence that the participation rate may have increased? Find the probability that the proportion of women athletes is greater than 40%. Correctly round your percentage to 2 decimal places in your conclusion sentence. Conclusion: Sample Mean (x-bar) Expected Mean (mu) Sample Stand. Dev (s) Sample Size (n) Function Data Entry Function Data Entry or Function B. Suppose that the editor of a new textbook was hoping that the book would have mean word length of 6.5 letters. The editor randomly selected 20 words from randomly selected pages. That data is given on the Data Set page for "Word Count". Find the probability that the mean word length of the textbook differs from the desired 6.5 letters by less than 1. Correctly round your percentage to 2 decimal places in your conclusion sentence. You may choose to use the full summary statistics pasted to this page, then point your sample mean and sample standard deviation boxes to the appropriate values or use the "AVERAGE", "STDEV.S" and "COUNT" functions. Z-Score Formula Probability (between) Function Conclusion: