# Tag Info

6

First, calculate the linear regression factors: y=ax+b with the following formula: =LINEST(B2:B21;A2:A21) Then add another column next to the y-axis and name it calculated y-axis. Build the following formula to calc. the y-axis and copy that for all x-values.: =\$D\$3*A2+\$E\$3 Next is a piece of cake. Add the calculated y-axis to the existing data range or ...

3

Use the SMA (Simple moving average). It works as follow Take W points back (e.g. 3, 5 or 10, that's your window size) and do an average for them. This will create a new point Use those newly created points to plot your line. NOTE: at the end you'll have N-W+1 points where N is original number of points and W is your window size Here is an example google ...

1

There's multiples ways to do this : I used =Trend but =Growth works too. =TREND(C2:C11,A2:A11,A12:A24) =Forecast is an amazing function too. =FORECAST(A3,\$B\$2:\$B\$11,\$A\$2:\$A\$11) You can use Arrayformula for extra lazyness : =ARRAYFORMULA(FORECAST(A3:A24,\$B\$2:\$B\$11,\$A\$2:\$A\$11)) Theses formulas will be accurate the more data you feed them. I updated ...

Only top voted, non community-wiki answers of a minimum length are eligible