Laboratory Exercise - Descriptive Statistics and Graphing

Campus students should answer the questions below on the answer sheet. Online students should return to the learning modules to submit answers to these questions.

Some of the questions require you to create graphs. Online students should insert the graphs in the document that contains their answers. In Word 2003 and earlier (and most other word processors), this can be done by clicking Insert, Picture, From File, then browse for the file. In Word 2007 click Insert, Picture, then browse for the file.

1) Explain why a bar graph is used for the mammal data. (See Bar Graphs in the reading assignment for this lab.)

2) Explain why a line graph is used for the pH data. (See Line Graphs in the reading assignment for this lab.)

3) Explain why a scatter plot is used for the bird species data. (See Scatter Plots in the reading assignment for this lab.)

4) Suppose that a researcher was interested in how long it takes people to recover after exercise. She asked five test subjects (people) run for 30 minutes on a treadmill and then measured the amount of time that it took for the heart rates to return to normal. A) What kind of graph would be most useful for plotting the recovery time of each person? B) Why?

5) Calculate the mean, median and mode for the pH data (line graph data). Use 3 significant digits for the mean and the median. (See Significant Digits in the reading assignment for this lab.)

6) Which measure(s) of central tendency do you think is (are) best to use for the pH data? Explain your answer to this question. (See Measures of Central Tendency in the reading assignment for this lab.) 

7) Which measure(s) do you think are the worst for the pH data? Explain your answer to this question. (See Which to Use? Some Disadvantages of Each in the reading assignment for this lab.)

8) Calculate the mean number of mammals and the standard deviation for the mammal data (the bar graph data). Show all of your work. Your answer should contain 3 significant digits.

9) Calculate the mean number of bird species in the scatterplot data. Use the Excel spreadsheet provided to calculate the standard deviation. If you are asked for a username and password, click "Cancel." Write your answers on the answer sheet using 3 significant digits. You must have Excel installed on your computer to use the Excel spreadsheet. If you do not have Excel or Office installed, you can down a free Excel 2003 viewer from Microsoft at the following link: http://www.microsoft.com/downloads/details.aspx?FamilyID=1cd6acf9-ce06-4e1c-8dcf-f33f669dbc3a&DisplayLang=en.

10) Create three graphs, one for each of the data sets below. Use either Create A Graph or Excel. If you do not have Excel installed on your computer, you must use Create A Graph. 

Instructions for using Create A Graph

Create A graph

Instructions for creating graphs using Excel

Data set A - The data below are the number of different species of insects captured in four different oldfields on July 18, 2007. Sampling was done between 10:00 and 11:30 AM. Each field was an abandoned hayfield that had not been mowed for four years.

          Field A - 37 species

          Field B - 25

          Field C - 17

          Field D - 15

Data set B - This information is the temperature in Plattsburgh, New York on January 21, 2008. All of the temperatures are negative (below 0 centigrade or below 32 fahrenheit).

          1:00 AM: -16.1 degrees centigrade

          5:00 AM: -18.3 degrees C

          9:00 AM: -13.3 degrees C

          1:00 PM: -6.7 degrees C

          5:00 PM: -8.3 degrees C

          9:00 PM: -9.4 degrees C

Data set C - The data below show the body weight of 6 rats given different amounts of growth hormone. Create a line graph of the data. If you use Create A Graph, select XY graph for this data set.

          1) hormone: 0.15 mg     body weight: 29.5 g

          2) hormone: 0.20 mg     body weight: 29.3 g

          3) hormone: 0.25 mg     body weight: 32.0 g

          4) hormone: 0.30 mg     body weight: 35.1 g

          5) hormone: 0.35 mg     body weight: 23.6

          6) hormone: 0.45 mg     body weight: 19.2

This graph is not a scatterplot. The points should be connected with a line.

The minimum and maximum values of your X and Y axes should be adjusted so that the data points use most of the space. For example, in data set C above, the body weights vary from 19.2 g to 35.1 g. Make the minimum value for this axis something less than 19.2. Values of 15, 18, or 19 might be good. The maximum value on the axis should be slightly greater than the largest data point (35.1); 36 or 40 might be good for this.

Do not forget to include units when labeling the axes. For example, if one axis is Body Weight, you should indicate that the units are grams: Body Weight (g).