1. Russia has recently started a push for stronger smoking regulations much like those in Western countries concerning cigarette advertising, smoking in public places, and so on. The WEBfile named Russia contains sample data on smoking habits of Russians that are consistent with those reported by The Wall Street Journal (The Wall Street Journal, October 16, 2012). Analyze the data using Excel and answer the following questions.
a. Develop a point estimate and a 95% confidence interval for the proportion of Russians who smoke.
b. Develop a point estimate and a 95% confidence interval for the mean annual per capita consumption (number of cigarettes) of a Russian.
c. For those Russians who do smoke, estimate the number of cigarettes smoked per day.
2. The Health Care Cost Institute tracks health care expenditures for beneficiaries under the age of 65 who are covered by employer-sponsored private health insurance (Health Care Cost Institute website, November 4, 2012). The data contained in the WEBfile named DrugCost are consistent with the institute's findings concerning annual prescription costs per employee. Analyze the data using Excel and answer the following questions.
a. Develop a 90% confidence interval for the annual cost of prescription drugs.
b. Develop a 90% confidence interval for the amount of out-of-pocket expense per employee.
c. What is your point estimate of the proportion of employees who incurred no prescription drug costs?
Attachment:- Assignment Data.rar