Hi All - I've got a series of numbers that I need like to calculate the trend as a percentage. I can graph it and create a trend line but I can't determine the trend percent from that. Any help would be appreciated.
Do you mean a percentage change?
Per point or over the whole line?
=LOGEST(A1:A10) will give a best-fit ratio of sequential values.
It if returns, for example, 1.1, then the best-fit change from value to value is +10% (i.e., 1.1 - 1)
It if returns 0.75, then it's -25% (i.e., 0.75 - 1)
How do you then calculate the change over the whole line? Thanks for any assistance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks