Topic 1 Statistical Analysis

Graphing with Excel Lesson Due by end of class 23rd September

Task 1: Complete the tutorial on the following website
http://www.ncsu.edu/labwrite/res/gt/graphtut-home.html
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: 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

 Assessment statement Obj Status 1.1.1 State that error bars are a graphical representation of the variability of data. 1 1.1.2 Calculate the mean and standard deviation of a set of values. 2 1.1.3 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. 1 1.1.4 Explain how the standard deviation is useful for comparing the means and the spread of data between two or more samples. 3 1.1.5 Deduce the significance of the difference between two sets of data using calculated values for t and the appropriate tables. 3 1.1.6 Explain that the existence of a correlation does not establish that there is a causal relationship between two variables. 3
Directions on using your TI 83 Plus or TI 84 Plus for statistical analysis on Click4Biology

Click4Biology Statistical analysis notes