Тёмный

Gradient descent in Excel 

NEDL
Подписаться 27 тыс.
Просмотров 1,7 тыс.
50% 1

Gradient descent is a common and powerful algorithm that is commonly used by numerical optimisers. Today we are investigating the concepts behind gradient descent, looking into this "black box" and building an example of gradient descent with simple Excel functions.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Excel!
Please consider supporting NEDL on Patreon: / nedleducation

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

 

3 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 11   
@aricanto1764
@aricanto1764 7 месяцев назад
I thought building a finite difference scheme in excel was peak autism, I've seen people build 8 bit computers in excel, this takes the cake. I congratulate you sir
@winstongraves8321
@winstongraves8321 7 месяцев назад
Awesome video, was literally just about to start my own attempt
@NEDLeducation
@NEDLeducation 7 месяцев назад
You can find the spreadsheets for this video and some additional materials here: drive.google.com/drive/folders/1sP40IW0p0w5IETCgo464uhDFfdyR6rh7 Please consider supporting NEDL on Patreon: www.patreon.com/NEDLeducation
@ei2292
@ei2292 3 месяца назад
There is no gradient descent excel file in google drive 😢
@mahmoudfaouzichaoubi5855
@mahmoudfaouzichaoubi5855 7 месяцев назад
Thank you =شُكرا
@HenkAlles
@HenkAlles 7 месяцев назад
Excellent video (as always). Title has a spelling error (the i), makes it hard to find in RU-vid perhaps.
@NEDLeducation
@NEDLeducation 7 месяцев назад
Thanks for pointing that out and glad you liked the video :)
@barunpradhan1278
@barunpradhan1278 7 месяцев назад
How do we apply this to linear regression with equation y= mx+b, there are no data sets here. Would have been more useful if we could see the example with a sample data set with comparison of ols vs gradient descent.
@JammYSuwapith
@JammYSuwapith 6 месяцев назад
OMG!! Can you please explain the parameter covariance calculation of garch model.
@SlashnKashmir
@SlashnKashmir 7 месяцев назад
Do you have any plan for PCA?
@hackerborabora7212
@hackerborabora7212 7 месяцев назад
Pls do quant economic videos pls
Далее
Covariance matrix shrinkage: Ledoit and Wolf (2004)
16:35
КОГДА НАКРОШИЛ НА ПОЛ #shorts
00:19
Просмотров 855 тыс.
ЭТО НАСТОЯЩАЯ МАГИЯ😬😬😬
00:19
小路飞嫁祸姐姐搞破坏 #路飞#海贼王
00:45
Gradient Descent From Scratch In Python
42:39
Просмотров 18 тыс.
Gradient Descent in Excel Demo
17:00
Просмотров 10 тыс.
Stochastic Gradient Descent, Clearly Explained!!!
10:53
Option valuation - the Black-Scholes model (Excel)
24:18