One way to assess this fluctuating data is to add a linear trend line to the Excel 2013 graph. This visual element considers all the data and displays the overall direction the values are taking.

National 5; Forming a linear model from a given set of data Examples. A scatter graph and a line of best fit are used to make predictions of results. Part of Maths Statistical skills ...