ExcelBanter - Regression in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Regression in excel (https://www.excelbanter.com/excel-discussion-misc-queries/128922-regression-excel.html)

James

Regression in excel

Hi
I am trying to use excels regression function to predict sales in the
future. I have independant and dependant variables for six years (periods). I
also have the independant vairable for another 10 years and i want to get an
estimate of the dependant variable.
Any help would be appreciated
Thanks
James

Jim Thomlinson

Regression in excel

Have you looked at the forecast function???
--
HTH...

Jim Thomlinson

"James" wrote:

Hi
I am trying to use excels regression function to predict sales in the
future. I have independant and dependant variables for six years (periods). I
also have the independant vairable for another 10 years and i want to get an
estimate of the dependant variable.
Any help would be appreciated
Thanks
James

All times are GMT +1. The time now is 12:22 AM.