The asset turnover, excluding cash and short-term investments, for RNC Company from 2000-2010 are in the table below.

a. Plot the data

b. Determine the least squares trend equation

c. Calculate the points on the trend line for 2003 and 2008, and plot the line on the graph.

Estimate the asset turnover for 2015.

How much did the aset turnover increase per year, on the average, from 2000 to 2010?

2000 1 1.11 2001 2 1.28 2002 3 1.17 2003 4 1.1 2004 5 1.06 2005 6 1.14 2006 7 1.24 2007 8 1.33 2008 9 1.38 2009 10 1.5 2010 11 1.65