Need EXCELL spread sheet for 3 years 2011, 2012, and 2013 with the case amount counted and then the recidivism amount with gender, race, age. Then anallyzed with Pearson r correlation for my Thesis Project. Need Excell, then graph, and explnation with r correlation.

Compariing 3 years with 500 random every 5thfile sampling with r correlation.
2013 is 3,537 children with 11,498 cases total. . 500 random sampling. Every 5 cases counted of the 3537 children and 57 cases found recidivated. The topics now are different of Gender, Race, Age. Recidivism was 57 cases. These are measure 1 Aggravated assault age 17 now white male with his first offense at 14. 9 Domestic Assaults with 6 female over age 15 3 whilte and 3 black. 7 Disorderly Conducts 10 femaile and 7 Male. l Rap .Male 16 White 4 Theft cases 3 white males age 16, 1 black femail age 16 2 Assault, 1 black male age 15 and 1 black female age 16. 3 Vandalism of 3 males of 2 whilte age 17 and 1 black age 17 4 burglary of 2 black age 16 male and 2 white male age 17 16 traffic 6 black males 17 yrs old and 10 whilte males of 6 they are 16 and 4 black males 17 years old. 10 unruly runaway of 7 female whlte 2 are 15 and 5 are 17. 3 boys of 17 black male. 
2012 is 3,292 children with 7,408 cases. 500 random sampled with every 5 cases counted and cases found recidivated is 36.

Theft 3 cases of which 2 were whilte mailes 16 and 1 15 year old female.

Burglary 3 cases of which 3 miales 16 year old black males.

Unruly 15cases of which there is 1 7 year old whilte male; 3 white females 17 year old; 6 white females 15 years old; and 5 black males 17 years old.

Disorderly Conduct 9 cases of which 5 were female White (13,14,16,16,16) and 4 Male of which were 3 black and 1 white all 15.

Domestic Assault 6 cases of which 5 were male (14,14,16,17,17) and 1 female white 17

2011 is Cases Disposed or Adjusted: 3,882 Number of cases with: 2,037 children. Couned 500 cases randomly every 5th case counted. There are27 cases that recidivated.

2 assault age 17 now white male with his first offense at 14.

9 Domestic Assaults with 6 female white of ages (15,15,16, 17,17,17 7 Disorderly Conducts 10 femaile and 7 Male.

4 Theft cases 3 white males age 16, 1 black femail age 16

5 Unruly of which 4 black males and 1 white female 13 yrs old..