Time is a vital resource that each organization treasures and tries to transform in a gain. When choosing document management application, be aware of a clutterless and user-friendly interface that empowers consumers. DocHub gives cutting-edge tools to enhance your document administration and transforms your PDF file editing into a matter of one click. Hide SNN Field to the 12 Month Sales Forecast with DocHub in order to save a lot of time as well as increase your efficiency.
Make PDF file editing an simple and easy intuitive operation that saves you a lot of valuable time. Quickly adjust your documents and give them for signing without looking at third-party alternatives. Focus on pertinent duties and increase your document administration with DocHub right now.
hello everyone and welcome to the data analytics channel today we will solve a very practical business problem we will forecast the sales in a scenario that has both a seasonality and a trend and for this we will use the excel statistical package namely the regression model i recommend before going to more advanced tools like python and r to have a solid foundation in excel statistical package our scenario is very simple we have the sales for three years and in this graph we see that the sales have seasonality but also a trend an upward trend each year so what we have to do is to predict the sales for the next year from january 18 to december 18. for this we will use the regression model with the dummy variables for each month what i want to say is that some things maybe will not be very clear to you in this tutorial please check them online because i dont want to make this tutorial very long so uh for your development in analytics you will need to go online and check for example what