1. Convert the excel files into Stata data sets. 2. The demographic data was extracted from a system that inconsistently coded gender . Recode it so that males are consistently coded as "M" and females are consistently coded as "F". 3. The demographic data also combines race and ethnicity into a single variable . Recode this variable so that Race contains three values (ASIAN , BLACK ,WHITE ), and a new variable called ethnicity has two values (HISPANIC ,NONHISPANIC ). 4. Merge the Case and demo datasets together so that each row in the case dataset also contains the demographics of the defendant 5. Create an 'age 'variable that equals the defendant's age at the time of the case's arrest date . Part 2: Statistical Analysis Help the SA's Office determine if the program should be continued [expanded by estimating the program's effect on re -arrests prior to disposition .To draw conclusions about this program's effect , answer the foliowing questions 1) Describe the demographic characteristics of the study population based on the data availabie to you . (hint : the study population has 25,000 subjects ). 2) Are the treatment and control groups balanced (on race , gender , etc.), or are their differences in the composition of the two groups ? 3) Did participating in the program reduce the likelihood of re-arrest before disposition