The Open Door Web Site  
Going Further with Graphs Index Calculating Slopes ICT in Biology Index Using MS Excel as a Calculator

ICT IN BIOLOGY
Custom Search
Using MS Excel 2013 : Going Further with Graphs Trend Lines 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 nonprofit making. Your donations help towards the cost of maintaining this free service online. Donate to the Open Door Web Site using PayPal 