Question 1. Use the data file AutoInsurance.xlsx to answer this question. The av

Question

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. ”
.
1) Develop a 95% confidence interval for the mean annual automobile
insurance premium in Michigan.

2115

CAN YOU SHOW ME HOW TO GET THE ANSWER ON EXCEL

THANK YOU

Annual Premium 1905 2725 2677 2600 2962 2184 2332 3112 2545 2525 2370 2545 2529 2442 2312 2981 2627 2857 2675

2115

CAN YOU SHOW ME HOW TO GET THE ANSWER ON EXCEL

THANK YOU

Explanation / Answer

Please copy-paste the below link in your browser to access the excel file:

http://jmp.sh/v/U47Y3pCpePxfpoBs3u95

The question has been solved in 2 ways:

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.