A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

LINEST, LOGEST, GROWTH or TREND??



 
 
Thread Tools Display Modes
  #1  
Old August 22nd, 2005, 03:10 PM
NlCO
external usenet poster
 
Posts: n/a
Default LINEST, LOGEST, GROWTH or TREND??


Hi all, I need to get the R2 of a formula like this

f(t) = a + b*c^t

I've tried with LINEST(Range Y,LN(Range X),,TRUE) then the array three
cells down and it should appear, but the numbers I get applies only
to:

f(t) = b*c^t

Anybody knows how to get the real value or the r2 in any other way?

Thanks NlCO


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=397762

  #2  
Old August 23rd, 2005, 12:29 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default

You have not said what is known and what must be estimated here. Based
on getting a result using your LINEST formula, I assume that c is known
and a,b, & t must be estimated. That would make the problem nonlinear
in the unknowns. Excel has no functionality to natively fit such
functions. You could use Solver to approximately minimize the sum of
squared deviations by changing trial values of a,b, & t.

Once you have values for a,b, & t, R2 would be
=DEVSQ(a+b*c_range^t)/DEVSQ(y_range)
which must be array entered (Ctrl+Shift+Enter) because of the
calculation in the numerator.

Jerry

NlCO wrote:

Hi all, I need to get the R2 of a formula like this

f(t) = a + b*c^t

I've tried with LINEST(Range Y,LN(Range X),,TRUE) then the array three
cells down and it should appear, but the numbers I get applies only
to:

f(t) = b*c^t

Anybody knows how to get the real value or the r2 in any other way?

Thanks NlCO


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
LINEST bug with cubic polynomials in Excel 2003 byundt Worksheet Functions 3 March 21st, 2005 03:15 PM
Trend Lines (or Linest?) Martinaire Worksheet Functions 2 November 26th, 2004 07:08 PM
Problems with LINEST in Excel 2003 hypersonic Worksheet Functions 1 August 17th, 2004 10:36 PM
Constrain of "Linest" function Hoi - Excel Dummy Worksheet Functions 2 May 7th, 2004 01:44 PM
Trend line calculations Jerry W. Lewis Charts and Charting 1 January 8th, 2004 05:09 PM


All times are GMT +1. The time now is 08:25 AM.


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