Hello Again!
I'd be happy to describe the problem more in-depth if it leads to an answer, as my trying to model it in What's Best has been futile to this point!
So given the (11) values that I first posted, when I fit an exponential trendline to these points (after graphing them in EXCEL), I get the equation of
y = 23.855e-0.1308x. So what I need to do now is come up with arbitrary weighted values for these points that if I were to plot them would:
a) give me the same exponentially degrading shape as my original data points if they were plotted.
b) these weighted values when summed together add up to zero. So the first data point should be given 'more weight' than the second, the second 'more' than the third, etc.
Here's an example of what these weights would look like:
8.563
2.242
-0.084
-0.939
-1.254
-1.370
-1.413
-1.428
-1.434
-1.436
-1.437
The aforementioned weights were assigned to the following data set:
24.234
20.531
19.861
16.593
15.406
16.192
15.274
14.424
14.554
14.115
15.026
I don't know what the equation for the trendline was in this case, but maybe this knowledge will help me help you! Thanks again, I hope that this makes the question that much more clear!
Joaq
|