Blog Post #8 Tables and Graphs

Good afternoon Professor Elliot & Class,

It was a challenge to organize and summarize my data, but once I had figured out what the most important parts of my research were, it was easier for me to visualize them. My prediction was that there would be a greater abundance of large woody vegetation (e.g. trees) on the eastern, westerly facing side of Jack Creek.

Hypothesis: If the landscape has a higher elevation, and is westerly facing, then a greater abundance of large woody vegetation will be present.
Prediction: A greater amount of large woody vegetation will be present in western facing slopes with a higher degree of aspect and elevation.
Response Variable: Large woody vegetation abundance
Explanatory (predictor) Variable: Elevation and aspect

During my field data collection, I took counts of both trees and shrubs to create comparison. I took an average of the vegetation count to the number of data points to create an accurate representation of the data. Below are two graphs representing the average number of species in response to elevation and aspect.

Figure. 1 Average number of species is explained in response to changes in elevation. Species are divided into two groups 1. Trees (large woody vegetation) and, 2. Shrubs (small vegetation). Total is included to show linear response over the environmental gradient. In general, total number of species decreased with increases in elevation. The null hypothesis is rejected as there is a greater number of large woody vegetation with increased elevation, however, the greatest abundance of large woody vegetation occurs at an elevation of 540 MASL.
Figure 2. Average number of species is examined in response to varying degrees of aspect (North, North East, East, South East, South, South West, West, North West, and Flat). Species are divided into two groups 1. Trees (large woody vegetation) and, 2. Shrubs (small vegetation). Total is included to show linear response over the environmental gradient. A clear correlation exists between abundance of trees in westerly, south-westerly, and north-easterly facing slopes. This accurately reflects the natural landscape of Jack Creek, which flows north to south within a gully. The null hypothesis is rejected as there is a greater abundance of large woody vegetation on the westerly facing, high elevation slopes.

The outcome of my field studies was slightly different than I expected, however, it reveals that further exploration is necessary as to why there was a greater amount of vegetation in the flat meadows 15 metres on the western side of the creek. Other factors might influence the data, such as disturbance, opens fields, and amount of sunlight.

Blog post 8

The table I created was relatively easy to compile.  The greatest challenge was in choosing what not to include.

I had collected location data on my sample subject of invertebrates, which I thought to include in a table or figure in some manner.  Including this data would have added unnecessary complexity to the table or figure and the reader would be unlikely to gain any meaningful insights from knowing that a species was recorded 3m down a transect and 6cm to the East.

In graphical form, the data makes a visual statement that species were most often found in a non-vegetated location.  I had expected species to be found most often in vegetation, so the visual representation is particularly stark to me. Also with the invertebrate abundance being more or less equal between sites, it is a visual representation which I find interesting.

Post 8: Tables and Graphs

I found that a scatter graph was the best way to represent my average (mean) data, while a table was better if readers are looking for more specific data, where there is a value of species richness and insect abundance for each trap set per site. I did not have any difficulties organizing, summarizing and converting my data into an appropriate graphical representation, as I used my laptop to enter my field data directly into excel, however, I struggled to decide which representation, being either a graph or table, was the best to include in the body of my research project report. In the end, I decided to include the graph and place the table in the appendix for further reference for the readers. The outcome of the experiment, shown by the data, was relatively what I expected to see in terms of species richness, but was farther from expected in terms of insect abundance. I expected the insect abundance to be extremely high in the bird sanctuary, and then slightly to moderately decrease in the meadow and then the residential area. While the data did follow this trend, I found that the insect abundance was not as high as I expected in general, as I thought more would be present on the traps. After considering the reasons for the lower than expected abundance, I realized the type of trap used bay not be sufficient for catching all types of insects, and therefore, the actual species abundance may be higher than the experimental value. If I were to repeat this experiment or move forward with it in the future, I would use other types of traps in conjunction with the adhesive ones already used, for example; a pitfall trap, which accounts for only insects that crawl along the ground.

Blog post 8

Organizing my data into graphs was not too difficult and the data appeared to be presented most clearly in bar graph format. It may have been clearer to integrate all the data into one graph however due to the range of values and variations in units, the data was clearer to interpret when presented in two graphs.

The outcome was not as I expected, but in reflection I can understand the results. The number of ferns was greater in the shaded location compared to the sunny location which was what I predicted, however the frond size and number of fronds per crown was greater in the sunny location. I did not expect there to be a difference in frond size, or fronds per crown between sites.

One thing that I did notice that came up in my data, was that at the sunny site, the presence of ferns increased as the distance from the road increased. It was not clear if this is due to an increase in shade as the distance from the road increased, or due to the impact of the presence of the road. To further investigate this, it would be interesting to sample at locations close to the road, but with high canopy cover.

Tables and Graphs (#8)

I made several graphs in an attempt to both learn Excel and to convey multiple analyses of the data. In total I made ten usable graphs and six test graphs as learning exercises. My first two graphs assess the height and abundance of rose bushes in disturbed and undisturbed areas across gradients of light (graph 1) and moisture (graph 2). Both size and abundance appear to correlate with light, which was not surprising, but they also seem to correlate with moisture, which I wasn’t certain about as I suspected moisture and light might have an inverse relationship. My next eight graphs plot the abundance of pioneer or climax species alongside the abundance and size of rose bushes across gradients of light (graphs 3-6) and moisture (graphs 7-10) in disturbed areas (graphs 3, 5, 7, and 9) and undisturbed areas (graphs 4, 6, 8, and 10). In the disturbed area graphs, I was surprised to see that the rose bush height and abundance both tended towards an inverse correlation with abundances of pioneer species as well as climax species. With the undisturbed area graphs, the data suggests a slight correlation between rose bush abundance and both pioneer and climax species abundances, which would also be somewhat surprising, but the data is fairly noisy and I’m not sure how useful it is to read too much into it at this point.

Deciding on a graph format took some thought, along with trial and error, to convey the information in the most efficient and accessible way. For the eight graphs illustrating species relationships, I opted for multiple line graphs so that comparisons could be easily demonstrated. For the two graphs measuring height and abundance of rose bushes in disturbed and undisturbed areas across an environmental gradient, I opted for combination bar and line graphs in order to keep the height and abundance visually distinct but easily comparable. I am satisfied with the result, but I may experiment with other forms of graphs later.

*Update: the first two graphs were incorrect because of how I organised out my data tables in Excel. After correcting the errors, the graphs reveal that rose growth seems to increase with light exposure in disturbed areas and decrease with light exposure in undisturbed areas; the former follows my predictions while the latter deviates from them. Rose growth seems to increase with moisture in disturbed areas, and not much difference is seen in undisturbed areas. Consistent with my predictions, roses were generally found to be more abundant in disturbed areas.

Blog 8-Tables and Graphs

I found making a bar graph worked well to show how conifer cone totals varied with distance from the red squirrel midden.  While I followed the scholarly article’s field study protocol, I immediately noticed a difference in the harvest distances of the cones by an urban red squirrel compared to a wild red squirrel.  The article focused on a 20 meter radius because it was shown that a wild red squirrel harvests 79% of the cones for the winter midden within a 20 meter radius of its midden, while the urban red squirrel used a distance of 38 meters for cone harvesting, almost double that in the wild.  The bar graph cone totals at 38 meters matched cone totals reported in Struebel’s Alaska study at 20 meters.  I found using a bar graph did well in illuminating the cone total’s similarity to the Alaska study cone totals.  The bar graph also placed emphasis on the unique spatial relationships of planted conifer trees found on urban property.  Urban properties are unique habitats for rodentia and offer unique city and park planning schemata for horticulturalists.  The graph was simple to create but what was difficult was staying focused on one aspect of the field study when so many more intriguing avenues availed themselves.

Untitled

I chose to use a graph to display the data that I have collected. I used a line graph with two lines, one for grazing the 10 grazing replicates and one for the 10 non-grazing replicates, to show the average amounts of damage in percentage to each of the replicate areas.I chose to display it as an percentage of the overall area because I think it is easier for readers to understand and interpret. I think that the line graph I selected clearly displays the difference in damage between the two treatments and the overall trend. I did not have a difficult time organizing my data as I collected it in an excel spreadsheet so that it was quick and easy to enter equations and form graphs and tables from it. The data stayed with my predicted trend more or less, but I would be interested to explore the affect that the number of geese present grazing has on the percent of area damaged. When I first visited the site sometime ago there were only 2-3 geese grazing, but on the day I collected the 20 replicates there were 5. I’d assume that the increase in geese presence would also increase the % of area damaged.

Blog 8: Summary Table

To summarize my findings for the richness of healthy living moss found on the trunks of trees I had to use a number scale to help average out my finds to show any difference in the moss richness found on the three tree top coverage categories. Once it was decided that a tree with hardly no moss present would be given a value of zero, a tree with some healthy moss present was 0.5, and a tree with high moss richness was 1.0 it was easy to summarize the data collected.

As shown in table 1 the partial tree top exposer category showed the highest average of moss richness, this went against the prediction that moss richness would be highest at the shelter tree top group. Though it was shown that the exposed tree top group did have the lowest moss richness where it was about half the amount of the other two tree categories which supports the prediction that the exposed tree top group would have the lowest moss richness. As the data was being collected over the two weeks it was observed that the partial tree top exposer group had increased the moss richness on the tree trunk the most noticeably. Where it is thought the partial tree top exposer will have the fastest rate of increased moss richness on the tree trunks when entering the spring season in British Columbia when compared to the other two tree groups. However, more data collected over a longer time period during the late winter and spring season is needed to test this prediction.

Tree Top Exposer Total Average Moss Richness
Exposed 0.125
Partial 0.288
Sheltered 0.250
Table 1: Total average of  healthy living moss found on the tree trunks of the three tree top exposer categories. Each tree top category contained ten replicates where date was collected four times at each site over the spanned of two weeks. A number value of 0.0, 0.5, and 1.0 was used to stand for no moss richness, some moss richness, and high moss richness found on each of the tree trunks respectively.

Tables and graphs

For my project I have decided to use graphs to represent a summary of my raw data. Because of my statistical tests used, I created a graph that shows the mean number of brush bushes per square meter at various elevations from the creek bottom. This graph shows the differences between the six elevations I compared.  When analyzing my data, I decided to remove the highest 6m counted because I only had ~6 samples. This made my comparisons a lot more representative of the un-paved study area. I used a bar graph, and feel like this is the best way to visually represent how the density of brush bushes changes as the height from the creek increases.

I will also include a table denoting the significant differences between elevation categories for the big sagebrush bushes. There were no significant differences in the rabbitbrush bushes across the different elevations, so I will just report that in my results section.

This data took me a long time to go through and figure out how best to analyze it. I chose an ANOVA over t-tests because they are a more powerful statistical test. I also compared the valley bush distribution to a Poisson distribution.

Blog Post 8: Tables and Graphs

The table I created included all of the data I collected over the five days. It was a summary of the various bird species abundance at each of the study sites. By producing a graph that summarizes all of the data collected, it enables for trends and patterns to be clearly outlined to draw conclusions from. However, from this data I found it to be confusing how to incorporate it into a graph to obtain a more visual demonstration of the species abundance over the three different sites.

Nevertheless, I noticed that each study site had different bird species associated with it. More specifically I noticed that each study site had a dominant species that inhabited the area. This was the outcome I was expecting, however, that leads to further questions such as why particular bird species favour one site over another? What is different about each site that a spatial gradient is created?

As a secondary research project it would be interesting to monitor the bird species and their migration patterns. Since the seasons are in the midst of changing the species abundance at each of the sites must also be changing; therefore, it would be interesting to determine which site the bird species favour as their migration patterns change. In addition, it would be interesting to see the displacement of the bird species as new birds migrate into the area. I’m assuming that depending on the bird species the migration patterns are different; therefore, if a smaller bird favoured a particular site it would be interesting to observe what would happen if a larger bird slowly started to inhabit the area.