The average annual premium for automobile insurance in the United States is $1578. A representative sample of annual premiums for 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.1914, 3198, 2366, 2707, 2568, 2966, 2650, 2564, 2635, 2676, 2351, 2823, 2924, 2600, 2644, 2142, 2568, 2110, 2310, 2405a. 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?YesNoWhat is your interpretation of the relationship between auto insurance premiums in Michigan and the national average?We would be % confident that auto insurance premiums in Michigan are abovebelow the national average.