Sample Results

In order to recreate our experiment, you’ll need four graphs; one for clay, one for silt, one for a clay silt composite, and one for sand. We found that categorizing data and making your graphs is easiest in Microsoft Excel.

This is how we set up our final chart:

As you can see, the chart is set up with 7 columns: Trial, Sample Site, Clay, Silt, Clay Silt Composite Sand, and # of Earthworms. Make sure that all the data is set up correctly, keeping the correlating data together (i.e. trial #1, S2 Q1 clay and silt should match up).

The Early Birds’ How-To on Making Graphs in Excel:

  1. Enter your data into your charts
  2. Select the data you want your graph to have (i.e. clay and earthworms)*TIP* you may have to rearrange your data to place the two categories next to one another while you are making a certain graph
  3. Click INSERT on the menu bar
  4. Select the scatter plot icon
  5. Choose the scatter plot without lines on the drop-down menu
  6. At this point, the graph should appear
  7. Rename the graph
  8. Click on the graph until a green + appears and click it
  9. Check off both AXIS TITLES and TRENDLINES
  10. Hover over TRENDLINE until a drop down menu appears
  11. Click MORE OPTIONS
  12. Scroll until you see the options DISPLAY EQUATION ON CHART and DISPLAY R-SQUARED ON CHART and check off both

Here is the data gathered for our experiment:

Earthworms and Clay Content Percentage:

Earthworms and Clay Silt Composite Percentage:

Earthworms and Silt Content Percentage:

Earthworms and Sand Content Percentage:

Sites with the Highest Worm Populations: