Stats 2400, Technology Team Project                       Names _____________________________

R. Sinn, Spring 2009                                                  

                                                                                                _____________________________

Project Tasks

·                     Team Building: Learn how to work with your teammates on a low stress project to prepare for the next, much bigger project.  Get each other’s cell numbers, email and other contact points along with “best times to call.”  Practice setting deadlines for completed tasks and emailing files to one another.

·                     Reading Directions: Your grade in all classes will be improved if you learn to read directions carefully. Part of this project is learning to digest written directions. If you have questions, discuss them with teammates before asking me.

·                     Format: Complete all 9 problems below. The answers for problems 1 – 3 should combined into a single Excel file with a separate worksheet page for each problem.  For problems 4 – 9, create a single Word document with text reporting your results for graphing calculator problems and pasting in graphics and tables for the CrunchIt problems.

·                     Graphics: You may use bar graphs or histograms, but there are bonus points for figuring out how to make “near” histograms in Excel (i.e. set gap width to zero).

·                     Numerics: The major Excel formulas you will use are “=Average(datalist),” “=Median(datalist)” and “=StDev(datalist)” where the data list is selected by using the mouse.

·                     Turn In: Team leader should email completed work to Dr. Sinn by the due date. Subject line should read: “Stats 8 AM, Tech Proj, Team 4,” with your team number and the start time of your class modified appropriately.

 

Directions, Problems 1 - 3: Enter and analyze the following data sets in Excel.  You should complete all of the following steps.

a.            Make a frequency table by choosing categories (or bins) and tabulating the frequencies for each. Create a relative frequency table, too.

b.            Make a relative frequency bar graph and/or histogram.

c.            Discuss the shape of the data set. Is it approximately normal?  If so, is it symmetric or skewed?  If skewed, which direction, left or right?

d.            Calculate the mean, median and standard deviation.

e.            Do you believe the mean is greater than, approximately equal to or less than the median?

f.             Based upon part (e) discuss whether the data set is likely to have outliers, and why you think so.

 

1.            Promiscuous Raccoons: Researchers monitored the courtship of mating raccoons in southern Texas during 3 mating seasons in an effort to describe mating behavior.  Twenty-nine female raccoons were observed, and the number of male partners during the time the female was accepting partners (generally 1 – 4 days per year) was recorded for each female.  The resulting data were as follows:

 

1

2

3

1

1

4

2

4

1

1

1

3

1

1

1

1

2

2

1

1

4

1

1

2

1

1

1

1

3

 

 

2.            [Difficulty: moderate for part d] Criminology researchers reported the number of prior convictions for nearly 300 adult males arrested for felony offenses:

 

Prior Convictions

0

1

2

3

4

5

6

7

8

9

10

11

Frequency

0

16

27

37

46

36

40

31

27

13

8

2

 

3.            Researchers studied electronic pacemaker implantations in nearly 90 heart patients.  The researchers recorded the time (in months) from implantation until the first electrical malfunction was detected:

 

 

24

20

16

32

14

22

2

12

24

6

10

20

8

16

12

24

14

20

15

14

16

18

20

22

24

26

28

18

14

10

12

24

6

12

18

16

34

18

20

22

24

26

18

2

18

12

12

8

24

10

14

16

22

24

22

20

24

28

20

22

26

20

6

14

16

18

24

18

16

6

16

10

14

18

24

22

28

24

30

34

26

24

22

28

30

22

24

22

32

 

 

 

Directions, Problems 4 - 6: Enter and analyze the following data sets using a TI-83/84 graphing calculator.  Please input your responses as text in the Word Document file with the rest of your work.  You should complete all of the following steps.

 

a.            Enter the data into your calculator’s List Editor.

b.            Compute a “Basic Data Table” and a “5 Number Summary.”

c.            Check for outliers using the appropriate Box-Plot.

d.            List the mean, median, range and standard deviation of the data set.  Is the mean different than the median relative to the standard deviation?

e.            Without making a histogram or stem-and-leaf plot, tell whether you think data is skewed left, skewed right or neither and explain your reasoning.

 

4.            An office supply company that makes deliveries has a fleet of 100 trucks.  For a certain month, management select 18 of the trucks and checks the miles driven.  Data is given below in hundreds of miles.

 

27

18

29

34

45

49

38

25

27

30

29

30

39

22

23

30

23

20

 

5.            Researchers conduct a household survey in a certain community asking, among other things, “number of rooms per dwelling unit.”  The following table shows the results.

 

3

2

4

4

1

6

3

6

6

6

7

6

5

7

5

2

7

5

4

6

8

4

5

7

4

3

6

6

4

3

6

5

5

6

7

6

5

5

2

5

8

6

6

3

7

7

7

5

6

1

5

6

5

4

3

4

3

6

5

4

 

 

6.            The Connecticut Agricultural Experiment Station conducted a study of the calorie content of the different types of beer.  The calorie contents (calories per 100 ml) for 26 brands of light beer are given below (data from brewery.org):

 

29

28

33

31

30

33

30

28

27

41

39

31

29

23

32

31

32

19

40

22

34

31

42

35

29

43

 

 

Directions, Problems 5 - 9: Navigate in StatsPortal and CrunchIt to the correct data sets. Generate the output and copy-past into a Word document. Answer each question below based on your results. You should complete all of the following steps.

 

a.            Compute a “Basic Data Table” and a “5 Number Summary.”

b.            Check for outliers using the appropriate Box-Plot.

c.            Make a histogram. Be sure to state how you selected the “bin width” and the starting point for each bin.

d.            Based on part (a), is the mean significantly different than the median relative to the standard deviation?

e.            Sort the data, and check for outliers numerically using z-scores.

 

7.            Use the data set for Chapter 18, exercise 26.

 

8.            Use the data set for Chapter 18, exercise 27.

 

9.            Use the data set for Chapter 18, exercise 38.

 

 

Directions, Problem 10: Enter and analyze the following qualitative data set in Excel.  You should complete all of the following steps.

 

a.            Make a relative frequency table.

b.            Make a pie chart.

c.            Make a relative frequency bar graph.

 

 

10.          In a survey, business executives were asked to specify the primary activity of their firm.  Their results are given below.

 

Primary Business Activity

Frequency

Transportation

8

Utilities

3

Manufacturing

15

Communications

10

Other

4