The Health Care Cost Institute tracks health care expenditures for beneficiaries under theage of 65 who are covered by employer-sponsored private health insurance (Health CareCost Institute website, November 4, 2012). The data contained in the DATAfile namedDrugCost are consistent with the institute’s findings concerning annual prescription costsper 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 peremployee.c. What is your point estimate of the proportion of employees who incurred no prescription drug costs?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section: Chapter Questions
Problem 8SGR
icon
Related questions
Topic Video
Question

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 DATAfile 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?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Proportions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill