🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ec320&Comments&RUclips 🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ec320&Comments&RUclips 🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ec320&Comments&RUclips 🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ec320&Comments&RUclips 🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ec320&Comments&RUclips
Hi Simplilearn! Thank you for this video. But may I be clarified on how you get the St (average respective quarters) 22:41. I got lost there. Thank you.
I am glad I found the video it is very informative, I got lost when calculating the moving average why did you choose to put the first moving average on the 3rd quarter and
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!v
Hi Simplilearn, glad that I found this video. very understandable and well explained. I just wanted to know when calculating the coefficients using regression for trend, I am not getting the same result as in the video. what columns are actually used? I am using Y-original sale and X-de season values . but, getting diff coefficients. Please clarrify.
he calculated it based on the St It average per quarter. For example in Q1, there are only 3 since we are missing Q1 for Year 1. average for Q1 = (.96 + .88 + .87) /3
Hi, I really want to ask how can I deal with the data if it only has 3 quarters in the final years. I mean, I have data of 4 years from 2018-2021, but in 2021, I just have 3 quarters data. So, isn't it seasonal data? Can I apply the same method to deal with it? Can you reply me, thk you so muchhhh
@@SimplilearnOfficial It helped alot but can you help me to create a logic ( a single equation) which could be feeded into some software which autocalculates forecast on based of that logic
Is it possible to do the calculation of ARIMA in excel if yes then please share the video on that as it will help more people to learn and understand it with more clearly
Hey Yaman, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)
Thanks a lot. It's a very informative video. But I got an error while using "plot(ddata)" function in R. The error is "Error in plotts(x = x, y = y, plot.type = plot.type, xy.labels = xy.labels, : cannot plot more than 10 series as "multiple"".
🔥Data Analyst Masters Program (Discount Code - YTBE15) - www.simplilearn.com/data-analyst-masters-certification-training-course?Ec320&Comments&RUclips
🔥IITK - Professional Certificate Course in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-analytics?Ec320&Comments&RUclips
🔥Purdue - Post Graduate Program in Data Analytics - www.simplilearn.com/pgp-data-analytics-certification-training-course?Ec320&Comments&RUclips
🔥Caltech - Data Analytics Bootcamp (US Only) - www.simplilearn.com/data-analytics-bootcamp?Ec320&Comments&RUclips
🔥IITG - Professional Certificate Program in Data Analytics and Generative AI (India Only) - www.simplilearn.com/iitg-generative-ai-data-analytics-program?Ec320&Comments&RUclips
Hi Simplilearn! Thank you for this video. But may I be clarified on how you get the St (average respective quarters) 22:41. I got lost there. Thank you.
I am glad I found the video it is very informative, I got lost when calculating the moving average why did you choose to put the first moving average on the 3rd quarter and
Thank You for the Time Series Analysis.
Greatly appreciated.
Thank You,
Natasha
You are so welcome!
Thanks!
WooHoo! We are so happy you love our videos. Please do keep checking back in. We put up new videos every day on all your favourite topics Have a good day!v
Amazing video. Best among those I have watched on this topic.
Glad it was helpful!
On the trend part, quite confused of the formula Trend = Intercept + slope * time code.
What is your formula for the predicted value(Yp)?
Amazing voice, it makes me listen quite interestingly. Of Course the subject is anyway will be good. So good work SimpliLearn
Many many thanks
Good lecture to hear.
Glad you liked it
Well explained/ presented. Thank you for sharing.
Glad it was helpful!
How did you get the trend and predicted values?
Which formula is used in finding St? I'm not getting it by simply average of quarters.
Please refer to Excel Quartile Function
Hi Simplilearn, glad that I found this video. very understandable and well explained.
I just wanted to know when calculating the coefficients using regression for trend, I am not getting the same result as in the video. what columns are actually used? I am using Y-original sale and X-de season values . but, getting diff coefficients. Please clarrify.
I am facing the same issue
Yeah. Likewise me.
Kindly clarify.
Thanks.
24:16 how did you calculate the 2nd St?
he calculated it based on the St It average per quarter.
For example in Q1, there are only 3 since we are missing Q1 for Year 1.
average for Q1 = (.96 + .88 + .87) /3
Hi, I really want to ask how can I deal with the data if it only has 3 quarters in the final years. I mean, I have data of 4 years from 2018-2021, but in 2021, I just have 3 quarters data. So, isn't it seasonal data? Can I apply the same method to deal with it? Can you reply me, thk you so muchhhh
Can we predict lottery numbers with this?!
Average of quarters is different when i am calculating or my excel and calculator is broken
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
@@SimplilearnOfficial It helped alot but can you help me to create a logic ( a single equation) which could be feeded into some software which autocalculates forecast on based of that logic
Is it possible to do the calculation of ARIMA in excel if yes then please share the video on that as it will help more people to learn and understand it with more clearly
Hey Yaman, thank you for watching our video. We will definitely look into your suggestions. Do subscribe and stay tuned for updates on our channel. Cheers :)
How did you compute the Seasonal Component of the data please?
good one
Thanks for the visit
Thanks a lot. It's a very informative video. But I got an error while using "plot(ddata)" function in R. The error is "Error in plotts(x = x, y = y, plot.type = plot.type, xy.labels = xy.labels, :
cannot plot more than 10 series as "multiple"".