ExcelBanter - Trendline question

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

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

- - Trendline question (https://www.excelbanter.com/excel-discussion-misc-queries/252460-trendline-question.html)

juanpablo

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

Bernard Liengme[_2_]

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

All times are GMT +1. The time now is 03:42 AM.