The average annual premium for automobile insurance in the United States is $1411. A representative sample of annual premiums fo
r the state of Michigan is contained in the Excel Online file below. Assume the population is approximately normal. Construct a spreadsheet to answer the following questions.Open spreadsheeta. Provide a point estimate of the mean annual automobile insurance premium in Michigan.$ (to the nearest dollar)b. Develop a 95% confidence interval for the mean annual automobile insurance premium in Michigan.($ , $ ) (to the nearest cent)c. Does the 95% confidence interval for the annual automobile insurance premium in Michigan include the national average for the United States