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!
Very well explained the Forecast concept, great video Chester
Simple and clear. Thanks mate
Great video Chester. Thank you.
Great video Chester thank you very much !
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
Very well explained. Thank you so much
Glad it was helpful!
Really useful a clear tutorial
Very helpful and clear . Thanks a lot
Thanks!
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.
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?
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%