Please Answer Correctly and you must use Excel and show your workings.

1. A young investor in the stock market is concerned that investing in the stock market is actually gambling, since the chance of the stock market going up on any given day is 50%. She decides to track her favourite stock for 1 13 days and finds that on 43 days the stock was "up." a. Test the appropriate hypothesis. b. Find a 95% confidence interval for the proportion of days the stock is "up." Check the conditions. c. Does your confidence interval provide any evidence that the market is not random? d. What is the significance level of this test? An enthusiastic junior executive has run a test of his new marketing program. He reports that it resulted in a "significant" increase in sales. A footnote on his report explains that he used an alpha level of 9.1% for his test. Presumably, he performed a hypothesis test against the null hypothesis of no change in sales. a. If instead he had used an alpha level of 10%, is it more or less likely that he would have rejected his null hypothesis? Explain. b. If he chose the alpha level 9.1% so that he could claim statistical significance, explain why this is not an ethical use of statistics. 3. A survey of 1017 adults from Country A and 1960 adults from Country B found that 61% of the Country A adults and 58% of the Country B adults thought that homosexuality is something people are born with as opposed to being a preference they have chosen. Does a smaller percentage of Country B adults hold this view than Country A adults