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
Graphs are not only a way of presenting data, they can also be used a way of analysing data.
The simplest way is by using a trend line or line of best fit.
Enter your data on a spread sheet and select the variables that you want to plot.
Then select the Insert Menu then Chart Tools. Select Scatter (XY) or Bubble Chart.
See to the left for how to prepare the graph
The graph reveals that one of the points is an outlier. Its position is significantly different from the main trend in the data.
This data point can be removed from the graph by editing the data in the spread sheet.
This results in a modification of the graph
To add a trend line to this graph, use the trend line function of MSExcel. First click left on one of the data points. This will cause the whole series of points to be highlighted. From the menu select Add Trend Line
A series of trend line options will be presented. Select the one which looks the most appropriate and fits the data best. This may take a few trials.
In this example the trend line permits us to do two things:
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