These questions all use STATA as the coding language.

Short Answer Question (Practice) Imagine researchers are interested in understanding the relationship between opioid prescriptions rates and unemployment rates in the United States. The dataset labeled opioids below show the number of opioid prescriptions written per 100 people in a year (this is a snapshot of the total dataset) within counties in the U.S. For example, a value of 200 indicates there were 2 opioid prescriptions per person in the county (individuals can have multiple prescriptions in a year, which is why this variable can be above 100). The variable county includes the name of the county, the variable fips_county contains a unique code that identifies each county, and the variable state indicates the state of the county. The data labeled unemployment contains the name of the county, the unemployment rate of the county, as well as fips_county, which contains a unique code that identifies the county. opioids data Unemployment data 1. In both datasets the unit-of-observation is a county. Write code below that will merge the two datasets together. 2. In the code above, does the resulting merged dataset contain (1) only observations that match between the datasets or (2) all observations. If it only contains the observations that match, explain why. If it contains all observations, write additional code below to keep only counties that are in both the opioids and unemployment rate datasets. 3. Write code below that estimates a regression with the opioid prescription rate as the dependent variable and the unemployment rate as the independent variable. 4. Imagine I tell you (based on the regression in Part 3) that the predicted prescription rate for a county with an unemployment rate equal to 10 is 150 , while the predicted prescription rate for a county with an unemployment rate equal to 8 is 120 . What is the slope coefficient in the regression? Explain your answer/show your work. 5. Write a clear interpretation of the slope coefficient. In other words, what does the slope coefficient tells us about the relationship between unemployment rates and prescription rates. Be specific in your