BIOL 1107L Graphing with Excel Take a few minutes to study the data on the Excel spreadsheet. Try to pick out any overall trends or make conclusions based on what you see. What conclusions can you make, or trends can you identify from simply looking at the data (if any)? -
Based on the data, there was a higher number of tornadoes in the year 1952 up until May. However, the data is not a consistent number or increase, it is a variety that is going to be plotted by going up and down and not consistent. When you have collected data from an experiment in a lab course or in your research lab, you will not always know what kind of trend(s) you may see. You might have an expectation, but it is not always apparent what kind of information you will gain from any given data set. You will not always know what kind of graph to generate, or how you may need to edit your data to see some kind of trend that will be informative. The best way to approach this scenario, is to generate a few different graphs from your data that will represent your data in different ways, in the hopes that you will see some sort of trend that you can explore more deeply. 1.
Make a line graph with number of tornadoes on the y-axis, and month on the x-axis. There should be a line on the graph for each year. It should be titled -
Number of Tornadoes Per Month From 1950-1952. (1 pt)
a.
Describe any patterns or trends you see in the data based on the graph. (2 pts)
-
There are no consecutive patterns or trends in this data based on the graph. However, they all follow kind of the same direction of increasing and decreasing except for some few spots. It increases and decreases in similar months, but some have a higher increase
or decrease. 2.
Calculate the average and standard deviation for the number of tornadoes for each year
and
for the total number of tornadoes each month
. Columns and rows are highlighted in
red where you should do the calculations. Calculate these using the equations in Excel. (1 pt)
3.
Make a bar graph for the “Average Tornadoes Per Year for 1950 – 1952”. (1 pt)
a.
Describe any patterns or trends you see in the data based on the graph. (1.5 pts)
-
Based on this graph, you can interpret that there was an average of more than fifteen tornadoes in the years of 1950, 1951, and 1952. Most clearly though is that the year of 1951 had the highest of average tornadoes per year with about twenty-two tornadoes. 4.
Make a bar graph for the “Average Tornadoes Per Month From 1950 – 1952”. (1 pt)
