Central Tendency and Variability

      Complete the following questions. Enter answers and explanations in this document. Show calculations in the Excel file, using a separate worksheet (tab) for each question.1. The table shows socioeconomic characteristics of parolees who report to one parole officer. Calculate the most appropriate measure of central tendency for each of the variables: Age, Sex, Education, and Offense.Initials Age Sex Education OffenseJ.D. 34 Male High school HomicideG.T 18 Male No high school DrugsT.J. 25 Male High school DrugsR.T. 43 Female Some college DrugsP.M. 22 Female Some college DrugsJ.D. 24 Male No high school HomicideH.W. 26 Female No high school BurglaryL.B. 28 Female College DrugsH.K. 55 Male College BurglaryR.T. 23 Male No high school Burglary 2. The number of homicides in a U.S. city during a 5-month period are: 10, 18, 10, 14, 33a. Find the mode.b. Find the median.c. Find the mean.d. Which measure provides the most accurate measure of central tendency for the number of homicides? (Write this answer in the Word document.)3. The number of prior arrests for a group of individuals at their parole hearings are as follows: 1, 3, 3, 2, 1, 8, 5. Compute the following: (a) range, (b) variance, and (c) standard deviation.4. In order to examine whether precincts need more sworn officers, you have collected data on the total number of hours of overtime per week worked by police officers in two precincts for a period of 8 weeks. The table shows the data.Precinct A Precinct B25 1510 1244 119 108 1312 1211 1344 15Considering both concepts of central tendency and variability find the following:a. Which precinct tended to work more overtime?b. Which precinct tended to be more consistent in the number of hours of overtime work?Please explain the reasoning behind your answers and how you arrived at your answer. Please include your calculations in the Excel worksheet.