MS-EXCEL: GOING FURTHER WITH GRAPHS i: TREND LINES
This tutorial is available as a pdf download

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 Graphing Wizard to draw the graph. Select XY (Scatter) (Fr Nuages de points).

This 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.

Click on the Chart menu and select Add Trendline… (Fr Ajouter une courbe de tendance)

• Continued on the next Page
• Index Page
• Top of Page

© Paul Billiet 2010