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) to 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 and median for the pH data (line graph data). Use 3 significant digits for your answer. (See Significant Digits in the reading assignment for this lab.)

6) Which measure(s) of central tendency do you think is (are) good to use for the pH data? Explain your answer to this question. (See Measures of Central Tendency and Which to Use- Some Disadvantages of Each in in the reading assignment for this lab.) ) When answering this question, students often say that the data have a bell-shaped curve. However, in order to know if the data have a bell-shaped curve (normal distribution) you would need to plot the number of observations on the Y-axis and pH on the X-axis. If you do this, you will discover that the data are not bell-shaped at all; they are not even close. For purposes of this exercise, lets assume that the data are normally distributed and the lack of a bell-shaped curve is due to the small sample size of numbers. Click the link above for the answer to this question.

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

Follow these step-by-step instructions for entering these data (below) into Create A Graph.

          Field A - 37 species

          Field B - 25

          Field C - 17

          Field D - 15

The title of your graph should provide the reader with enough information so that the reader knows exactly what the graph is. This usually requires several sentences. The words "Data set A" are not enough. 

Be sure that both axes of your graph are labeled. The reader needs to know what the numbers are.

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 (Don't forget the negative sign!!!)

          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

NOTE- Be sure to put a negative sign in front of the numbers when you enter them into a graphing program because these temperatures are below zero.

When you plot the temperature data on the Y-axis, the smallest number (-18.3) should go near the bottom of the graph. the largest number (-6.7) should go near the top.

Be sure that the graph has a detailed title and that both of the axes are labeled. The reader needs to know that the temperature is recorded in degrees Centigrade.

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.

Be sure to label the axes. The reader needs to know that the amount of hormone is recorded in milligrams (or mg) and that body weight is recorded in grams (or g).

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