LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Phil Hageman
 
Posts: n/a
Default Trendline Extract

I am calculating/plotting a log trendline extract on the equation
y = 533371Ln(x) - 3E+06. Ln(x) is the period (extract) number, starting at
1 and ending at 288. There are 288 plotted points. The value for 533€¦ and
3E€¦ are derived from the trendline equation each month, when a new value (and
account balance) is added to the series. The plotted extracted values (y)
give me an exact duplicate of the Excel log trendline curve, and, a value
(forcast) for period 288, where the trendline crosses the right side of the
chart. The series looks like this, where cell L2 holds the 533 value, M2
holds the 3E value, and G* is the extract number. Works fine.

=(L2)*LN(G1)-M2
=(L2)*LN(G2)-M2
=(L2)*LN(G3)-M2
etc.
=(L2)*LN(G288)-M2

Now I want to do a second series, using a 2nd order poly trendline with the
equation y = 1.8485x2+641.06x (given by Excel). The extract dimension
remains 1 through 288, and the series is:

=1.8485*(G1)+641.06*(G1)
=1.8485*(G2)+641.06*(G2)
=1.8485*(G3)+641.06*(G3)
etc.
=1.8485*(G288)+641.06*(G288)

The final value (G288) is coming up 183,228, when it should be in the region
of 340,000, the approximate value where the Excel-plotted trendline crosses
the right side of the chart.

Where is the logic flaw?

 
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
Extract Unique Values, Then Extract Again to Remove Suffixes Karl Burrows Excel Discussion (Misc queries) 23 June 25th 05 10:37 PM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
Extract specific data into its own workbook via macro? Adrian B Excel Discussion (Misc queries) 2 February 24th 05 06:09 AM
Code Post: Extract Trendline coefficients who Excel Discussion (Misc queries) 2 January 10th 05 11:36 PM
How do I get the trendline equation from Excel to script? Mattias Charts and Charting in Excel 1 December 7th 04 12:21 PM


All times are GMT +1. The time now is 01:39 PM.

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

About Us

"It's about Microsoft Excel"