#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 542
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regression in Excel Annie Excel Discussion (Misc queries) 1 January 9th 07 01:53 PM
How configure EXCEL to do ordered logit regression DaleB Excel Discussion (Misc queries) 0 December 28th 06 08:05 PM
Running Excel 2000 VBA Application on Excel 2003 Excel Worksheet Functions 0 August 8th 06 06:04 PM
Excel 5 and Excel 2000 question. Naveen Mukkelli Excel Discussion (Misc queries) 1 March 3rd 06 09:05 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"