Тёмный
No video :(

Logistic Regression Using Excel Solver 

Linda Williams
Подписаться 2,9 тыс.
Просмотров 3,8 тыс.
50% 1

This video shows how to perform a Logistic Regression using the Excel Solver Add-in instead of the Data Mining toolpak.

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

 

28 авг 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 8   
@keynote8274
@keynote8274 4 месяца назад
Hey there Linda. I hope you're well. I am currently studying for my postgraduate qualification in data analytics and this video helped me out so much. Thank you for taking the time and effort to upload this and I hope you continue with these videos.
@lsw278
@lsw278 4 месяца назад
I'm glad it helped. Using Excel for this is a little clunky, but it gets the job done! Good luck with your studies
@heyhey6333
@heyhey6333 4 месяца назад
fantastic video!! well explained and very concise. saved me a long night of struggling to learn R haha
@lsw278
@lsw278 4 месяца назад
That's the whole reason I made this video - finding a way to do this WITHOUT R! Glad this helped
@j0zdesigns
@j0zdesigns Месяц назад
Thank you.
@mikenyc1589
@mikenyc1589 24 дня назад
Great video....looking for this for years.....One Question: If you run SOLVER 2 times in a row on the same project....What does those "B" values turn into? Thx
@ElMakk_Med
@ElMakk_Med 4 месяца назад
hey, thanks for effort you put into this, i have a question, why did you use a natural log function in the likelihood!
@lsw278
@lsw278 4 месяца назад
Great question! (Sorry for the long answer, but it's an important component of this approach to regression). In logistic regression, the natural log function is used in the likelihood because of its properties that make it well-suited for modeling probabilities. The logit function, which is the natural log of the odds ratio, converts the probability of success to a linear function of the predictors. It also converts the probability of success to a linear function of the predictors. This linear relationship between the log odds and the predictors is convenient for modeling with linear regression techniques.
Далее
Logistic Regression in Excel
21:17
Просмотров 4,9 тыс.
Секрет фокусника! #shorts
00:15
Просмотров 45 млн
Logistic Regression - THE MATH YOU SHOULD KNOW!
9:14
Просмотров 148 тыс.
How to fit non-linear equations in excel using solver
6:24
Sports Modeling Excel Logistic Regression
12:09
Logistic regression : the basics - simply explained
20:25
Logistic Regression in Excel
5:33
Просмотров 4,8 тыс.