OK, I think I have a tough one. Probably not for you guys!
Let's say I have the following data set in two rows where the top row are the x's and the second row the y's. Like this:
<tbody>
</tbody>
Assume the first cell is A1.
The following formulas will get me the two values I need to calculate an exponential trendline y = c *e ^(b * x)
c=EXP(INDEX(LINEST(LN(A1:F1),A2:F2),1,2))
b=INDEX(LINEST(LN(A1:F1),A2:F2),1)
If I do this in a chart, I will match. In a chart if I remove a value, say the 1046, it will recalculate c and b and display the adjusted trend.
The formula however will give me an error.
Now finally to my question: How can I alter my formulas to recalculate properly if I remove one or more values?
I hope I stated that clearly enough
Thanks.
Let's say I have the following data set in two rows where the top row are the x's and the second row the y's. Like this:
1 | 2 | 3 | 4 | 5 | 6 |
1530 | 1418 | 1046 | 1088 | 1137 | 1045 |
<tbody>
</tbody>
Assume the first cell is A1.
The following formulas will get me the two values I need to calculate an exponential trendline y = c *e ^(b * x)
c=EXP(INDEX(LINEST(LN(A1:F1),A2:F2),1,2))
b=INDEX(LINEST(LN(A1:F1),A2:F2),1)
If I do this in a chart, I will match. In a chart if I remove a value, say the 1046, it will recalculate c and b and display the adjusted trend.
The formula however will give me an error.
Now finally to my question: How can I alter my formulas to recalculate properly if I remove one or more values?
I hope I stated that clearly enough
Thanks.