Instructions: Answer each question in two different ways - first by doing the calculations manually and second by using Excel. The solution to each question should include the following: the appropriate calculations (showing all work), the Excel output, and the blanks filled in. Write all hypotheses using mathematical notation. The Excel output can either be submitted as an Excel file with each question on a different sheet, or as . pdf files. Submit your solutions by uploading the appropriate files in the Assignment folder. Your submission is due before 11:59pm on July 3. 1. A politician had an approval rating of 62% last week. This week a random sample of 814 voters was asked if they approve of the politician and 485 responded that they do. Can we infer, at the 5% significance level, that the politician's approval rating has decreased since last week? 29 marks Ho : H1 : Conclusion: Reject Ho Do not reject Ho Reason for conclusion