Excel - Time Series Forecasting - Part 3 of 3

  Рет қаралды 511,231

Jalayer Academy

Jalayer Academy

Күн бұрын

Part 1: • Excel - Time Series Fo...
Part 2: • Excel - Time Series Fo...
This is Part 3 of a 3 part "Time Series Forecasting in Excel" video lecture. Be sure to watch Part 1 and 2 before watching this part. The links for Parts 1 and 2 are in the video as well as above.

Пікірлер: 640
@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 KZfaq. 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 Жыл бұрын
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 Жыл бұрын
You're an absolute legend. Even 9 years later these are super useful.
@heathernadine94
@heathernadine94 10 жыл бұрын
Excellent! You are a lifesaver. Currently taking an Quantitative Analysis class and you summarized an entire chapter (Forecasting) in 3 videos.
@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!
@kathleenbuckley4338
@kathleenbuckley4338 7 жыл бұрын
Thank you! I've been looking for more practical AND advanced excel tutorials. I've learned so much.
@elisavetkonstantopoulou5386
@elisavetkonstantopoulou5386 4 жыл бұрын
These 3 videos were lifesavers! You explained the topic great and I understood everything! Thank you!
@kamansun3477
@kamansun3477 4 жыл бұрын
These skills are really easy by the explanation of Jalayer. Highly recommend this video to everybody!
@ismailmuminov4571
@ismailmuminov4571 5 жыл бұрын
Thank you for this series of tutorials, that really explained time series forecasting. Keep up the good work!!!
@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
@mangopersonishere
@mangopersonishere 9 жыл бұрын
I was pulling my hair out trying to understand the concept before i saw your video, you made it so easy! Thanks a lot!
@zeeshanrafi6511
@zeeshanrafi6511 8 жыл бұрын
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 5 жыл бұрын
cant help but second you. this guy is really amazing. followed step by step, and boom! my headache is over!!!
@gabrellamulyo4566
@gabrellamulyo4566 5 жыл бұрын
Hey guys, could you tell me the name of the method used in this video?
@eduardosantiago7013
@eduardosantiago7013 2 жыл бұрын
Clearly explained and fun to follow. This guy has the teaching gift!
@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.
@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!
@dillonweier6466
@dillonweier6466 6 жыл бұрын
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!
@dudefromsa
@dudefromsa 4 жыл бұрын
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
@gbengaojo9020
@gbengaojo9020 6 жыл бұрын
This is amazing, you made it so simple and straight forward. What a great effort!...
@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
@shadathossain1880
@shadathossain1880 4 жыл бұрын
I tried to know this before many times from many sources.And i finally saw your video and thats great!!Thanks
@yangjade9
@yangjade9 2 жыл бұрын
The best time series forecasting explanation video on KZfaq!
@hxvideo
@hxvideo 8 жыл бұрын
Sir. this is gold!!!!, please keep posting!
@chocholee7518
@chocholee7518 5 жыл бұрын
What a wonderful example of Time Series Forecasting in Excel! Thanks.
@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.
@angadbhalla9325
@angadbhalla9325 6 жыл бұрын
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.
@rdjalayer
@rdjalayer 10 жыл бұрын
glad I could help, Excel is definitely a useful tool whether your forecasting or just doing some personal finance and calculations
@japhethcheruiyot4583
@japhethcheruiyot4583 Жыл бұрын
Thank you for the tutorials. You've saved me a lot of time and money.
@LalitKumar-nj7xc
@LalitKumar-nj7xc Жыл бұрын
You are one among best teachers I ever had. Thank You so much.
@davidalejandroglennieporra6678
@davidalejandroglennieporra6678 5 жыл бұрын
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!
@johnkathywatkins5572
@johnkathywatkins5572 8 жыл бұрын
Excellent series. I learned loads, comprehensively. Thank you!! :)
@stephenrobertson3220
@stephenrobertson3220 4 жыл бұрын
Brilliant - 3 simple videos showing me exactly what I was looking for, thank you :)
@emilychang7452
@emilychang7452 3 жыл бұрын
You're awesome! The step by step time series forecasting is super helpful and practical.
@CarpeDiemTomorrow
@CarpeDiemTomorrow 5 жыл бұрын
Thank you for putting together this series - very much appreciated
@OriginalJoseyWales
@OriginalJoseyWales 5 жыл бұрын
The best tutorial I have seen on time series analysis
@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
@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.
@sergioruge8549
@sergioruge8549 8 жыл бұрын
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.
@dariashpykuliak8789
@dariashpykuliak8789 5 жыл бұрын
Yes, this was unbelievably helpful! Thank you!
@user-rf9xs2kn8n
@user-rf9xs2kn8n 10 жыл бұрын
This series of instructive videos has been incredibly useful! Many thanks!!!
@allenixb.laurel3563
@allenixb.laurel3563 2 жыл бұрын
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
@user-gv2hk5rj9u
@user-gv2hk5rj9u 2 ай бұрын
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 !
@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.
@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
@saaneroa5024
@saaneroa5024 8 жыл бұрын
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.
@aashishraina2831
@aashishraina2831 8 жыл бұрын
u saved my 4 hours of understanding time series.good job
@nachiketjangam4343
@nachiketjangam4343 4 жыл бұрын
Saw all 3 videos straight, THANK YOU VERY MUCH!
@leanneprevost6803
@leanneprevost6803 7 жыл бұрын
This is going to help me so much on my exam thank you! You explain really well and slowly! I appreciate it!
@purecarib
@purecarib 8 жыл бұрын
Jalayer Academy....you are amazing! From an MBA student, THANK YOU!
@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. 😊
@aperkinsvt
@aperkinsvt 8 жыл бұрын
Thank you! This is my first time viewing your videos. I subscribed instantly!
@mentalmaniac76
@mentalmaniac76 10 жыл бұрын
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!
@bradleyrowlett2032
@bradleyrowlett2032 8 жыл бұрын
All three series were very informative and useful! Thanks a lot!!
@user-yl4qn7qs5v
@user-yl4qn7qs5v 3 ай бұрын
videos you posted so many years back are still relevant and helpful thanks a loy
@Abolwafa27
@Abolwafa27 10 жыл бұрын
All 3 Videos are informative, useful, and well presented. Thank you so much.
@DhruvSharma14
@DhruvSharma14 3 жыл бұрын
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!
@jordyn9257
@jordyn9257 3 жыл бұрын
Thank-you for teaching me what my current professor cant. Lifesaver.
@SuperKaddim
@SuperKaddim 7 жыл бұрын
Many thanks for these series! Simple and effective
@user-qg2tj4ib6i
@user-qg2tj4ib6i 6 жыл бұрын
Thanks for the outstanding job of getting these concepts across!!
@reggierosario4708
@reggierosario4708 4 жыл бұрын
Amazing videos ! Easy to comprehend and follow ! thank a lot !!
@BrOnXaS
@BrOnXaS 10 жыл бұрын
Easy to follow, interesting and useful! Great videos! Thanks
@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.
@mohsenmaverick
@mohsenmaverick 5 жыл бұрын
The whole three videos are amazing. Good job man
@xjtuxl
@xjtuxl 2 жыл бұрын
Super! very clear and well explained! the best one for time series forecasting in KZfaq!
@forrestsun
@forrestsun 9 жыл бұрын
Best forecast video on youtube, extremely helpful and thank you very much~~
@vinniethedrifter
@vinniethedrifter 3 жыл бұрын
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!
@georgep2149
@georgep2149 2 жыл бұрын
absolute beast videos ! i went through these videos on the day of my sem exams (which isn't recommended) but it HELPED.
@joniji7
@joniji7 9 жыл бұрын
Really useful tutorials. Thank you for making them.
@rafaelvaladez9232
@rafaelvaladez9232 3 жыл бұрын
Thank you Jalayer Academy ! Great video series!
@tashajohnson789
@tashajohnson789 2 жыл бұрын
Thank you so much! You made this simple and understandable. I truly appreciate it!
@maurosalomao4481
@maurosalomao4481 6 жыл бұрын
Wow! You are truly the best out there. Thank you!
@madushikadissanayaka2844
@madushikadissanayaka2844 3 жыл бұрын
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 🙂
@abinaphillips992
@abinaphillips992 6 жыл бұрын
This was well presented for ease of understanding. I totally enjoyed the simplicity of what I thought was complex material.
@rvo9744
@rvo9744 3 ай бұрын
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.
@charlesanokye811
@charlesanokye811 Жыл бұрын
you really made my day i watched your videos and i was able to complete my assignment you are great man
@macmakoro3687
@macmakoro3687 3 ай бұрын
You are heavenly sent 🙌🏼
@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.
@gantulgaoyungerel5121
@gantulgaoyungerel5121 2 жыл бұрын
This wonderful video teaches everyone what times series analysis is. Thank you dear Jalayer Acadey
@Ishayau
@Ishayau 10 жыл бұрын
Excellent videos (all 3). Very well presented, clear and correct. You got my like.
@oksanak9702
@oksanak9702 4 жыл бұрын
You are really very good to explain !! Thank you very much for your help. Your videos helped me a lot.
@smilesumairu
@smilesumairu 9 жыл бұрын
Thank you so much for making these videos!!! It is really helpful
@billybeller
@billybeller 11 ай бұрын
Wow, thank you. These three videos are awesome and very informative!!!! 🙏🏻😇
@FunnyDailyFacts-gm8zd
@FunnyDailyFacts-gm8zd 8 ай бұрын
Bought a course and I can barely understand what was taught but this video it answered lot of my questions!! thank you so much :)
@richardhutchins1364
@richardhutchins1364 5 жыл бұрын
Excellent and informative video, my first foray into predictive 'anything' and this has lite a fire within to learn more :)
@jofyl7526
@jofyl7526 9 жыл бұрын
Really helpful videos! Thank you very much. Your videos help me a lot with my thesis.
@muhammadnazri1888
@muhammadnazri1888 8 жыл бұрын
thank you sir, this help me lots to understand & improve the way of doing the forecast. i really appreciate your efforts of making this video
@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.
@ashrafosman7845
@ashrafosman7845 5 жыл бұрын
Amazing work ... thanks a million for the subject, info, example, explanation .. really happy to come across your channel
@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
@manojgupta-hy8fc
@manojgupta-hy8fc 4 жыл бұрын
Also the creator talks slowly and clearly which is very useful for asian subscribers...excellent stuff.
@leoding4157
@leoding4157 9 жыл бұрын
You rock man! I wish my lecturer was as half good as you
@priyanka1205
@priyanka1205 8 жыл бұрын
Wow .. your way of teaching is awesome..
@antoniocavallo2619
@antoniocavallo2619 8 жыл бұрын
the only serious video existing about trand guy ;-) many thank from Italy ;-)
@parthmodh7957
@parthmodh7957 4 жыл бұрын
Great Video, you explained it quite in detail. Thanks for making it.
@spvit5547
@spvit5547 3 жыл бұрын
Great presentation. Learned. Enjoyed.
@scoutsilver6680
@scoutsilver6680 8 жыл бұрын
This series is so helpful, thank you! :)
@kingsleyopokuboateng8645
@kingsleyopokuboateng8645 6 жыл бұрын
Great video by all standard.
@venkir9999
@venkir9999 10 жыл бұрын
Wonderful Video and explanation. God Bless!!!
@sukhomoyb
@sukhomoyb 7 жыл бұрын
Thanks a lot for the clarification on Forecasting. Really worth watching
@michalisalexakis270
@michalisalexakis270 5 жыл бұрын
Detailed and non complex explenation. Thank you very much. It will be used from me.
Excel - Time Series Forecasting - Part 1 of 3
18:06
Jalayer Academy
Рет қаралды 1,5 МЛН
Excel - Simple Linear Regression
7:56
Jalayer Academy
Рет қаралды 841 М.
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 12 МЛН
Каха ограбил банк
01:00
К-Media
Рет қаралды 11 МЛН
When You Get Ran Over By A Car...
00:15
Jojo Sim
Рет қаралды 12 МЛН
Lecture 13   Time Series Analysis
42:54
Jordan Kern
Рет қаралды 309 М.
Forecasting Methods made simple - Exponential Smoothing
8:05
Piyush Shah
Рет қаралды 225 М.
Excel - Time Series Forecasting - Part 2 of 3
15:01
Jalayer Academy
Рет қаралды 590 М.
Multiple Regression in Excel
11:02
Jalayer Academy
Рет қаралды 759 М.
TIME SERIES ANALYSIS THE BEST EXAMPLE
26:05
Adhir Hurjunlal
Рет қаралды 356 М.
Forecasting in Excel using Linear Regression
12:44
PK: An Excel Expert
Рет қаралды 263 М.
Operations Management using Excel: Seasonality and Trend Forecasting
13:32
Excel@Analytics - Dr. Canbolat
Рет қаралды 412 М.
Forecasting: Moving Averages, MAD, MSE, MAPE
4:52
Joshua Emmanuel
Рет қаралды 965 М.
Using Linear Regression in Excel for Time Series Forecasting
12:23
The Business Doctor
Рет қаралды 865
THEY made a RAINBOW M&M 🤩😳 LeoNata family #shorts
00:49
LeoNata Family
Рет қаралды 12 МЛН