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:

	A	B
1	Serial_Number	Trend_Line
2	1	14649.43871
3	2	14298.4912
4	3	13955.95112
5	5	13295.29245

<tbody>
</tbody>

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:

	A	B
1	Serial_Number	Trend_Line
2	1	14649.43871
3	2	14298.4912
4	3	13955.95112
5	5	13295.29245

<tbody>
</tbody>

In B2:

=15009 * EXP(-0.024248 * A2)

 

[thisoldman]

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