Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Subject: Statistics and Probability Course: PADM 60381 Dataset: states_REG Dependent Variable: Cigarette consumption (cigarettes) Using the cigarette consumption variable as your dependent variable and the

Subject: Statistics and Probability

Course: PADM 60381

Dataset: states_REG Dependent Variable: Cigarette consumption (cigarettes) Using the cigarette consumption variable as your dependent variable and the cigarette tax (cig_tax) asyour key explanatory variable, do the following: 1. Run a bivariate regression between cigarette consumption (cigarettes) and cigarette taxes (cig_tax). [NOTE: This should be the same model complete in the Bivariate Statistics Assignment]. 2. Run a multivariate regression model with the following control variables (include the results in your homework). NOTE: For the multivariate regression, you should include these variables in the model as a control in addition to the cig_tax variable from the bivariate model a. Percent of the population with a college degree (college) b. Percent of the population aged 18-24 (pop_18_24) c. Per capita income (prcapinc) d. Percent urban population (urban) 3. Rerun the model, but this time, also control for Southern states (south). NOTE: This variable shouldbe added to the model above (i.e., you should have 6 IVs in this model). Answer the following questions: 1. Is the hypothesis that higher cigarette tax rates are associated with lower consumption supported? (provide an answer for all three models). NOTE: Discuss bothsubstantive and statistical significance. 2. What variables are statistically significant in the third model? 3. Based on the third model, if taxes in a state were to increase by $0.50, what would the expectedimpact be on cigarette consumption? 4. How well do these models explain variation in cigarette consumption? (i.e., R2) 5. Which model do you consider to be the best model? Why?

The assignment should be submitted as an Excel file with your results.

The data link is below. Copy and paste the URL; the link will give access to the data needed for this homework assignment.

https://docs.google.com/spreadsheets/d/1--eSvAYAIkQ4dRppiceZ3mUb-NA34rzc/edit?usp=share_link&ouid=106596741055892912212&rtpof=true&sd=true

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: Howard Anton, Irl C Bivens, Stephen Davis

11th Edition

1118883764, 9781118883761

More Books

Students also viewed these Mathematics questions