#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 108
Default Trendline question

I have the following data:

Ene-08 Feb-08 Mar-08 Abr-08 May-08 Jun-08 Jul-08
8 5000 3802 10400 7600 7400 9800
With this trendline obtaine from the chart:
y = 44,772x - 2E+06

How do I forecast Ago-08
Should x=8
If I want to forecast Feb-09 should x=14?

Thanks

JP

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 563
Default Trendline question

Please do not cords post. I have answered this in Charts

"juanpablo" wrote in message
...
I have the following data:

Ene-08 Feb-08 Mar-08 Abr-08 May-08 Jun-08 Jul-08
8 5000 3802 10400 7600 7400 9800
With this trendline obtaine from the chart:
y = 44,772x - 2E+06

How do I forecast Ago-08
Should x=8
If I want to forecast Feb-09 should x=14?

Thanks

JP

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
Trendline Carlo New Users to Excel 1 July 17th 08 05:17 PM
Trendline Question Robert11 Charts and Charting in Excel 1 June 1st 07 01:17 PM
Trendline Not Always Available Douglas Eckert Charts and Charting in Excel 3 September 11th 06 08:25 PM
Trendline Question Bill Helbron Excel Discussion (Misc queries) 3 March 29th 06 01:40 PM
Linear Trendline Equation Question QuestGAV Charts and Charting in Excel 2 October 11th 05 03:25 AM


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

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"