Trendlines

[damian.barnett1]

Does anyone know how to choose the correct trendline for a data set? I
have plotted a data set in Excel 2007 (located at the following link)
http://www.mediafire.com/?sharekey=a6c026861bdd9f9ad2db6fb9a8902bda,
but I don't know how to choose the correct trendline from the options
Excel provides.

 

[Bernard Liengme]

The 'correct' trendline depends on the data. If I weight 2 bags of sugar,
then 4 bags, then 5 I would expect the trend to be linear. But if I measured
the area of circles of different radii, then I would need to use a second
order polynomial with zero intercept. And so on.
What is you data all about?
best wishes