Тёмный

LASSO explained: Machine learning in Excel 

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

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

 

13 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 24   
@NEDLeducation
@NEDLeducation 2 года назад
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
@ahmadz113
@ahmadz113 2 года назад
You are smart Brother . Wouldn't have imagined that someone will utilize Excel in statistics that you do !
@afiqyahya3398
@afiqyahya3398 2 года назад
Fascinated by the use of matrix to calculate the regression and excel mmult
@razorscythe7258
@razorscythe7258 2 года назад
excellent video. Please keep up the good work
@divyateja939
@divyateja939 2 года назад
Great content, especially using matrix.. Did not find such a clear one, over internet...Just want to know, if F-statistic/Annova is not required?
@NEDLeducation
@NEDLeducation 2 года назад
Hi Divya, and glad you liked the video. As for your question, it depends on what hypothesis you want to test. If you are concerned with the individual relationships between variables, which is most often the case, t-stats are enough. F-tests are required only when you want to test for the significance of the model overall.
@divyateja939
@divyateja939 2 года назад
Got it.. Thank you again
@marcovailati7100
@marcovailati7100 Год назад
Thank you
@corradoforza
@corradoforza 2 года назад
Thank you so much I was hoping to see this video 😁 Video suggestion conditional VaR aka Expected Shortfall portfolio optimization with Excel
@NEDLeducation
@NEDLeducation 2 года назад
Hi Corrado, and glad you enjoyed the video! As I am have been moving through some portfolio optimisation topics as of lately (you might have seen videos on the Omega ratio and portfolio concentration already), will definitely touch upon the optimisation of VaR and Expected Shortfall as well. Thanks for the suggestion!
@corradoforza
@corradoforza 2 года назад
@@NEDLeducation one question: when the independent variables have different unit of measurement, do we need to standardize them before applying the LASSO?
@NEDLeducation
@NEDLeducation 2 года назад
@@corradoforza Hi Corrado, and thanks for the question! This is a common practice, you could z-score the variables by subtracting the mean and dividing by the standard deviation for additional robustness.
@MA-bm2qs
@MA-bm2qs 2 года назад
tough implementation in excel, great learning
@datacool
@datacool 5 месяцев назад
Excuse me, i want to ask sir. Why there is a different formula in objective function to minimize SSE, between sklearn library and this video. What is the different ?? Thx
@dufejoe3536
@dufejoe3536 Год назад
Is there not any way we could find the coefficient of the LASSO regression without using the OLS?
@MrMahankumar
@MrMahankumar 2 года назад
Great!!!
@aradhanasorout3344
@aradhanasorout3344 2 года назад
@NEDL could you please elaborate why you have calculated the daily returns using the formula lower value/upper value-1, why this formula is used. Or in place of that, could we normalize the variables using log or anything? The results will be same or not?
@NEDLeducation
@NEDLeducation 2 года назад
Hi Aradhana, and thanks for the question! Yes, you can use log(lower value/upper value) in this case to get logarithmic returns. The results will be similar.
@defordv
@defordv Год назад
Nice to know ur site, may I ask how about group lasso ? Can you tell me or teach me how to operate in excel :(
@defordv
@defordv Год назад
@NEDL
@sheenamittal5782
@sheenamittal5782 2 года назад
Why do you add a column of "constant" in the given data? what is the use of this. Please confirm. @NEDL
@NEDLeducation
@NEDLeducation 2 года назад
Hi Sheena, and thanks for the question! The "constant" column is needed if the matrix method for regression modelling is used (when coefficients and standard errors are obtained by multiplying a bunch of matrices together).
@sheenamittal5782
@sheenamittal5782 2 года назад
@@NEDLeducation Thank you for your prompt answer!
@ivankalarasati
@ivankalarasati 4 месяца назад
hi can you help me to do in my data?
Далее
Elastic net explained: Machine learning in Excel
15:02
Просмотров 1,5 тыс.
Tobit model explained: censored regression (Excel)
16:13
А я с первого раза прошла (2024)
01:00
Excel 101: Multiple regression with LINEST
13:37
Просмотров 6 тыс.
Lasso regression - explained
18:35
Просмотров 18 тыс.
Gaussian Processes
23:47
Просмотров 129 тыс.
LASSO Regression
27:49
Просмотров 12 тыс.
Portfolio Optimisation with Higher Moments (Excel)
22:57
Ridge vs Lasso Regression, Visualized!!!
9:06
Просмотров 254 тыс.