Hi all,
I'm new so hopefully I posted to the correct forum.
I'm trying to extract the coefficients from an equation of an exponential graph, hoping to eliminate the manual process which requires me to key the numbers into a cell. What I noticed, however, is that the displayed equation from the exponential graph does not match the number I extracted.
These two are the equations I'm using:
fx =INDEX(LINEST(LN(C8:C11),F8:F11),1)
fx =EXP(INDEX(LINEST(LN(C8:C11), F8:F11),1,2))
The first one appears to match, but the second one is off by a little bit.
y range
670000
158000
44000
17000
x range
15
16
17
18
The equation displayed on the graph is:
y = 61,530,970,022,230.9000e-1.2301x
R² = 0.9918
What I got from the second fx listed above is:
61,530,970,022,232.40
I'm new so hopefully I posted to the correct forum.
I'm trying to extract the coefficients from an equation of an exponential graph, hoping to eliminate the manual process which requires me to key the numbers into a cell. What I noticed, however, is that the displayed equation from the exponential graph does not match the number I extracted.
These two are the equations I'm using:
fx =INDEX(LINEST(LN(C8:C11),F8:F11),1)
fx =EXP(INDEX(LINEST(LN(C8:C11), F8:F11),1,2))
The first one appears to match, but the second one is off by a little bit.
y range
670000
158000
44000
17000
x range
15
16
17
18
The equation displayed on the graph is:
y = 61,530,970,022,230.9000e-1.2301x
R² = 0.9918
What I got from the second fx listed above is:
61,530,970,022,232.40
