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
Plotting Derived Data
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

SlopesFile.xlsx

 

 

Using MS Excel to determine rates from a graph

Biological processes are often analysed by comparing their rates. That is the speed at which they progress.

Often the rates of the reactions are not constant. Living organisms need time to acclimatize to the experimental conditions or reactions may slow down as substrates are used up. The fastest rate or the most uniform rate can be determined by inspecting a graph.

 

 

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 : Going Further with Graphs

Calculating Slopes

The graph below shows the results of an experiment where a water plant was given sodium hydrogen carbonate (a source of dissolved carbon dioxide). The plant was left for 10 minutes in a constant light source in a closed test tube. A pressure sensor measured the build up of oxygen gas as a measure of the rate of photosynthesis.

It can be seen from this graph that the increase in pressure due to the build up of oxygen takes 5 minutes before it starts to give consistent results. So by inspection the slope will be calculated from the readings between 5 and 10 minutes.

The slope of a line can be calculated in Excel using the slope function.

Select a cell and click on the Functions menu. Choose More functions

Graph01

From the menu select Slope (you may have to type SLOPE in the Search for a Function box).

Graph02

A dialogue box will appear into which you must put the series of x and y values that will be used to calculate the slope.

Graph03

The graph indicates that the slope, from which the rate of photosynthesis can be calculated, should be taken from the period between 5 and 10 minutes. Select these values from the y-axis (changes in pressure).

Graph04

Then do the same for the x-axis (time).

Graph05

Click on OK or press Enter

The value for the slope will appear in the cell that was selected.

Graph06

The number of decimal places may now be adjusted.

 

Next: Plotting Derived Data

 

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