How to use the Forecast Linear Function in Google Sheets and add a Trendline in a Chart

[@orangepony52]

You are my hero. I watched like five other videos before I watched this one and this actually helped me figure out what I was doing. Thank you!

[@DavidREsau]

Awesome, glad you got it figured out. Thanks for watching and I hope you subscribe. 🙏🏽

[@thesemidailydingus7530]

David, thank you for informing us viewers in an easy and simple way. it was quite cool of you

[@jrizoseo]

helpful and straight to the point, thank you!

[@DavidREsau]

Thank you!

[@juliusfreund7477]

broooo thx! I just really freaking needed this ^^

[@DavidREsau]

You are welcome.

[@FC-mz7mx]

Thx for the succinct explanation and perfect example! Also, thx to Jared Hodge for the extra advice. Cheers.

[@FC-mz7mx]

But just to add, rather than setting the independent and dependent variables as absolute values (i.e. using the "$" sign), I was able to get incredible accuracy using a 21-series moving average. Of course, the moving forecast is dependent on the actual data as they become apparent, so I guess this would be great just for a few days of forecasts and not too far into the future. I used a bit over a year's worth of stock's price data (294 data points for a blue chip company) and can confirm that overall accuracy was a stunning 0.22%! Thanks again!

[@norwoodwesleyanchurch]

Very helpful thank you!

[@Bob-Stanke]

Well done, nicely explained in an easy to follow way.

[@gvarun0403]

Schools should teach this. Great video ❤️

[@DavidREsau]

Thank you!!! They definitely should.

[@musicjunk8266]

so useful 🙏 edit: don't you think you should use the $ symbol to lock the function values? ie. =FORECAST.LINEAR(A32,B$2:B$31,A$2:A$31) seems like if you don't then you're using forecasts to predict future forecasts...

[@oritayy]

This was so helpful

[@DavidREsau]

Thank you! Please share and subscribe for me.

[@tonythetonester5223]

Do you know how to make the trendline show the value at all when we want certain value of y axis and they just show us x value with the specific y value form the trendline?

[@leigh-annerichter5241]

trying to replicate this and for some reason my new value is less than the previous? I noticed in Excel the forecast.ets formula is working but that's not accepted in google sheets - any ideas?

[@navn9771]

Can we do this for candlestick OHLC with 20 day ema

[@Behappyalways309]

Awesome thanks

[@Kentas12]

very good tutorial

[@txHodge]

Sorry to say it, but you're doing it wrong.... You're basing your linear estimates on previous linear estimates instead of making them all based on the original data (autofilling the cells changes them - try looking at the range 5 rows down and seeing that it is adjusting your data range also). To fix this, put dollar signs on the row numbers for the 2nd and 3rd function arguments before you autofill. Hope this helps.

[@DavidREsau]

Awesome. Thanks for your help. I’ll try to confirm your comments and thanks for speaking up.

[@LukasCharolAdhiDwiyanto]

Nice thanks

[@ollenyren9842]

Very helpful!

[@jackjemison5977]

how can i achieve a similar result if my data is not in a regular interval?

[@DavidREsau]

When is your data available? How often?

[@teemunator]

Not working for some reason.. Looking by the comments, error must be something what I do wrong. Doing exactly what said here and getting formula parsing error immediatly when highlighting Y axis data. Other result from that formula is #N/A. All simple numeric data and Sheets wrote graph and trends out of it without errors..

[@Allbbrz]

This is odd... I have a table with 24 entries on column A1:A24 which are dates, starting 24 months ago... My B1:B24 are values starting at 150,000 and then decreasing about 1,853 "every month" ... my formula on a separate cell, became =FORECAST(B25,B1:B24,A1:A24) but the result is a whopping 2867528.036 .. what gives ?!? Yeah, I can certainly just replicate the 150000-1853 and get a final value, but I wanted to see "Forecast" in action..... and like the weather forecast, it went wild .....

[@NickWard-s5m]

HOW CAN I DO FORECAST LINEAR FUNCTION BY MONTH NOT BY DATE!?!?!?

[@cailloubates]

When you autodrag your C values arent starting at the top!

[@eimantasn]

music is so distracting..

[@clicktrackmarketing]

lol.

[@thegrowingcable3676]

does not work at all what soever. google sheets is pure useless crap

[@NickWard-s5m]

You're just slow