The file Crimecontains yearly observations for the crime rates in the United States from 1980 to 2019. The column F contains information on party affiliation of The President during that year.

1. Create a dummy variable for the party affiliation of The President of the United States for each year in the data. It's up to you to chose which values to assign for Republican and Democrat.
2. Provide the summary statistic (mean and st. deviation) for the following variables: Dummy variable for party affiliation and the Violent crime rate.
3. Using the scatterplot, check if there is a time trend for total number of crime (for your scatterplot, time trend variable should be on horizontal axis and violent crime should be on vertical axis). Please insert your scatterplot below. Why do you think you get the result you get?

1. Estimate a regression in which the dependent variable is Violent Crime and independent variables are trend and the dummy variable for the party affiliation (that you created in part a). Insert the table with results here.

\fViolent/Pop = 3, + B, Trend + B, Trump + u