Тёмный

You don't need LINEST! Multiple regression explained (Excel) 

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

What is going on in the black box of LINEST or Data Analysis tab when you estimate a multiple linear regression model? Turns out, nothing too fancy! You can easily estimate the coefficients and standard errors of your model and calculate everything you need explicitly by just multiplying matrices and not relying on the Excel black boxes!
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Statistics!
Please consider supporting NEDL on Patreon: / nedleducation

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

 

13 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 7   
@NEDLeducation
@NEDLeducation 3 года назад
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
@ashleighgonzales
@ashleighgonzales Год назад
Gosh, your tutorials are SO good. Thank you!
5 месяцев назад
I love your videos!!!! They are really pedagogic
@deAraujoAndre
@deAraujoAndre Год назад
Thank you very much for showing us this technique.
@VnHrnz
@VnHrnz Год назад
Thank you so much NEDL. Can you please make an example with the intercept set to 0 (linest(known_ys,known_xs,0,1) with matrix formulas?
@lorenzianbonete7854
@lorenzianbonete7854 2 года назад
Is the process you've shown still applicable if I have more than 16 independent variables?
@aricanto1764
@aricanto1764 2 года назад
Yes but you’ll likely mace lots of multicollinearity between your regressors which will essentially break the model. Instead, us dimensionality reduction or variable selection techniques. If u really really want to use all your variables then linear regression isn’t for you - use a regression tree.
Далее
F-test explained: ESS, RSS, and R-squared (Excel)
12:54
Excel 101: Multiple regression with LINEST
13:37
Просмотров 6 тыс.
НЮША РОЖАЕТ?
00:17
Просмотров 664 тыс.
One proportion Z-test explained (Excel)
9:56
Просмотров 2,6 тыс.