MATH 225N Week 7 Assignment; Construct Hypothesis Test for Proportions - Excel

1. Question: Steve listens to his favorite streaming music service when he works out. He wonders whether the service's algorithm does a good job of finding random songs that he will like more often than not. To test this, he listens to 50 songs chosen by the service at random and finds that he likes 32 of them. Use Excel to test whether Steve will like a randomly selected song more often than not, and then draw a conclusion in the context of the problem. Use α=0.05. 2. Question: Dmitry suspected that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14times. Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%. 3. Question: Dmitry suspects that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14times. Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%. 4. Question: Dmitry suspects that his friend is using a weighted die for board games. To test his theory, he wants to see whether the proportion of odd numbers is different from 50%. He rolled the die 40 times and got an odd number 14times. Dmitry conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of odds is different from 50%. 5. Question: A magazine regularly tested products and gave the reviews to its customers.In one of its reviews, it tested two types of batteries and claimed that the batteries from Company A out performed the batteries from Company B. A representative from Company B asked for the exact data from the study. The author of the article told the representative from Company B that in 200 tests, a battery from Company A outperformed a battery from Company B in 108of the tests. Company B decided to sue the magazine, claiming that the results were not significantly different from 50%and that the magazine was slandering its good name. Use Excel to test whether the true proportion of times that Company A's batteries outperformed Company B's batteries is different from 0.5.Identify the p-value, rounding to three decimal places.