Quantitative methods and statistical analysis

¶ … excel spreadsheet to show your work - if I can't see how you got a particular answer you will get a zero.

I will allow you to resubmit this assignment. Please understand that this is the last assignment I will allow you to resubmit. Going forward you will have to take the grade you get.

M2A1: CENTRAL TENDENCY AND VARIABILITY

Sonja Myles

Piyusha Singh

M2A1: CENTRAL TENDENCY AND VARIABILITY

M2A1: CENTRAL TENDENCY AND VARIABILITY

M2A1: CENTRAL TENDENCY AND VARIABILITY

Instructions: 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.

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

Offense

J.D.

Male

High school

Homicide

G.T

Male

No high school

Drugs

T.J.

Male

High school

Drugs

R.T.

Female

Drugs

P.M.

Female

Drugs

J.D.

Male

No high school

Homicide

H.W.

Female

No high school

Burglary

L.B.

Female

Drugs

H.K.

Male

Burglary

R.T.

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, 33

1. Find the mode. 10

1. Find the median. 14

1. Find the mean. 17

1. Which measure provides the most accurate measure of central tendency for the number of homicides? (Write this answer in the Word document.)

Generally, the mean would provide the most accurate measure of central tendency for the number of homicides because it averages homicide risk. The mode would be a bad measure because the most frequently occurring number is also the lowest number.

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 B

25

15

10

12

44

11

9

10

8

13

12

12

11

13

44

15

Considering both concepts of central tendency and variability find the following:

1. Which precinct tended to work more overtime?

Precinct A tended to work more overtime, with a much higher mean of overtime hours, 20.375 compared to Precinct B's 12.625 hours.

1. Which precinct tended to be more consistent in the number of hours of overtime work?

Precinct B. tended to be more consistent in the number of hours worked, with a standard deviation of 1.77 hours compared to Precinct A's standard deviation of 15.519. .