Тёмный
No video :(

FORECAST.LINEAR & FORECAST.ETS Functions in Excel 2016 

Chester Tugwell
Подписаться 104 тыс.
Просмотров 114 тыс.
50% 1

Download the featured file here (towards bottom of page)
www.bluepecantr...
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.
------------------------

Опубликовано:

 

22 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@kg7760
@kg7760 3 года назад
Great Video! I've been watching videos all the day, and yours is just Wow. Thank you!
@dr.vinishp
@dr.vinishp Год назад
Very well explained. Thank you so much
@ChesterTugwell
@ChesterTugwell Год назад
Glad it was helpful!
@VishalSharma-rn7mt
@VishalSharma-rn7mt 4 года назад
Very well explained the Forecast concept, great video Chester
@Tgarth99
@Tgarth99 4 года назад
You are very articulate!
@freespeech7747
@freespeech7747 2 года назад
Really useful a clear tutorial
@naravindnair
@naravindnair 3 года назад
Great video Chester. Thank you.
@ythens
@ythens 7 лет назад
Simple and clear. Thanks mate
@mghayadar
@mghayadar 2 года назад
This is Awesome. Thank You Very Much. :)
@georgiosgrigoriou2216
@georgiosgrigoriou2216 4 года назад
Great video Chester thank you very much !
@DrMuhammadEddieb
@DrMuhammadEddieb 8 лет назад
very great explanation for Excel forecast, I'm really thankful for your explanation. Best Regards
@zoutube19
@zoutube19 4 года назад
Thanks!
@bulliethepirate
@bulliethepirate 8 лет назад
Very helpful and clear . Thanks a lot
@edwardlicayan5054
@edwardlicayan5054 6 лет назад
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?
@jennyhe31
@jennyhe31 3 года назад
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.
@Berghiker
@Berghiker 7 лет назад
How do you connect uneven spaces between dots on a line chart? Is this possible with excel?
@johnypayeras
@johnypayeras 4 года назад
where can I find the option prevision on a MacBook?
@GrupoLibertyNETCLUB
@GrupoLibertyNETCLUB 7 лет назад
How can I find the algorithm to Forecast linear function, do you know?
@NeverBeenThereBefore
@NeverBeenThereBefore 3 года назад
It's in the video
@alatengbay5577
@alatengbay5577 6 лет назад
Why do you say it's 95%
Далее
Forecasting in Excel using Linear Regression
12:44
Просмотров 267 тыс.
💀СЛОМАЛ Айфон за 5 СЕКУНД😱
00:26
How to do forecasting with Excel 2016
21:37
Просмотров 183 тыс.
Excel 2016 - The New Forecast Sheet
8:31
Просмотров 75 тыс.
Predicting a Stock Price Using Regression
15:00
Просмотров 154 тыс.
Excel - Polynomial Quadratic Regression
7:15
Просмотров 118 тыс.