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.
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?
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.
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
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 !!!
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! :)
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?
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, 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?
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
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?
Mr Flisser, I've seen one of the best forecasting tutorials ever made on UA-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.
I couldn't have done my assignment without your help. Thank you so much Bob.
Sir, you are a great teacher of Ms. Excel. Your explanation is simply awesome !!!!
Thanks so much! Glad you like it.
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.
Sir, I love the way you explained, you're really good
This is such a simple and best explanation. thank you Bob!
Excellent video! Thank you for sharing this!
This was a phenomenal tutorial, thank you so much for sharing this Bob. You are an excellent teacher no less!
Awesome video Mr. Flisser! Thank you very much!!
Awesome. Thanks Bob for sharing
finally a coherent explanation about forecasting using a regular tool.
Gacias mil, Señor ! ! !
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!
This simple but well explained tutorial is great. Thanks a lot.
Thanks, glad you found it helpful!
@@softwareschool4114You are welcome
Excellent demonstration! Thank you!
thank you. great video! may i know what the number of FORECAST.ETS.STAT function tells us? what does that mean for 0.001?
Mr. Flisser, thank you for this presentation. It was excellent - and I'm no rookie to the subject of forecasting.
Explained in simplest way.. Thank you
i just wish that if the volume of your voice can be higher, Bob. thank you so much for this tutorial.
Thanks buddy really helpful may God Bless you
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?
such a useful tutorial, thx a lot!
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 for this very informative video
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
Can this function be used in lotto forecasting numbers? Which to use liner? Can you do a video for lotto forecasting
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 for the amazing tutorial.
not only helpfull this is much helpfull thanks Bob
Where was the seasonality data 12 used?
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! :)
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?
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, 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?
Sir I am unable to open the link provided to get the excel sheet, could you please attach the file in your description?
It is so helpful. The only problem I have is actually clicking the FN+F3 on my Macbook... It goes into Siri....
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
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?
Thanks in a million.
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
I can't seem to locate the chart in Mac. Can you someone help me?
Hello anyone has link to download this excel sheet
Many thanks
Great job
Thank you !!
waxdw1 Glad you found it helpful!
Thank You Very much :)
I'm follow Same steps, but I'm not get same result
I LOVE YOU SIR!
OHMAIGADDD YOU ARE AWESOME ABOUT THE DOUBLE CLICK TO DRAG DOWN
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!