Forum Discussion
Couldn't calculate exponential trendline intercept value using exponential equation.
With the data below, I am trying to calculate intercept value for exponential trendline with the equation below. But got an error #Num!. Could anyone please help to resolve this. =EXP(INDEX(LINES...
The data aren't suitable for an exponential trendline:
LOGEST results in
| 0.785027 | 1.8E+308 |
Hi Vogelaar, Thank you for the reply.
For the exponential trendline, intercept value calculated as 2E+308 as shown in below trendline equation. I need intercept equation.
Thanks in advance.
1.8E+308 is the second value returned by the LOGEST formula that I posted in my previous reply. The equation on the chart rounds this to 2E+308.
The number -0.242 in the exponent is the LN of the first value returned by LOGEST:
LN(0.785027) = -0.24204
HansVogelaar., Thank you. Could you please share the complete equation for getting this value 1.8E+308 or 2E+308 in excel. I need to convert this equation to equivalent c# code.
Thanks in advance.
