ODWS icon

The Open Door Web Site
HOMEPAGE BIOLOGY HOMEPAGE CHEMISTRY PHYSICS ELECTRONICS HISTORY HISTORY OF SCI & TECH MATH STUDIES LEARNING FRENCH STUDY GUIDE  PHOTO GALLERY
IB BIOLOGY HOMEPAGE TOPIC CHAPTERS SCIENTIFIC INVESTIGATIONS DRAWING IN BIOLOGY DRAWING TABLES ERROR ANALYSIS IN BIOLOGY ALL ABOUT GRAPHS STATISTICS SCIENTIFIC POSTERS MOLECULAR IMAGES
WS

 

Going Further with Graphs Index

Trend Lines
Calculating Slopes
Error Bars Showing Precision
Error Bars Showing Standard Deviations
Entering Error Bars on a Scatter Plot

ICT in Biology Index

Using MS Excel as a Calculator
Using MS Excel as a Database

IB Biology Homepage

Note about this Tutorial

This tutorial has been updated. It was originally published using Excel 2003. The new images are screenshots from Excel 2013.

There may be very slight differences for those of you using Excel 2016 but, essentially, the layout is much the same as Excel 2013.

Download the Excel Data File used for this tutorial to practice with

Excel icon

DerivedFile.xlsx

 

Graph01

Graph08

Graph02

Graph03

Graph04

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 : Going Further with Graphs

Plotting derived data

The previous investigation can be extended to determine the rates of photosynthesis at other concentrations of hydrogen carbonate solution.

Table

The graph of each concentration needs to be inspected to determine where the slopes should be calculated (see left).

The slopes are then calculated for each of the concentrations.

Graph05

 

Table02

The number of decimal places is corrected.

Table03

A graph is then drawn of this derived data and trend line is fitted to it.

Graph06

Notice the data for 0.0125 mol dm-3 shows some divergence from the trend line. When the data is analysed it reveals that it is not very consistent. This is an indication that the experiment with this concentration should be repeated or it may be rejected. If rejected it would give a graph like the one below.

Graph07

 

Next : Error Bars Showing Precision

 

The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.

Donate to the Open Door Web Site using PayPal

SITE MAP
WHAT'S NEW?
ABOUT

PRIVACY

COPYRIGHT

SPONSORSHIP

DONATIONS

ADVERTISING

© Paul Billiet 2018
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock