Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357191484
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 8, Problem 52SE
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?
- d. Which, if either, of the confidence intervals in parts (a) and (b) has a larger margin of error. Why?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A universal childcare program was introduced in London in the early 2000s.
Comparing the years before and after the implementation of the policy, the employment rate for mothers of children under 5 in London increased from 40 percent to 60 percent.
What assumption we need for the difference in employment rates for mothers of children under 5 in London to be a causal estimate of the impact of the policy?
Evaluate the source for reputability, transparency, andbeing evidential.
Scenario:
In a study conducted by the Pew Research Center, 681 university students were surveyed. Of those surveyed, 32% reported experiencing food insecurity - and going without food to pay for textbooks and housing instead.
Short answer
A. The exact question reads "Within the last 30 days, have you gone without food to pay for textbooks or housing instead?": describe the type of data collected by this question as precisely as possible.
B.University administrators were expecting a proportion closer to 9%. Without resortingto any analysis methods, does it appear that the result has statistical significance?
Classify the following studies as either descriptive or inferential and explain your answers.
TV Viewing Times. Data from a sample of Americans yielded the following estimates of average TV viewing time per month for all Americans 2 years old and older. The times are in hours andminutes; Q1 stands for first quarter. [SOURCE: The Cross-Platform Report, Quarter 1, 2011. Published by The Nielsen Company, _c 2011.]
Chapter 8 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Ch. 8.1 - 1. A simple random sample of 40 items resulted in...Ch. 8.1 - 2. A simple random sample of 50 items from a...Ch. 8.1 - 3. A simple random sample of 60 items resulted in...Ch. 8.1 - 4. A 95% confidence interval for a population mean...Ch. 8.1 - 5. Data were collected on the amount spent by 64...Ch. 8.1 - Travel Taxes. In an attempt to assess total daily...Ch. 8.1 - The National Fire Protection Association reported...Ch. 8.1 - 8. Studies show that massage therapy has a variety...Ch. 8.1 - Prob. 9ECh. 8.1 - 10. Costs are rising for all kinds of medical...
Ch. 8.2 - For a t distribution with 16 degrees of freedom,...Ch. 8.2 - Find the t value(s) for each of the following...Ch. 8.2 - The following sample data are from a normal...Ch. 8.2 - 14. A simple random sample with n = 54 provided a...Ch. 8.2 - Prob. 15ECh. 8.2 - Years to Bond Maturity. A sample containing years...Ch. 8.2 - Quality Ratings of Airports. The International Air...Ch. 8.2 - Unemployment in Older Workers. Older people often...Ch. 8.2 - Prob. 19ECh. 8.2 - Automobile Insurance Premiums. The average annual...Ch. 8.2 - Telemedicine. Health insurers are beginning to...Ch. 8.2 - Prob. 22ECh. 8.3 - 23. How large a sample should be selected to...Ch. 8.3 - Prob. 24ECh. 8.3 - Prob. 25ECh. 8.3 - Prob. 26ECh. 8.3 - Annual starting salaries for college graduates...Ch. 8.3 - Prob. 28ECh. 8.3 - 29. Customers arrive at a movie theater at the...Ch. 8.3 - Prob. 30ECh. 8.4 - 31. A simple random sample of 400 individuals...Ch. 8.4 - 32. A simple random sample of 800 elements...Ch. 8.4 - Prob. 33ECh. 8.4 - 34. At 95% confidence, how large a sample should...Ch. 8.4 - The Pew Research Center conducted a survey of...Ch. 8.4 - 36. According to statistics reported on CNBC, a...Ch. 8.4 - 37. One of the questions on a survey of 1000...Ch. 8.4 - According to Thomson Financial, through last...Ch. 8.4 - The percentage of Texans not covered by health...Ch. 8.4 - For many years businesses have struggled with the...Ch. 8.4 - 41. Fewer young people are driving. In 1983, 87%...Ch. 8.4 - Prob. 42ECh. 8.4 - Prob. 43ECh. 8.5 - Suppose a sample of 10001 erroneous Federal income...Ch. 8.5 - According to the Census Bureau, 2,475,780 people...Ch. 8.5 - Prob. 46ECh. 8.5 - Prob. 47ECh. 8 - 44. A sample survey of 54 discount brokers showed...Ch. 8 - 45. A survey conducted by the American Automobile...Ch. 8 - 46. The 92 million Americans of age 50 and over...Ch. 8 - Russia has recently started a push for stronger...Ch. 8 - 48. The Health Care Cost Institute tracks health...Ch. 8 - GlobalWebIndex reports that American Internet...Ch. 8 - 50. Mileage tests are conducted for a particular...Ch. 8 - Prob. 55SECh. 8 - Prob. 56SECh. 8 - 53. The National Center for Education Statistics...Ch. 8 - Prob. 58SECh. 8 - 55. The Pew Research Center has conducted...Ch. 8 - 56. A survey of 750 likely voters in Ohio was...Ch. 8 - The 2003 Statistical Abstract of the United States...Ch. 8 - 58. A well-known bank credit card firm wishes to...Ch. 8 - The American Enterprise Institute (AEI) Public...Ch. 8 - Prob. 64SECh. 8 - case Problem 1 Young Professional Magazine
Young...Ch. 8 - Gulf Real Estate Properties
Gulf Real Estate...Ch. 8 - Metropolitan Research, Inc.
Metropolitan Research,...
Knowledge Booster
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
- Examine the data elements in contemporary health data terminologiesarrow_forwardU.S. Department of Transportation As an auto insurance risk analyst, it is your job to research risk profiles for various types of drivers. One common area of concern for auto insurance companies is the risk involved when offering policies to younger, less experienced drivers. The U.S. Department of Transportation recently conducted a study in which it analyzed the relationship between 1) the number of fatal accidents per 1000 licenses, and 2) the percentage of licensed drivers under the age of 21 in a sample of 42 cities. Your first step in the analysis is to construct a scatterplot of the data. FIGURE. SCATTERPLOT FOR U.S. DEPARTMENT OF TRANSPORATION PROBLEM U.S. Department of Transportation The Relationship Between Fatal Accident Frequency and Driver Age 4.5 4. 3.5 3. 2.5 1.5 0.5 0. 6. 8 10 12 14 16 18 20 Percentage of drivers under age 21 pon visual inspection, you determine that the variables do have a linear relationship. After a linear pattern has been established visually, you…arrow_forwardThe fitted line that results from regressions of the Single Index Model is called:a. The security specific line.b. The security characteristic line.c. The single index line.d. The security market line.arrow_forward
- According to the World Health Organization, obesity has reached epidemic proportions globally. While obesity has generally been linked with chronic disease and disability, researchers argue that it may also affect wages. In other words, the body mass index (BMI) of an employee is a predictor for salary. (A person is considered overweight if his/her BMI is at least 25 and obese if BMI exceeds 30.) The accompanying data file includes salary (in $1,000s) for 30 college-educated men with their respective BMI and a dummy variable that represents 1 for a white man and 0 otherwise. Salary BMI White 34 33 1 43 26 1 44 26 1 34 35 0 34 36 1 53 20 1 42 20 0 37 26 1 35 28 1 46 22 1 46 20 1 34 35 0 45 26 1 33 34 0 25 29 0 32 30 1 46 18 0 31 31 0 54 19 1 37 23 0 42 27 1 38 30 1 45 18 0 38 26 0 41 28 1 39 28 1 50 20 1 41 26 1 38 28 1 45 21 1 1. Estimate a model for Salary with BMI and White as the predictor variables. Note: Negative…arrow_forwardwhat are the four imporatant sources of data?arrow_forwardGive a brief example of an empirical distribution of data.arrow_forward
- The report "Who Borrows Most? Bachelor's Degree Recipients with High Levels of Student Debt"+ reported the following percentiles for amount of student debt for those graduating with a bachelor's degree in 2010. 10th percentile = $0 25th percentile = $0 50th percentile = $11,000 75th percentile = $24,600 90th percentile = $39,300 For each of these percentiles, interpret the value of the percentile. (Select all that apply.) 10th percentile At least 10% of students owe nothing. Less than 10% of students owe nothing. At most 10% of students owe nothing. 25th percentile O At least 25% of students owe nothing. Less than 25% of students owe nothing. At most 25% of students owe nothing. 50th percentile O 50% of the students owe $11,000 or less. O 50% of the students owe exactly $11,000. 50% of the students owe at least $11,000. 75th percentile 75% of the students owe $24,600 or less. 75% of the students owe exactly $24,600. O 75% of the students owe more than $24,600. 90th percentile 90% of…arrow_forwardWhich type of data is the strongest data for statistical analysis?arrow_forwardThe second slide is the first part of the question and the first slide is the second part of the questionarrow_forward
- what is nominal (categorial) data?arrow_forwardDo you think it is reasonable to assume a statistically significant relationship between companies’ ESG profile and their cost of capital? Briefly explain. Do you think regional differences should be taken into account?arrow_forwardDefine the term Penal data?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Hypothesis Testing - Solving Problems With Proportions; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=76VruarGn2Q;License: Standard YouTube License, CC-BY
Hypothesis Testing and Confidence Intervals (FRM Part 1 – Book 2 – Chapter 5); Author: Analystprep;https://www.youtube.com/watch?v=vth3yZIUlGQ;License: Standard YouTube License, CC-BY