Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TKouba30
Starting Member
2 Posts |
 Posted - 2006-02-28 : 11:17:23
|
| I got a Report that generates a chart of monthly data. What I would like to do is add the simplest exponential growth equation to it. Has anyone done this before or be able to give me a push in the right direction?Thanks,TK |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-02-28 : 11:44:08
|
| Are you talking about adding a trendline, like Excel does? |
 |
|
|
TKouba30
Starting Member
2 Posts |
Posted - 2006-02-28 : 11:49:06
|
| Yes |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-02-28 : 12:35:15
|
| My best guess would be to take the log of each data point, run a single variable linear regression against it to get slope and intercept, and the take the EXP of the resulting formula values.Single linear regression is not TOO difficult to implement in SQL. I've done it in Access. But I would shy away from trying to implement multi-linear n-dimensional regression and look for a third party tool instead. |
|
|
|
jhermiz
3564 Posts |
|
|
|
|
|
Exponential Growth