merging a dataset to an original data
Description
I’m writing a linear regression paper testing the impact of legalized abortion on the crime rate in each. I need help collecting police per capita data for every state and merging it with the original data. check the attachment for deatals
Unformatted Attachment Preview
unemployment rate( st) + ??
Where s stands for state and t stands for year
The dependent variable is the crime rate which is the total of ( murder rate , robbery rate , violence
crime rate, rape crime rate, property crime rate) for a state at a giving year from 2010 2020 )
The independent variable is the average abortion of a state from 1990-2000)
The control variables are police per capita for a state a state at a giving year from 2010 2020
And the unemployment rate for a state a state at a giving year from 2010 2020
So I`testing weather the abortion that was done between 1990 -2000 for each state can effect crime
rate for that state from 2010- 2020
I was able to use the data from The state correlates data project from Michigan State
(http://ippsr.msu.edu/public-policy/correlates-state-policy)
The codebook file will tell you all of the
variables: https://ippsr.msu.edu/sites/default/files/cspp/codebook_2-5.pdf
Here is the coding for that
install.packages(“cspp”)
library(cspp)
library(tidyverse)
data1
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."