FORECAST.LINEAR & FORECAST.ETS Functions in Excel 2016
Вставка
- Опубліковано 23 гру 2015
- Download the featured file here (towards bottom of page)
www.bluepecantraining.com/port...
The FORECAST.ETS predicts a future value based on historical values. It uses the Exponential Triple Smoothing (ETS) algorithm. The FORECAST.LINEAR function makes a prediction using a simple linear regression.
------------------------ - Навчання та стиль
Great Video! I've been watching videos all the day, and yours is just Wow. Thank you!
Simple and clear. Thanks mate
Very well explained the Forecast concept, great video Chester
Great video Chester thank you very much !
Great video Chester. Thank you.
You are very articulate!
This is Awesome. Thank You Very Much. :)
very great explanation for Excel forecast, I'm really thankful for your explanation.
Best Regards
Really useful a clear tutorial
Thanks!
Very helpful and clear . Thanks a lot
Very well explained. Thank you so much
Glad it was helpful!
How do you connect uneven spaces between dots on a line chart? Is this possible with excel?
If I have zeroes that I don't want to be counted on my data, how do I go about it while still using the forecast formula?
Hi Chester, I have followed your step to create a table. In m table, when calculated the linear forecast (the first one function you showed to us), why does my excel cannot put x axis as time period (the format such as date, same as yours), it only can calculate by pure numbers. For example, my excel, only can the date as the time period by the number of 1,2,3,4,5 … for presenting the months. Once I put the date format as the x axis for using forecast function, the value came out as error.
where can I find the option prevision on a MacBook?
How can I find the algorithm to Forecast linear function, do you know?
It's in the video
Why do you say it's 95%