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