Statistics

profile123456
homework_1.docx

Please explain your work, including which functions you used in Excel – do not just write the answers. Also, just to be clear, it is my understanding that the solutions to the even-numbered problems in MBB are not available anywhere to students. But if you should happen to find them somewhere, you are not allowed to consult them on this assignment.

1. MBB Problem 2.10 (modified)

The director of the West Arbor Senior Center decides to put together a database on the center’s activities. The center currently takes written records of services provided to clients, but the director feels that program information will be easier to access and analyze if the records are computerized. The program director generates the following sample data for 10 current clients:

Service Provided

Gender

Age

Neighborhood

Home Delivery of Meals

Assistance with Transportation

Male

64

West Side

Yes

Never

Female

71

North Side

Yes

Frequently

Female

37

South Side

No

Never

Male

58

North Side

No

Rarely

Female

74

West Side

Yes

Never

Male

52

East Side

Yes

Rarely

Male

77

South Side

Yes

Frequently

Female

82

West Side

No

Never

Male

68

North Side

Yes

Never

Female

76

East Side

No

Frequently

The director asks you to develop a measurement scheme and turn the data into numbers that can be put into a computerized database.

(a) Develop a coding scheme for Age.

(b) Develop a coding scheme for Neighborhood.

(c) Develop a coding scheme for Home Delivery of Meals.

(d) Develop a coding scheme for Assistance with Transportation.

2. MBB Problem 3.4 (modified)

For the entire month of January 2014, the local domestic violence shelter ran a series of ads on the government access cable television channel. The director of the shelter hypothesized that the ads would bring more attention to the problem of domestic violence and make victims of domestic violence more aware of the shelter’s programs. The director has monthly data on the number of new clients. At the end of April 2014, the director asks you to come up with a research design to help assess whether the ads had an effect on the number of clients served.

(a) What is the independent variable in the director’s hypothesis?

(b) What is the dependent variable in the director’s hypothesis?

(c) The number of clients served is an indicator. What is the concept that indicator is used to measure?

(d) What type of research design (experimental or quasi-experimental and, if quasi-experimental, cross-sectional, case, panel, trend or mixed) would you use to test the hypothesis? Explain your answer in a few sentences.

(e) The director has monthly figures for the number of clients served in 2013. Are these data relevant for testing the above hypothesis? If so, why? Explain your answers in a few sentences.

3. MBB Problem 4.8 (modified)

Because of cutbacks in agency funding, the United Way of Megopolis has had to cut back on routine maintenance of its computer terminals. (The equipment is made by the Indestructible Computer Company.) The head of the agency is concerned that the agency will face a major equipment crisis this year because the recommended maintenance schedule for the terminals is once every 36 months. In an effort to obtain more funding from the state legislature, the agency chief compiles the following data for the 25 terminals that it owns. The data show the time since the last routine maintenance of the terminal or, if the terminal was purchased in the last 24 months, the time since the terminal was purchased.

Terminal Number

Months Since Last Maintenance

1

14

2

38

3

33

4

9

5

19

6

56

7

11

8

23

9

64

10

6

11

13

12

28

13

51

14

16

15

41

16

5

17

29

18

18

19

3

20

21

21

44

22

34

23

15

24

26

25

18

(a) Prepare the frequency distribution for these data.

(b) Prepare a cumulative percentage distribution for these data.

(c) Prepare a histogram for these data.

(d) Will these data help the agency chief persuade the state legislature to give the agency more funding? Explain your answer in a few sentences. (You do not have to write a memorandum, as in the original MBB problem.)

4. MBB Problem 5.14 (modified)

The head of a city’s Recreation Department feels that the employees of the department are the best in the city. Each year, all city employees receive a standardized performance evaluation that rates them on a scale of performance. The department head feels that his assessment of employees will be justified if at least 90% of them fall into the top two categories. The ratings received by department employees are shown in the accompanying table.

Rating

Number of

Employees

Far above expectations

19

Above expectations

44

Meets expectations

51

Below expectations

9

Far below expectations

8

(a) Calculate the percentage distribution.

(b) Calculate the appropriate measures of central tendency

(c) What can you tell the head of the Recreation Department? Explain your answer in a few sentences.

5. MBB Problem 6.12 (modified)

The Mississippi State Penitentiary is concerned about the number of violent incidents in its prisons. After examining the eight prisons in the Mississippi system, a data analyst finds the following data for the number of violent incidents last month:

21 28 29 27 64 23 24 22

(a) Calculate the mean, median, mode and standard deviation for these data.

(b) Should the penitentiary warden use the mean or the median in its analysis? Explain your answer in a few sentences.

6. MBB Problem 6.16 (modified)

The Fowlerville, California, Department of Emergency Services is concerned about whether response times to 911 calls are within what the chief regards as an acceptable range. The head of emergency services has her intern collect data on response times for the most recent one hundred 911 calls. The head feels that average response times should be no greater than 5 minutes because Fowlerville is a relatively small community (in both population and geographic size). (Note: The data set for this problem is posted on Blackboard.)

(a) Calculate the mean, median, mode, and standard deviation for these data.

(b) What can you tell the head about response times? Explain your answer in a few sentences.

1