Seasonality and Trend Forecasting using Multiple Linear Regression with Dummy Variables as Seasons

In this video I demonstrate how to download search data from Google Trends, how to use pivot tables to manipulate the data, and how to use a multiple linear regression forecasting model in Excel to capture seasonality and trend.
Warning: This video requires a halftime break that involves coffee and almond croissants.

[@XXBASSOON1STXX]

You're an absolute life saver! I would have never even gotten close to completing my assignment without this guide!

[@tsibir3800]

WELL DONE Mustafa! Amazing Work! Your Videos Helped me very much with my job as Invetory and a Buyer manager!! We are able to predict the futere to our inventory preety good! Thank's a lot. Love from Greece

[@turkanseymurqizihasanzade6608]

Than you so so much! I had no idea how I was going to complete my assignment. This video saved my life.!

[@emilk4743]

thank you so much! had an assignment for this and couldn't wrap my head around it.

[@marthacastrejon9688]

Thank you so much for this. It was so helpful with a homework assignment.

[@brianeasley9343]

Fantastic video, thank you!

[@almota7]

Really nice! Well done.

[@jthie6802]

Thank you, this video was really helpful for my assigment

[@manishbhaskar2917]

Superb Explanation!

[@warne232000]

Super helpful! Thank you 😊 Could you please take us through the regression statistics and how to interpret them? Adjusted R2, coefficients, Anova table etc. Thanks!!

[@jimmybrooks9812]

Thank you for the help!

[@fxcksalt1]

Thank you! Subscribed

[@unseen1231]

WOW! Thanks a bunch

[@LovinduWijesinghe]

Great Video..!

[@MohammedHawat]

thank you, very nice

[@Deniz-si8qu]

teşekkürler, çok yararlı oldu.

[@adirayhan6379]

Helpful. One question though! what if some of the coefficients are negative?

[@YAlife721]

I have questions.. can u make on inventory forecasting and budget planning

[@ganeshn3800]

Hi Mustfa, thank you. How to do a forecasting when you have commitment months and Lead time. How to predict delays based on this? I don't have order date. Just have commit months, LT and order was on time Or delayed column. How to forecast delays based on LT?

[@pinkaura6983]

Perfect!