Suppose that you work for the Health Secretary and would like to understand the connection between smoking
Fantastic news! We've Found the answer you've been seeking!
Question:
Suppose that you work for the Health Secretary and would like to understand the connection between smoking prevalence and cigarette tax. You collected a dataset that contains the following data for the 22 US states:
Percentage of smokers in the adult population (Persmoke)
Cigarette tax in pennies (cigtax)
Tobacco related death rate per 100,000 people (tobaccodeathrt)
Percentage of families living below the poverty level (perfampoverty)
Median household income in the state (MedianIncome)
Percentage of population not covered by health insurance (Pernoinsurance)
Execute the analysis and answer the following questions:
- Estimate a regression model in Excel and include all the above-mentioned variables as controls. Which variables are not significant on 5% level?
- Interpret the estimated parameter for perfampoverty (regardless of its significance).
- What do you think, are the assumptions of the linear regression model satisfied? Explain.
- What is your conclusion regarding your research question?
Related Book For
Business Forecasting with ForecastX
ISBN: 978-0073373645
6th edition
Authors: Holton wilson, barry keating, john solutions inc
Posted Date: