Linear Regresion. Sales By Year.

[Shapper]

Hello,

I have two columns as follows:

Year Sales
2006 1200
2007 1400
2008 1500
2009 1600
2010 1900
2011 2000
2012 2100
2013 ??
2014 ??

How can I create a Linear Regression for years 2006 to 2012 and use it to predict the values of sales in 2013 and 2014?

Thank You,
Miguel

 

[Puppet_Sock]

Hello,

I have two columns as follows:

Year   Sales
2006   1200
2007   1400
2008   1500
2009   1600
2010   1900
2011   2000
2012   2100
2013   ??
2014   ??

How can I create a Linear Regression for years 2006 to 2012 and use it topredict the values of sales in 2013 and 2014?

Look up the function LINEST()
Socks