Thank you Mr. Bob. I am going through excel forecasting for the first time and I am feeling like a pro only because of your lecture. Very helpful video for me
Very helpful! Instead of typing in the syntax, I used the drop down dialogue boxes to enter the data. That is how I normally work with Excel; I find it much easer than typing in the syntax.
Hello.Mr Bob.There are many methods of forecasting like simple exponetial smoothing method,double exponetial,holt-winter(if trend & seasonality).can i perform all types of forecasting by using excel formula and not using the above mentioned method ? Plz respond
So my understanding is if you have no trend then seasonality will show 0? Also when you use the .ETS function and put in a number in the seasonality section (for eg 12) what does that mean? I am using this example but for my data excel is automatically taking the seasonality as 0.
Mr. Flisser, thank you, very useful. I'm looking at doing similar forecast analysis, just in my case I have over about 2500 different types of items, each one in its own column and I need to look into each of them separately, so what is the best way how to automate that the same seasonal criteria and steps get assigned to each of the items / columns? And a second question, I'm also work with a yearly stats, so seasonal nr 12, but I have a wider time range of 3,5 years, do I need to limit the time period to 3 years and ignore the data of the following half year to get the seasonality factor of 12?
may I kindly ask in reality there are many products (Part numbers) to forecast. And each Part number required 3years past data each respectively. if I have 100 products to sell and I need to do a forecast of each product... then how can I do it in a easy way using excel?
i tried this on both linear forecast and regular forecast functions on my monthly future revenue prediction sheet. However, the numbers came up very different in each function. Even when i was checking the previous years, the numbers were still very different so i don't know what i did wrong
Sir, is this functionality available en masse? That is, if I have a hundred (or a thousand) Items with historical demand, is there a way to get this to forecast all of them in one batch job?
Hello! Thanks for posting this video. I wonder though, let's say I have counts of surveys and the Customer Satisfaction score (in %) for each period, can I still use the Straight Line method but do it separately for each of them to compute the future # of surveys and their corresponding Customer Satisfaction score goals? I'm also thinking if I used the Straight Line method to compute the Customer Satisfaction goals and then go back and use the values to compute the # of surveys necessary to get to those goals using Multiple regression, is that even possible? Thank you in advance! :)
Thank you, very helpful video. I have made the same, but the Seasonality value become 0 and Confidence values are greater than forecast sold quantities !!!
Sir, this is the great video.. i would lik to know whether it is possible to forecast rainfall amount for more years in future.. will that be reliable.. awaiting for ur kind reply, Sir..
Hello, do you always have to put the dates down the rows? I am always working with forecast data by quarter/year and the timeline always goes across columns. I am seeing a number of tutorials that have it like you do. In theory excel should be able to process the data the same way correct?
Mr Flisser, I've seen one of the best forecasting tutorials ever made on TH-cam. Thanks to you
Great lesson Bob. Just started to use forecasting and this cleared up everything for me. Thank you and keep up the great work.
Mr. Flisser, I want to thank you for this tutorial. It helped me to understand all forecast's functions.
Sir, you are a great teacher of Ms. Excel. Your explanation is simply awesome !!!!
Thanks so much! Glad you like it.
I couldn't have done my assignment without your help. Thank you so much Bob.
Thank you Mr. Bob. I am going through excel forecasting for the first time and I am feeling like a pro only because of your lecture. Very helpful video for me
Sir, I love the way you explained, you're really good
Very helpful! Instead of typing in the syntax, I used the drop down dialogue boxes to enter the data. That is how I normally work with Excel; I find it much easer than typing in the syntax.
This is such a simple and best explanation. thank you Bob!
Excellent video! Thank you for sharing this!
Awesome video Mr. Flisser! Thank you very much!!
This was a phenomenal tutorial, thank you so much for sharing this Bob. You are an excellent teacher no less!
finally a coherent explanation about forecasting using a regular tool.
Gacias mil, Señor ! ! !
thank you. great video! may i know what the number of FORECAST.ETS.STAT function tells us? what does that mean for 0.001?
Awesome. Thanks Bob for sharing
Explained in simplest way.. Thank you
This simple but well explained tutorial is great. Thanks a lot.
Thanks, glad you found it helpful!
@@softwareschool4114You are welcome
This is the best explanation of the different forecast functions. Would you be willing to post the location of the file again?
Thank you, thank you!
Excellent demonstration! Thank you!
Hello.Mr Bob.There are many methods of forecasting like simple exponetial smoothing method,double exponetial,holt-winter(if trend & seasonality).can i perform all types of forecasting by using excel formula and not using the above mentioned method ? Plz respond
So my understanding is if you have no trend then seasonality will show 0? Also when you use the .ETS function and put in a number in the seasonality section (for eg 12) what does that mean? I am using this example but for my data excel is automatically taking the seasonality as 0.
Thanks buddy really helpful may God Bless you
i just wish that if the volume of your voice can be higher, Bob. thank you so much for this tutorial.
Mr. Flisser, thank you for this presentation. It was excellent - and I'm no rookie to the subject of forecasting.
Can this function be used in lotto forecasting numbers? Which to use liner? Can you do a video for lotto forecasting
Thank you Bob, it's clear explanation.
Thank you, BOB. Aswesome
Mr. Flisser, thank you, very useful. I'm looking at doing similar forecast analysis, just in my case I have over about 2500 different types of items, each one in its own column and I need to look into each of them separately, so what is the best way how to automate that the same seasonal criteria and steps get assigned to each of the items / columns? And a second question, I'm also work with a yearly stats, so seasonal nr 12, but I have a wider time range of 3,5 years, do I need to limit the time period to 3 years and ignore the data of the following half year to get the seasonality factor of 12?
not only helpfull this is much helpfull thanks Bob
It is so helpful. The only problem I have is actually clicking the FN+F3 on my Macbook... It goes into Siri....
may I kindly ask in reality there are many products (Part numbers) to forecast. And each Part number required 3years past data each respectively.
if I have 100 products to sell and I need to do a forecast of each product... then how can I do it in a easy way using excel?
such a useful tutorial, thx a lot!
Where was the seasonality data 12 used?
i tried this on both linear forecast and regular forecast functions on my monthly future revenue prediction sheet. However, the numbers came up very different in each function. Even when i was checking the previous years, the numbers were still very different so i don't know what i did wrong
Thanks for this very informative video
I can't seem to locate the chart in Mac. Can you someone help me?
Sir, is this functionality available en masse? That is, if I have a hundred (or a thousand) Items with historical demand, is there a way to get this to forecast all of them in one batch job?
Hello! Thanks for posting this video. I wonder though, let's say I have counts of surveys and the Customer Satisfaction score (in %) for each period, can I still use the Straight Line method but do it separately for each of them to compute the future # of surveys and their corresponding Customer Satisfaction score goals?
I'm also thinking if I used the Straight Line method to compute the Customer Satisfaction goals and then go back and use the values to compute the # of surveys necessary to get to those goals using Multiple regression, is that even possible? Thank you in advance! :)
Thank you, very helpful video. I have made the same, but the Seasonality value become 0 and Confidence values are greater than forecast sold quantities !!!
Thank you so much sir, Can anyone please help me how do I activate this statistical function in excel as I couldn't find it in my formulaes
Sir, this is the great video.. i would lik to know whether it is possible to forecast rainfall amount for more years in future.. will that be reliable.. awaiting for ur kind reply, Sir..
Sir I am unable to open the link provided to get the excel sheet, could you please attach the file in your description?
Thank you for the amazing tutorial.
Hello anyone has link to download this excel sheet
Hello, do you always have to put the dates down the rows? I am always working with forecast data by quarter/year and the timeline always goes across columns. I am seeing a number of tutorials that have it like you do. In theory excel should be able to process the data the same way correct?
I'm follow Same steps, but I'm not get same result
Thanks in a million.
Many thanks
Great job
I LOVE YOU SIR!
OHMAIGADDD YOU ARE AWESOME ABOUT THE DOUBLE CLICK TO DRAG DOWN
Thank you !!
waxdw1 Glad you found it helpful!
Thank You Very much :)
Thanks!
Bob: What if you're using Excel 2016 on a Mac? ... If you really need to forecast, you're better off using the Windows version. LMAO
full of inaccuracies
Thanks very much!
Glad you found it helpful!