Question 1. Use the data file AutoInsurance.xlsx to answer this question. The average annual premium for automobile insurance in the United States is $1,503. The following annual premiums ($) are representative of the web site's findings for the state of Michigan. Assume the population is approximately normal. Use excel to answer the following questions. In addition to your written response, submit an excel file that shows your work labelled "Q1.xlsx." a) Provide a point estimate of the mean annual automobile insurance premium in Michigan. b) Develop a 95% confidence interval for the mean annual automobile insurance premium in Michigan. c) Does the 95% confidence interval for the annual automobile insurance premium in Michigan include the national average for the United States? What is your interpretation of the relationship between auto insurance premiums in Michigan and the national average