Excel - Time Series Forecasting - Part 3 of 3

Поділитися
Вставка
  • Опубліковано 13 гру 2024

КОМЕНТАРІ • 644

  • @wattsasw
    @wattsasw 10 років тому +128

    I pay all this money in books and tuition, and the only way I actually learn is from this guy for free on UA-cam. Thank you.

    • @aftrio
      @aftrio 3 роки тому +10

      OMG...for real...I just spent 8 weeks learning simple linear regression and Jalayer teaches me in 30 minutes!

  • @DZZyuan
    @DZZyuan 2 роки тому +15

    I watched the videos of Time Series Forecasting from Part 1 to Part 3 and followed the guidance step by step and worked out my assignment. Thank you so much. It is great that the videos you posted 9 years ago are still helpful today.

  • @meme-ge8tq
    @meme-ge8tq Рік тому +2

    You're an absolute legend. Even 9 years later these are super useful.

  • @zeeshanrafi6511
    @zeeshanrafi6511 9 років тому +84

    This is not new to me but You are amazing u made it look so simple and explained every step with so much of patience, any one who is learning forecast must watch this.

    • @MrSupernova111
      @MrSupernova111 7 років тому +2

      Seriously. I remember doing this for a stats class and it took me like 4 hours following the professors instructions.

    • @rdjalayer
      @rdjalayer  7 років тому +1

      thanks zeeshan

    • @jongikhayangodwane3334
      @jongikhayangodwane3334 6 років тому

      thank

    • @websterfungirai2099
      @websterfungirai2099 6 років тому

      cant help but second you. this guy is really amazing. followed step by step, and boom! my headache is over!!!

    • @gabrellamulyo4566
      @gabrellamulyo4566 6 років тому

      Hey guys, could you tell me the name of the method used in this video?

  • @heathernadine94
    @heathernadine94 11 років тому +10

    Excellent! You are a lifesaver. Currently taking an Quantitative Analysis class and you summarized an entire chapter (Forecasting) in 3 videos.

  • @chrisbollin7565
    @chrisbollin7565 2 роки тому +3

    My friend, you make this so ridiculously easy that I question why it took me so long to learn. Thank you so much for this step-by-step breakdown. I understood what you were doing, but it also made all of my text reading make so much more sense.

  • @kamansun3477
    @kamansun3477 4 роки тому +4

    These skills are really easy by the explanation of Jalayer. Highly recommend this video to everybody!

  • @olubaba6760
    @olubaba6760 11 років тому

    Thank you very much for the videos on Time Series. The way you delivered this topic is brilliant! You actually taught it and not lecture it. I am grateful to God for you, because you have just made life a little bit easier for me. I am been battling with this topic for some time now, my lecturer has been so rubbish in his method of delivering a course.
    You are great!
    God Bless You!

  • @rdjalayer
    @rdjalayer  11 років тому +5

    Thank you for the thoughtful comment, I am also a lecturer and understand the difficulty of conveying a topic like Time Series.

  • @jacque-l7z
    @jacque-l7z 7 місяців тому +1

    I cant tell you how beautifully and with a lot of patience, you've tought this to us, and especially me. It really helped me in my BBA Degree Assignment. very Greatful and a Million Times Thank You !

  • @davidalejandroglennieporra6678
    @davidalejandroglennieporra6678 6 років тому +1

    You really make it look so simple!!, I guess that is the difference between someone who really love what its doing and other who only speak like a robot and asume everyone is understanding. Great job!

  • @mangopersonishere
    @mangopersonishere 10 років тому +10

    I was pulling my hair out trying to understand the concept before i saw your video, you made it so easy! Thanks a lot!

  • @sergioruge8549
    @sergioruge8549 9 років тому

    I don't know how much to thank you. I spend a week trying to figured the anova table and in just a few steps you came to the answer. thank you. I will recommend your videos to my school friends.

  • @yangjade9
    @yangjade9 2 роки тому

    The best time series forecasting explanation video on UA-cam!

  • @Ob1Chosen1
    @Ob1Chosen1 3 роки тому

    Thank You...One of the best tutorial that I've ever seen. You didn't rush anything, and carefully explained every step. Thanks a lot!

  • @rdjalayer
    @rdjalayer  11 років тому +1

    wow, thank you for the thoughtful comment and feedback, I am glad I could help, you are always welcome

  • @OriginalJoseyWales
    @OriginalJoseyWales 6 років тому +1

    The best tutorial I have seen on time series analysis

  • @elisavetkonstantopoulou5386
    @elisavetkonstantopoulou5386 4 роки тому

    These 3 videos were lifesavers! You explained the topic great and I understood everything! Thank you!

  • @theplatinums2951
    @theplatinums2951 2 роки тому +1

    I must say only one thing that you are so SIMPLE to explain things and this is what is the most difficult job in the world

  • @angadbhalla9325
    @angadbhalla9325 7 років тому +1

    Hey Jalayer, you are one of the best online tutors I have ever experienced. Your complete explanation was phenomenal. I know I am thanking you very late for this video but your complete explanation is a big saviour for lot of students till date.

  • @eduardosantiago7013
    @eduardosantiago7013 2 роки тому

    Clearly explained and fun to follow. This guy has the teaching gift!

  • @SunilBhatnagar-x2i
    @SunilBhatnagar-x2i 9 місяців тому

    videos you posted so many years back are still relevant and helpful thanks a loy

  • @manojgupta-hy8fc
    @manojgupta-hy8fc 4 роки тому

    Also the creator talks slowly and clearly which is very useful for asian subscribers...excellent stuff.

  • @LalitKumar-nj7xc
    @LalitKumar-nj7xc 2 роки тому

    You are one among best teachers I ever had. Thank You so much.

  • @kathleenbuckley4338
    @kathleenbuckley4338 7 років тому

    Thank you! I've been looking for more practical AND advanced excel tutorials. I've learned so much.

  • @henchr1051
    @henchr1051 6 років тому

    I think this was a good instruction and explanation of how to forecast with seasonality. Detailed explanation and I advice all to disregard comments with critical remarks on the speed of the class. It actually think it is rude and arrogant to do it, all these efforts made for us and the only comment is then, speed it 1.5 up.
    Good job Man, this is fine job.

  • @rvo9744
    @rvo9744 9 місяців тому

    I have tested many different methodologies but this simple well explained procedure resulted in the best forecast with lower error measuring ratios like mae and RSME ratios . I am impressed.

  • @jordyn9257
    @jordyn9257 4 роки тому

    Thank-you for teaching me what my current professor cant. Lifesaver.

  • @nachiketjangam4343
    @nachiketjangam4343 4 роки тому

    Saw all 3 videos straight, THANK YOU VERY MUCH!

  • @chocholee7518
    @chocholee7518 5 років тому +1

    What a wonderful example of Time Series Forecasting in Excel! Thanks.

  • @dudefromsa
    @dudefromsa 5 років тому

    The theory is sharp and precise and the examples are simply to the point. This 3 part video is easy to understand and practise. Highly recommend this time series tutorial

  • @aashishraina2831
    @aashishraina2831 8 років тому

    u saved my 4 hours of understanding time series.good job

  • @tonystowe9772
    @tonystowe9772 8 років тому

    Hello,
    I want to thank you for this well thought-out series. The pace, the additional excel formulas to improve the calculations, and your patient narration have made these invaluable to my understanding and progress with this method. Thank you. Tony

  • @japhethcheruiyot4583
    @japhethcheruiyot4583 Рік тому

    Thank you for the tutorials. You've saved me a lot of time and money.

  • @UsmanBinIhsan
    @UsmanBinIhsan Місяць тому

    Though, I am 11 years late finding this beautifully simple and uncluttered explanation of the time series analysis.... Thanks a ton for posting that.

  • @mentalmaniac76
    @mentalmaniac76 11 років тому +1

    This is an excellent video. I was looking to play around and attempt to forecast my monthly income for fun. This is exactly what I was looking for and should really help me learn a ton more about not only Excel, but also statistical analysis in regards to the model mentioned in the video. You have earned a sub sir!

  • @vinniethedrifter
    @vinniethedrifter 4 роки тому

    Hello, mister! I have used this series of videos for a project I need to do in college, for Operations Management. The teacher gave us a challenge, and little help, haha! However these videos came to great aid for both me and my classmates, to whom I have shared these videos. I really want to thank you for this little series. Godspeed!

  • @rdjalayer
    @rdjalayer  11 років тому +2

    glad I could help, Excel is definitely a useful tool whether your forecasting or just doing some personal finance and calculations

  • @ismailmuminov4571
    @ismailmuminov4571 6 років тому +1

    Thank you for this series of tutorials, that really explained time series forecasting. Keep up the good work!!!

  • @charlesanokye811
    @charlesanokye811 2 роки тому

    you really made my day i watched your videos and i was able to complete my assignment you are great man

  • @user-rf9xs2kn8n
    @user-rf9xs2kn8n 10 років тому

    This series of instructive videos has been incredibly useful! Many thanks!!!

  • @yogendraraut6333
    @yogendraraut6333 3 роки тому

    I echoed Zeeshan Rafi. It's amazingly fascinating explanation of time series analysis. People interested in this kind of analysis must watch. it's really beneficial.

  • @purecarib
    @purecarib 8 років тому

    Jalayer Academy....you are amazing! From an MBA student, THANK YOU!

  • @abinaphillips992
    @abinaphillips992 7 років тому

    This was well presented for ease of understanding. I totally enjoyed the simplicity of what I thought was complex material.

  • @gbengaojo9020
    @gbengaojo9020 7 років тому +1

    This is amazing, you made it so simple and straight forward.
    What a great effort!...

  • @FunnyDailyFacts-gm8zd
    @FunnyDailyFacts-gm8zd Рік тому

    Bought a course and I can barely understand what was taught but this video it answered lot of my questions!! thank you so much :)

  • @saaneroa5024
    @saaneroa5024 9 років тому

    Fantastic video. I am new to Time Series Forecasting and need to learn. Your instructions are simple and easy to follow. Really helpful for me. I now need to connect these parts to forecasting call volumes, sales figures etc. Thank you.

  • @cartoonomist
    @cartoonomist 6 років тому

    You are too good. Love you very much. I couldn't resist subscribing you in the Middle of the video.

  • @bgmodur
    @bgmodur 4 роки тому

    You know how to teach. All your students will get very good marks. Thank you.

  • @gantulgaoyungerel5121
    @gantulgaoyungerel5121 3 роки тому

    This wonderful video teaches everyone what times series analysis is. Thank you dear Jalayer Acadey

  • @Latin_American_Economic
    @Latin_American_Economic 11 років тому

    I really enjoyed the video it had a lot of information. I been trying to refine my excel skills and develop additional ones. This will go well in the resume since I am a recent finance graduate. Thank you I appreciate the work you have done as well as all the others excel videos you have done.

  • @rdjalayer
    @rdjalayer  11 років тому

    It turns out there are many ways to forecast even with this introductory level of forecasting, so your tutor may have correct numbers done in a slightly different way. Thanks for the comment and glad I could help.

  • @emilychang7452
    @emilychang7452 4 роки тому

    You're awesome! The step by step time series forecasting is super helpful and practical.

  • @girishghadge8460
    @girishghadge8460 4 роки тому

    You are simply great how well and smoothly you have taken through the entire concept and actually would call it smoothing the learning curve by removing all the irregularities Thank you so much keep it up

  • @chrisnedu9035
    @chrisnedu9035 6 років тому

    I recently enrolled for a course that includes forecasting, but after watching your video I was amassed how you simplify it and explained every step. Thank you very much and will be glad if you can do more videos on excel tools to use for analysis.

  • @antoniocavallo2619
    @antoniocavallo2619 8 років тому +1

    the only serious video existing about trand guy ;-) many thank from Italy ;-)

  • @S_of_M
    @S_of_M 11 років тому

    I can not thank you enough, very well explained, easy to follow, will help me get great marks in my first assignment and also show my tutor his calculations are slightly out...lol...thanks again

  • @shadathossain1880
    @shadathossain1880 4 роки тому

    I tried to know this before many times from many sources.And i finally saw your video and thats great!!Thanks

  • @jerimobure3292
    @jerimobure3292 4 роки тому

    This is truly great! The presentation is made precise and quite easy to follow! The pace of presentation is great too! Keep it up!

  • @balajicr2861
    @balajicr2861 5 років тому

    Excellent video on forecasting. the way the articulation and patiently explaining each steps on the process was awesome. really appreciate the effort taken towards explaining the concepts. Thank you very much

  • @rdjalayer
    @rdjalayer  11 років тому +1

    glad I could be of some help, thanks for watching

  • @eileenchase5521
    @eileenchase5521 10 років тому

    This was extremely helpful....I have applied it to how many home health visits we can expect!

  • @bradleyrowlett
    @bradleyrowlett 9 років тому

    All three series were very informative and useful! Thanks a lot!!

  • @dillonweier6466
    @dillonweier6466 7 років тому

    Thank you so much for this video! I feel like I learned much more in this video than I did in my professor's 3 hour lecture class. Keep up the great content!

  • @AbhijeetSinghs
    @AbhijeetSinghs 4 роки тому

    Thankyou for creating three part series videos on time series. your explanation was so helpful.

  • @bensmith6987
    @bensmith6987 5 років тому

    This is much more clear than my boastful university professor's class. Thank you so much.

  • @rdjalayer
    @rdjalayer  11 років тому

    That sounds right; weekly and monthly data would be treated slightly differently, depends if there is seasonality from week to week or from month to month

  • @Abolwafa27
    @Abolwafa27 10 років тому

    All 3 Videos are informative, useful, and well presented. Thank you so much.

  • @madushikadissanayaka2844
    @madushikadissanayaka2844 4 роки тому

    I was in a great trouble with an assignment on trend line. When i watch these videos it make me interesting to doing my assignment. Thanks a lot 🙂

  • @WhiteTiger1969
    @WhiteTiger1969 5 років тому

    Fantastic video. You covered TCSI in 3 parts. I have people explaining theoretically but not doing it in Excel like you did. Great job and it was a great refresher for me. Thank you

  • @rdjalayer
    @rdjalayer  11 років тому +2

    Centered Moving Average of course deseasonalized, sometimes just called MA

  • @hxvideo
    @hxvideo 9 років тому +2

    Sir. this is gold!!!!, please keep posting!

  • @georgep2149
    @georgep2149 3 роки тому

    absolute beast videos ! i went through these videos on the day of my sem exams (which isn't recommended) but it HELPED.

  • @priyanka1205
    @priyanka1205 8 років тому

    Wow .. your way of teaching is awesome..

  • @johnkathywatkins5572
    @johnkathywatkins5572 8 років тому +2

    Excellent series. I learned loads, comprehensively. Thank you!! :)

  • @mohsenmaverick
    @mohsenmaverick 6 років тому

    The whole three videos are amazing. Good job man

  • @deruan7625
    @deruan7625 3 роки тому

    Cannot believe that my uni professor of Operations Management has not taugh this in the Forecasting practice session and the only thing we did is just exercises on paper. Thanks for these explanations and your content, all the concepts are more clearar after this exercise applied to my case in Inditex Sales

  • @richardhutchins1364
    @richardhutchins1364 5 років тому +3

    Excellent and informative video, my first foray into predictive 'anything' and this has lite a fire within to learn more :)

  • @leanneprevost6803
    @leanneprevost6803 8 років тому

    This is going to help me so much on my exam thank you! You explain really well and slowly! I appreciate it!

  • @aperkinsvt
    @aperkinsvt 9 років тому

    Thank you! This is my first time viewing your videos. I subscribed instantly!

  • @allenixb.laurel3563
    @allenixb.laurel3563 3 роки тому

    Thank you so much! Every course of yours really do an amazing job. I love the way you explain so loud and clear. Sure to look for you always. tnx

  • @leoding4157
    @leoding4157 10 років тому +1

    You rock man! I wish my lecturer was as half good as you

  • @callisvitor
    @callisvitor Рік тому

    Dude, you’re a fucking legend. In economics we mostly studies times series in a more academic manner using R Studio (or Stata). And you basically showed a pragmatic way using ONLY excel. This is a massive knowledge to data workers daily basis.

  • @ramyaraonks
    @ramyaraonks 2 роки тому

    Thank you so much for a detailed explanation. I was really stressed out looking for the mathematics behind the time series analysis and you made my life simple. 😊

  • @huntermckeown1144
    @huntermckeown1144 4 роки тому

    Thanks man. I really appreciate your knowledge and the ability and willingness to share it in a way that can be understood.

  • @rdjalayer
    @rdjalayer  11 років тому +5

    Sweet, glad you enjoyed it.

  • @pmarilag
    @pmarilag 11 років тому

    what a great help! your great knowledge of the topic, easy explanation, calm voice, great graphics and awesome excel skills made it all so easy to understand this topic for me. thank you so much! big fan of your page now :-)

  • @stephenrobertson3220
    @stephenrobertson3220 5 років тому +1

    Brilliant - 3 simple videos showing me exactly what I was looking for, thank you :)

  • @DhruvSharma14
    @DhruvSharma14 4 роки тому +1

    Thanks for the amazing course. This was really amazing. I loved how it was done in Python, but Excel made it so very easy and understandable!

  • @ImtiazHussain-hy8br
    @ImtiazHussain-hy8br Рік тому

    Thank you dear for special working for us. As a data analyst (learning) it is going to help me a lot.

  • @manurol3432
    @manurol3432 3 роки тому

    Thank you very much. Congratulations for your excellent teaching method.

  • @Ishayau
    @Ishayau 10 років тому

    Excellent videos (all 3). Very well presented, clear and correct. You got my like.

  • @parthmodh7957
    @parthmodh7957 4 роки тому

    Great Video, you explained it quite in detail. Thanks for making it.

  • @jorgeardila4554
    @jorgeardila4554 2 місяці тому

    I want to say thanks and Kudos! this was very helpful. I'm not sure if there's another tutorial that explains better than this one

  • @BrOnXaS
    @BrOnXaS 11 років тому

    Easy to follow, interesting and useful! Great videos! Thanks

  • @rdjalayer
    @rdjalayer  11 років тому

    thank you so much for the comment, glad I could be of service

  • @SuperKaddim
    @SuperKaddim 7 років тому

    Many thanks for these series! Simple and effective

  • @JosephJoachimJoseph
    @JosephJoachimJoseph 2 роки тому

    Thank you very much @Jalayer, you explained this very slow in a lot of details, even for a beginner will understand, this knowledge will help me a lot.

  • @user-qg2tj4ib6i
    @user-qg2tj4ib6i 7 років тому

    Thanks for the outstanding job of getting these concepts across!!

  • @salihkhogali1239
    @salihkhogali1239 9 років тому +12

    Great videos. I think you need to measure your forecast errors.
    What you did is Moving Average, can you please show us how to do Auto Regressive (AR) and Auto Regressive Moving Average (ARMA) if it is possible in Excel?
    Thank you.

    • @jsraadt
      @jsraadt 7 років тому +4

      My exact comment! I would like to see this too