Skip to main content
Create interactive lessons using any digital content including wikis with our free sister product
. Get it on the
Pages and Files
Designing a practical work.
Core Topics SL/HL
Topic 1 Statistical Analysis
Topic 2 Cells
Topic 3 Chemistry of Life
Topic 4 Genetics
Topic 5 Ecology and Evolution
Topic 6 Human Health and Physiology
Option D Evolution
Option G Ecology and Conservation
Topic 1 Statistical Analysis
Graphing with Excel Lesson Due by end of class 23rd September
Task 1: Complete the tutorial on the following website
Take a screen shot with snippet tool and paste the following on your page at this wikisite.
a. image of your scatter plot (make sure your name is visible)
b. image of your line graph (make sure your name is visible)
Task 2: Download and read the following files. Take notes where needed. You can also print them out to keep in your binder for future reference.
Rules for Graphing in Biology.docx
RULES FOR GRAPH DRAWING.docx
Task 2: Read the following and construct a complete excel graph based on the rules you have read. Paste an image of your final graph onto your page in this site. Due by 24th September
GRAPHS, WHY USE THEM?
This can be best demonstrated by means of an example.
The table opposite shows a typical response of pulse rate, measured at one minute intervals, before and after a period of exercise. Notice the table contains pure dimensionless numbers (e.g. 4 and not 4 min). The column headings contain the relevant information including the units.
Just by looking at the table you can see the pulse has increased after the 10 minute run and then returns to normal after about 10 minutes, as you might expect. Plotting a curve of these data, however, reveals an interesting phenomenon. The return to normal is not a smooth one. The pulse rate passes below its resting value several times. This overshoot is normal and it illustrates that the heart beat is under negative feedback control.
The curve gives the experimenter a global impression of the spread and the trends in these data, at a glance.
Any points which stand out as unusual are easily seen on the graph because their distance from the other points is much greater than the other data points.
A graph makes it easy to make estimates between measured points.
All this interpretation of data could have been determined from the list of readings in the table but it is a lot easier to see what is going on when the results are displayed in the form of a graph.
Your task is to create a complete graph in Excel using this data.
Complete the following practice. Also work out how to do this on your calculator. Due 7th September Wednesday
Standard Deviation Practice.docx
State that error bars are a graphical representation of the variability of data.
Calculate the mean and standard deviation of a set of values.
State that the term standard deviation is used to summarize the spread of values around the mean, and that 68% of the values fall within one standard deviation of the mean.
Explain how the standard deviation is useful for comparing the means and the spread of data between two or more samples.
Deduce the significance of the difference between two sets of data using calculated values for
and the appropriate tables.
Explain that the existence of a correlation does not establish that there is a causal relationship between two variables.
Directions on using your TI 83 Plus or TI 84 Plus for statistical analysis on Click4Biology
Click4Biology Statistical analysis notes
The T-Test, by Geoff Browne
help on how to format text
Turn off "Getting Started"