An insurance analyst working for a car insurance company would like to determine the proportion of accident claims covered by the company. A random sample of 200 claims shows that the insurance company covered 80 accidents claims while 120 claims were not covered. Construct a 90% confidence interval estimate of true proportion of claims covered by the insurance.
Can you show me how to solve using excel?
and do the claims fall within the 90% interval?