I need some help with these problems

Data: https://www.limes.one/Content/DataFiles/US_CRime.txt

Breakdown ot RA2 trom trom trom trom trom O to 02 0.2 too 4 Ou too 6 0.6 to 0 85 085 to 1 (poor) (decent) (good) (very good) (excellent) Upload LIS crime data and tocus on the state ot Illinois. Your job is to "cut-&-paste" the data and create 7 columns and label them Murder, Rape, Robbery, Assault, Burglary, Larceny, and Car Theft respectively. Next pertorm a regression to predict the Robbery. count using the remaining 6 variables. Finally, pick the variables witn the best P- values and create a new table, this time using these two variables in order to predict the Robbery count Answer the questions using this new table QLIL l) What are the two variables you picked? (10 points) O a. Rape and Robbery 0 5. Larceny and Car Then O c. Robbery and Assault O d. Assault and Larceny O e. None of the above II) Atter getting the new table, choose the variable with larger positive coefficient and describe its interpretation. (10 points) O a. Larceny; On average, as the Larceny count increases by one, the Robbery count increases by 0.036153 0 5. Assault; On average, as the Assault count increases by one, the Robbery count increases by 3.87691 O c. Motor Vehicle T nett; On average, as the Motor Vehicle T nett count increases by one, the Robbery count increases by 0.505412 O d. Assault; there is a very strong correlation between Assault and Robbery O e. None of the above Ill) How good is the tit and why? (5 points) O a. Excellent, R-squared is above 0.85 0 5. Excellent, P-value is below 0.05 O c. Excellent, Both P-values are very small O d. None of the above 'V) Which ot the two variables has a better P-value? (5 points) O a. Rape 0 5. Larceny O c. Robbery O d. Assault O e. None of the above