Defining Points Along Exponential Trendline

[mattgso]

I let Excel provide an Exponential Curve for a set of data points (in blue). Is there a way to know the value of the points along the curve at each X axis value? I tried using exponential decay and a few other methods. No luck getting the table set up correctly.

 

[thisoldman]

It looks like your trend line is just taking a serial number as its x-value:

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Serial_Number[/TD]
[TD]Trend_Line[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]14649.43871[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]14298.4912[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]13955.95112[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]13295.29245[/TD]
[/TR]
</tbody>[/TABLE]

In B2:

=15009 * EXP(-0.024248 * A2)

 

[mattgso]

Well looks like I was trying to make harder than I needed to. Thanks for the assist.

It looks like your trend line is just taking a serial number as its x-value:

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD]Serial_Number
[/TD]
[TD]Trend_Line
[/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]14649.43871
[/TD]
[/TR]
[TR]
[TD="align: right"]3
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]14298.4912
[/TD]
[/TR]
[TR]
[TD="align: right"]4
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]13955.95112
[/TD]
[/TR]
[TR]
[TD="align: right"]5
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]13295.29245
[/TD]
[/TR]
</tbody>[/TABLE]

In B2:

=15009 * EXP(-0.024248 * A2)

 

[thisoldman]

You're welcome, I'm happy to have helped.