The Open Door Web Site
Going Further with Graphs Index
ICT in Biology Index
ICT IN BIOLOGY
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.
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.
The number of decimal places is corrected.
A graph is then drawn of this derived data and trend line is fitted to it.
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.
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