statistics

profile123456
homework_1.docx

Student Name:____________________

Worked with:_____________________________________________________________

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.12 (modified)

The city manager of Snook, Texas, wants to generate some statistics on a voluntary free flu shot clinic for city employees. Specifically, she has the following data on her employees, including whether employees received shots and whether they took sick leave during the winter months:

Gender

Department

Age

Received Shot

Took Sick Leave

Female

Budget

33

Yes

No

Male

Fire

26

No

Yes

Female

Parks

41

No

Yes

Female

Budget

38

Yes

No

Male

Police

52

Yes

Yes

Male

Parks

24

Yes

No

Female

Police

47

No

No

Female

Fire

65

Yes

No

Male

Fire

50

Yes

No

Female

Parks

39

No

Yes

The city manager asks you to come up with a numerical coding scheme so that these data can be placed in a statistical program for analysis.

(a) Develop a coding scheme for Gender.

(b) Develop a coding scheme for Department.

(c) Develop a coding scheme for Age.

(d) Develop a coding scheme for Received Shot.

(e) Develop a coding scheme for Took Sick Leave.

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 concept that the director wants to measure?

(b) What is the indicator that the director is proposing to use to measure that concept?

(c) What level (interval, ordinal or nominal) of indicator is the number of clients served?

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

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

(f) 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.

(g) 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.6 (modified)

The city clerk has received numerous complaints over the past year that couples applying for a marriage license have to wait too long to receive one. Although the clerk is skeptical (couples applying for a license are usually young and impatient), she pulls a representative sample of marriage licenses issued in the past year. Because a machine stamps each license application with the time the application is received and the time it is issued, she can tell how long the young (and old) lovers had to wait for the marriage license. The clerk considers service received in less than 10 minutes good and service received in less than 15 minutes acceptable. Her sample of license data is as follows:

Couple Number

Minutes Waited for License

1

13

2

6

3

21

4

28

5

4

6

18

7

7

8

26

9

12

10

16

11

23

12

17

13

23

14

11

15

3

16

14

17

25

18

15

19

9

20

19

21

24

22

10

23

15

24

4

25

27

26

17

27

5

28

20

29

13

30

16

(a) Prepare the frequency distribution for these data.

(b) Prepare the percentage distribution for these data.

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

(d) Prepare a histogram for these data.

(e) Which of these presentations is most useful for the city clerk? What should the city clerk conclude? Explain your answers in a few sentences. (You do not have to write a memorandum, as in the original MBB problem.)

4. MBB Problem 5.12 (modified)

The head of the Data Processing Department in Springhill wants to estimate the amount of waste and inefficiency in her department. She conducts a survey of employees in the department. One question asks, “To what extent does this department have waste and inefficiency in its operations?” The responses to the item are given in the accompanying table.

Response

Number of

Employees

To a very great extent

42

To a great extent

31

To a moderate extent

19

To some extent

12

Not at all

7

(a) At what level of measurement are these data?

(b) Calculate the percentage distribution.

(c) Calculate the appropriate measures of central tendency.

(d) According to these data, does the department appear to have a problem with waste and inefficiency? Explain your answer in a few sentences.

5. MBB Problem 6.10 (modified)

The director of the South Bloomington YMCA has become concerned about the health of the organization’s employees. He issues a directive to all YMCA sites advising all managers to encourage employees to get at least 60 minutes of exercise per day. Following are the data on the number of minutes exercised per day (on the average) by the 10 employees of the South Bloomington YMCA site:

75 20 15 95 30 100 40 10 90 120

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

(b) How well do these employees meet the standard for exercise recommended by the director of the YMCA? Explain your answer in a few sentences.

6. MBB Problem 6.18 (modified)

The director of the Madison County jail is planning to testify before the Wisconsin state legislature with the goal of obtaining more state funds for the county jail system. In preparing his remarks, the director plans to present data on the average number of days that prisoners remain in jail. The director believes that his case will be more compelling if he can show that the average stay for prisoners is greater than 21 days. The director asks you, as chief operations officer for the jail, to calculate descriptive statistics for a random sample of 250 prisoners processed in the last 9 months. (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 director about his 21-day target? Explain your answer in a few sentences.

5