Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating growth with negative numbers | Excel Worksheet Functions | |||
How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) | |||
How to use linest with variably sized data arrays? | Excel Worksheet Functions | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
Trend Lines (or Linest?) | Excel Worksheet Functions |