Return to site

Excel get equation for trendline

broken image

I need to forecast the rest of the values through 48 months. I have the one column representing decreasing transactions each month that look like this: The power curve trendline seems to have the closest R-square value (again still trying to learn what that is) to 1 and well, it just looks closer than any of the other trendlines. Anyway, I am doing a lifetime value analysis and my data set shows a series of transactions starting off strong and steadily declining over time. I am cursed with desperately trying to catch up from not taking math or statistics in college.

broken image

OK, I am trying to solve the exact same problem that chastst is, except I am dumber, well, a lot less smart.

broken image