1107LWK3DataRameshA

docx

School

University of the Fraser Valley *

*We aren’t endorsed by this school

Course

1107L

Subject

Biology

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by advikaramesh

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)? 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) Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 0 10 20 30 40 50 60 70 80 Number of Tornadoes Per Month From 1950-1952 1950 1951 1952 Month Number of Tornadoes a. Describe any patterns or trends you see in the data based on the graph. (2 pts) There is an average decline between all of them from June on, and they mostly reach a peak in the middle months.

BIOL 1107L Graphing with Excel 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) 1950 1951 1952 0 5 10 15 20 25 Average Tornadoes Per Year for 1950 – 1952 Year Average Tornadoes a. Describe any patterns or trends you see in the data based on the graph. (1.5 pts) There does not seem to be any pattern there. 4. Make a bar graph for the “Average Tornadoes Per Month From 1950 – 1952”. (1 pt) Jan Feb Mar Apr May June July Aug Sept Oct Nov Dec 0 10 20 30 40 50 60 Average Tornadoes Per Month From 1950 – 1952 Month Average Tornadoes a. Describe any patterns or trends you see in the data based on the graph. (1.5 pts) The graph seems to be making a bell-curve shape.

BIOL 1107L Graphing with Excel 5. Which of the graphs created do you feel is the best representation of the data and is the most informative overall and why? (1 pt) The best representation graph seems to be bar graph for the average tornadoes per month from 1950 – 1952. It shows a concise way of showing the data without giving too much detail. The data is much easier to view in this format. The most informative would be the line graph because it shows every single data point.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Screen Shot 2023-12-17 at 6.03.14 PM.png

Homework Assignment #6-Calculating Stand Attributes from Variable Radius Sampling.docx

Part I-Jigsaw activity Class Copy-08.docx

1107LWk8RameshA.docx

1107LWk11GIRameshA.docx

1107LWk9RameshA.docx

Quiz #1.pdf

a&p quiz #2 ch. 3&4.pdf

quiz ch 5&6.pdf

CHAPTER 4 EXTRA CREDIT SCG.docx

MBIO Lab Report #2.pdf

MBIO Lab report 1.pdf

Recommended textbooks for you

Human Heredity: Principles and Issues (MindTap Co...

Biology

ISBN:9781305251052

Author:Michael Cummings

Publisher:Cengage Learning

Science Of Agriculture Biological Approach

Biology

ISBN:9780357229323

Author:Herren

Publisher:Cengage

Biomedical Instrumentation Systems

Chemistry

ISBN:9781133478294

Author:Chatterjee

Publisher:Cengage

Principles Of Pharmacology Med Assist

Biology

ISBN:9781337512442

Author:RICE

Publisher:Cengage

Biology 2e

Biology

ISBN:9781947172517

Author:Matthew Douglas, Jung Choi, Mary Ann Clark

Publisher:OpenStax

Biochemistry

ISBN:9781305577206

Author:Reginald H. Garrett, Charles M. Grisham

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Human Heredity: Principles and Issues (MindTap Co...
Biology
ISBN:9781305251052
Author:Michael Cummings
Publisher:Cengage Learning
Science Of Agriculture Biological Approach
Biology
ISBN:9780357229323
Author:Herren
Publisher:Cengage
Biomedical Instrumentation Systems
Chemistry
ISBN:9781133478294
Author:Chatterjee
Publisher:Cengage
Principles Of Pharmacology Med Assist
Biology
ISBN:9781337512442
Author:RICE
Publisher:Cengage
Biology 2e
Biology
ISBN:9781947172517
Author:Matthew Douglas, Jung Choi, Mary Ann Clark
Publisher:OpenStax
Biochemistry
Biochemistry
ISBN:9781305577206
Author:Reginald H. Garrett, Charles M. Grisham
Publisher:Cengage Learning