LinkBack URL
About LinkBacks
From a chart in Excel I need to automatically calculate what the annual percentage growth rate is of a trend line. Does anyone know how to automate this in Excel? I've attached a sample so you can see what I'm trying to accomplish. Thanks!
Rob
From a chart in Excel I need to automatically calculate what the annual percentage growth rate is of a trend line. Does anyone know how to automate this in Excel? I've attached a sample so you can see what I'm trying to accomplish. Thanks!
Rob
IMO, the best way to automate this sort of thing is to perform the regression directly in the spreadsheet and skip using the chart trendline feature. This is perhaps most easily accomplished using the =LINEST() function http://office.microsoft.com/en-us/ex...in=HA010277524
You may also want to be aware of the LOGEST() function (http://office.microsoft.com/en-us/ma...829.aspx?CTT=1), though it is really just a specific application of the same regression algorithms LINEST() uses.
Originally Posted by shg
the LINEST function is not giving me the growth rate of the trend line - or - I do not know how to use the number it is giving me to get the growth rate?
your dates are string, so i made datevalues of it.
Then the linear regression values are in B29:D29, on daily base, so multiply with 365 for a year
exponential ?
modified attachment
Last edited by bsalv; 02-13-2014 at 03:50 PM.
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
thank you!!!!!
Did you found a solution for the exponential part of the question ?
you're a genius! i've never seen this formula before:
=DATE(2000+RIGHT(B1,2),LEFT(B1,2),MID(B1,4,2))
got it. thank you!
cant download the excel sheet
I have no problems downloading the file?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks