Excel - Time Series Forecasting - Part 3 of 3

  Рет қаралды 522,078

Jalayer Academy

Jalayer Academy

Күн бұрын

Пікірлер: 646
@wattsasw
@wattsasw 10 жыл бұрын
I pay all this money in books and tuition, and the only way I actually learn is from this guy for free on KZbin. Thank you.
@aftrio
@aftrio 3 жыл бұрын
OMG...for real...I just spent 8 weeks learning simple linear regression and Jalayer teaches me in 30 minutes!
@DZZyuan
@DZZyuan 2 жыл бұрын
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.
@grabite368
@grabite368 24 күн бұрын
And till now also
@zeeshanrafi6511
@zeeshanrafi6511 9 жыл бұрын
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 жыл бұрын
Seriously. I remember doing this for a stats class and it took me like 4 hours following the professors instructions.
@rdjalayer
@rdjalayer 7 жыл бұрын
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?
@meme-ge8tq
@meme-ge8tq Жыл бұрын
You're an absolute legend. Even 9 years later these are super useful.
@heathernadine94
@heathernadine94 11 жыл бұрын
Excellent! You are a lifesaver. Currently taking an Quantitative Analysis class and you summarized an entire chapter (Forecasting) in 3 videos.
@UsmanBinIhsan
@UsmanBinIhsan 2 ай бұрын
Though, I am 11 years late finding this beautifully simple and uncluttered explanation of the time series analysis.... Thanks a ton for posting that.
@chrisbollin7565
@chrisbollin7565 2 жыл бұрын
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 жыл бұрын
These skills are really easy by the explanation of Jalayer. Highly recommend this video to everybody!
@jacque-l7z
@jacque-l7z 8 ай бұрын
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 !
@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.
@mangopersonishere
@mangopersonishere 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!
@davidalejandroglennieporra6678
@davidalejandroglennieporra6678 6 жыл бұрын
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!
@theplatinums2951
@theplatinums2951 2 жыл бұрын
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
@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!
@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 10 ай бұрын
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.
@angadbhalla9325
@angadbhalla9325 7 жыл бұрын
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.
@yangjade9
@yangjade9 2 жыл бұрын
The best time series forecasting explanation video on KZbin!
@manojgupta-hy8fc
@manojgupta-hy8fc 4 жыл бұрын
Also the creator talks slowly and clearly which is very useful for asian subscribers...excellent stuff.
@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!
@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!
@OriginalJoseyWales
@OriginalJoseyWales 6 жыл бұрын
The best tutorial I have seen on time series analysis
@LalitKumar-nj7xc
@LalitKumar-nj7xc 2 жыл бұрын
You are one among best teachers I ever had. Thank You so much.
@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.
@jordyn9257
@jordyn9257 4 жыл бұрын
Thank-you for teaching me what my current professor cant. Lifesaver.
@SunilBhatnagar-x2i
@SunilBhatnagar-x2i 10 ай бұрын
videos you posted so many years back are still relevant and helpful thanks a loy
@elisavetkonstantopoulou5386
@elisavetkonstantopoulou5386 4 жыл бұрын
These 3 videos were lifesavers! You explained the topic great and I understood everything! Thank you!
@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 :)
@gantulgaoyungerel5121
@gantulgaoyungerel5121 3 жыл бұрын
This wonderful video teaches everyone what times series analysis is. Thank you dear Jalayer Acadey
@aashishraina2831
@aashishraina2831 8 жыл бұрын
u saved my 4 hours of understanding time series.good job
@charlesanokye811
@charlesanokye811 2 жыл бұрын
you really made my day i watched your videos and i was able to complete my assignment you are great man
@eduardosantiago7013
@eduardosantiago7013 2 жыл бұрын
Clearly explained and fun to follow. This guy has the teaching gift!
@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
@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.
@tonystowe9772
@tonystowe9772 9 жыл бұрын
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
@kathleenbuckley4338
@kathleenbuckley4338 7 жыл бұрын
Thank you! I've been looking for more practical AND advanced excel tutorials. I've learned 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.
@japhethcheruiyot4583
@japhethcheruiyot4583 2 жыл бұрын
Thank you for the tutorials. You've saved me a lot of time and money.
@nachiketjangam4343
@nachiketjangam4343 5 жыл бұрын
Saw all 3 videos straight, THANK YOU VERY MUCH!
@antoniocavallo2619
@antoniocavallo2619 8 жыл бұрын
the only serious video existing about trand guy ;-) many thank from Italy ;-)
@bgmodur
@bgmodur 4 жыл бұрын
You know how to teach. All your students will get very good marks. Thank you.
@chocholee7518
@chocholee7518 5 жыл бұрын
What a wonderful example of Time Series Forecasting in Excel! Thanks.
@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.
@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
@ismailmuminov4571
@ismailmuminov4571 6 жыл бұрын
Thank you for this series of tutorials, that really explained time series forecasting. Keep up the good work!!!
@rdjalayer
@rdjalayer 11 жыл бұрын
Thank you for the thoughtful comment, I am also a lecturer and understand the difficulty of conveying a topic like Time Series.
@purecarib
@purecarib 8 жыл бұрын
Jalayer Academy....you are amazing! From an MBA student, THANK YOU!
@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
@mentalmaniac76
@mentalmaniac76 11 жыл бұрын
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!
@ImtiazHussain-hy8br
@ImtiazHussain-hy8br 2 жыл бұрын
Thank you dear for special working for us. As a data analyst (learning) it is going to help me a lot.
@abinaphillips992
@abinaphillips992 7 жыл бұрын
This was well presented for ease of understanding. I totally enjoyed the simplicity of what I thought was complex material.
@eileenchase5521
@eileenchase5521 10 жыл бұрын
This was extremely helpful....I have applied it to how many home health visits we can expect!
@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 🙂
@gbengaojo9020
@gbengaojo9020 7 жыл бұрын
This is amazing, you made it so simple and straight forward. What a great effort!...
@rdjalayer
@rdjalayer 11 жыл бұрын
glad I could help, Excel is definitely a useful tool whether your forecasting or just doing some personal finance and calculations
@PetStuBa
@PetStuBa 6 жыл бұрын
OMG wonderful explained man ... like Einstein said ... if you can't explain it easy.. you didn't understand it ... you and I now understood it perfectly :) :)
@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
@ShahbazAhmedENG
@ShahbazAhmedENG 3 жыл бұрын
ooooohhhhhh Man you are best of best.. i lost my upwork project just because I did not knew this forcasting. when the project was closed, I came here to find this video and cry after that..... ooh man where were you before... anyhow, thanks for the solution to my curiosity..
@shadathossain1880
@shadathossain1880 5 жыл бұрын
I tried to know this before many times from many sources.And i finally saw your video and thats great!!Thanks
@jorgeardila4554
@jorgeardila4554 3 ай бұрын
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
@richardhutchins1364
@richardhutchins1364 5 жыл бұрын
Excellent and informative video, my first foray into predictive 'anything' and this has lite a fire within to learn more :)
@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.
@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!
@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
@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.
@Latin_America_Economic
@Latin_America_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.
@aperkinsvt
@aperkinsvt 9 жыл бұрын
Thank you! This is my first time viewing your videos. I subscribed instantly!
@emilychang7452
@emilychang7452 4 жыл бұрын
You're awesome! The step by step time series forecasting is super helpful and practical.
@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
@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!
@WhiteTiger1969
@WhiteTiger1969 6 жыл бұрын
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
@user-rf9xs2kn8n
@user-rf9xs2kn8n 10 жыл бұрын
This series of instructive videos has been incredibly useful! Many thanks!!!
@billybeller
@billybeller Жыл бұрын
Wow, thank you. These three videos are awesome and very informative!!!! 🙏🏻😇
@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. 😊
@johnkathywatkins5572
@johnkathywatkins5572 8 жыл бұрын
Excellent series. I learned loads, comprehensively. Thank you!! :)
@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.
@Abolwafa27
@Abolwafa27 11 жыл бұрын
All 3 Videos are informative, useful, and well presented. Thank you so much.
@DhruvSharma14
@DhruvSharma14 4 жыл бұрын
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!
@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.
@stephenrobertson3220
@stephenrobertson3220 5 жыл бұрын
Brilliant - 3 simple videos showing me exactly what I was looking for, thank you :)
@macmakoro3687
@macmakoro3687 9 ай бұрын
You are heavenly sent 🙌🏼
@priyanka1205
@priyanka1205 8 жыл бұрын
Wow .. your way of teaching is awesome..
@bradleyrowlett
@bradleyrowlett 9 жыл бұрын
All three series were very informative and useful! Thanks a lot!!
@cartoonomist
@cartoonomist 6 жыл бұрын
You are too good. Love you very much. I couldn't resist subscribing you in the Middle of the video.
@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!
@hxvideo
@hxvideo 9 жыл бұрын
Sir. this is gold!!!!, please keep posting!
@manojgupta-hy8fc
@manojgupta-hy8fc 4 жыл бұрын
very good video..from zero to hero in 3 vids. I had a forecasting problem to solve and used ur methodology. Would suggest u make a general vid on forecasting techniques , which technique to use in what situation..thanks a ton. strongly recommended
@manurol3432
@manurol3432 3 жыл бұрын
Thank you very much. Congratulations for your excellent teaching method.
@michalisalexakis270
@michalisalexakis270 5 жыл бұрын
Detailed and non complex explenation. Thank you very much. It will be used from me.
@parthmodh7957
@parthmodh7957 4 жыл бұрын
Great Video, you explained it quite in detail. Thanks for making it.
@mohsenmaverick
@mohsenmaverick 6 жыл бұрын
The whole three videos are amazing. Good job man
@neetshil1434
@neetshil1434 9 жыл бұрын
Today i understood about time series, in one day only... thank you so much :)
@scada67
@scada67 9 жыл бұрын
damn, this video really clarifies all the confusion that i have about time series forecasting. Thanks!!
@rdjalayer
@rdjalayer 11 жыл бұрын
wow, thank you for the thoughtful comment and feedback, I am glad I could help, you are always welcome
@haroldlapiceros8308
@haroldlapiceros8308 3 жыл бұрын
what does it mean if my p values are near zero??
@emilystewart4550
@emilystewart4550 5 жыл бұрын
You are simply amazing thank you so much you saved my math grade
@sean4stats
@sean4stats 9 жыл бұрын
I gotta say, thank you very much for these videos, got me a fast revision on this topic for my final exam, thumbs up :D
@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 :-)
@lm58142
@lm58142 4 жыл бұрын
Thank you for the great video. I'd only like to note that the multiplicative model you used gives 'crescendo' forecasts. Not necessarily a bad thing, but if one wants to avoid increasing amplitude in the forecast, an additive model can be used instead with exactly the same steps. Thanks again.
@salihkhogali1239
@salihkhogali1239 9 жыл бұрын
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 8 жыл бұрын
My exact comment! I would like to see this too
Excel - Time Series Forecasting - Part 2 of 3
15:01
Jalayer Academy
Рет қаралды 602 М.
Forecasting in Excel: MUST-KNOW for Any Analyst
9:35
Kenji Explains
Рет қаралды 70 М.
Thank you mommy 😊💝 #shorts
0:24
5-Minute Crafts HOUSE
Рет қаралды 33 МЛН
진짜✅ 아님 가짜❌???
0:21
승비니 Seungbini
Рет қаралды 10 МЛН
$1 vs $500,000 Plane Ticket!
12:20
MrBeast
Рет қаралды 122 МЛН
Multiple Regression in Excel
11:02
Jalayer Academy
Рет қаралды 787 М.
Excel - Time Series Forecasting - Part 1 of 3
18:06
Jalayer Academy
Рет қаралды 1,5 МЛН
TIME SERIES ANALYSIS THE BEST EXAMPLE
26:05
Adhir Hurjunlal
Рет қаралды 370 М.
Lecture 13   Time Series Analysis
42:54
Jordan Kern
Рет қаралды 321 М.
Operations Management using Excel: Seasonality and Trend Forecasting
13:32
Excel@Analytics - Dr. Canbolat
Рет қаралды 422 М.
How to do forecasting with Excel 2016
21:37
Bob Flisser
Рет қаралды 184 М.
Forecasting in Excel using Linear Regression
12:44
PK: An Excel Expert
Рет қаралды 279 М.
Thank you mommy 😊💝 #shorts
0:24
5-Minute Crafts HOUSE
Рет қаралды 33 МЛН