Would love any direction on how to get to the finish line. I'd love to be able to decipher what tusharm is describing in this post to the point where I could replicate this myself. I've tried exponential smoothing, moving average, and even the forecast function, but all of them don't seem to produce the result that seems to make as much sense as the power curve. 01:13 Add a Trendline You can add a trendline to an Excel chart in just a few clicks. I need to forecast the rest of the values through 48 months. To do so, we will follow these steps: To begin with, we need to select the chart.
I have the one column representing decreasing transactions each month that look like this: Step 1: Creating Chart with Trendline First, we will need a trendline on our plot to add a trendline equation to it.
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. Yes, I need to display the Excel-calculated ymx+b. OK, I am trying to solve the exact same problem that chastst is, except I am dumber, well, a lot less smart. excel trendline equation not matching Select linear, and in the options, select show equation.
0 kommentar(er)
