Logistic Regression Using Excel Video 2 - Predicting Heart Disease Probabilities

  Рет қаралды 22,878

Excel@Analytics - Dr. Canbolat

Excel@Analytics - Dr. Canbolat

Күн бұрын

This is a follow up video to • Logistic Regression Us...
In this video I finish the model I started in the earlier video and create a confusion matrix then find the accuracy, prediction, and recall measures. I finish the presentation by creating a ROC (receiver operating characteristic) curve.
The link for the Excel file I used is provided below as a Google Sheets file. Do download it please open it, go to File- Download As - Excel
docs.google.co...

Пікірлер: 34
@jupingert
@jupingert 6 ай бұрын
Thank you for sharing your knowledge. Both the videos put together are really really clear.
@MelissaPompilius
@MelissaPompilius 3 жыл бұрын
This video and its companion (Video 1) are very helpful and well-presented. Thank you for sharing!
@tingey9291
@tingey9291 8 ай бұрын
Thank you very much for sharing this in depth tutorial, it has proven to be invaluable to me. I wanted to ask, if possible, after determining the efficacy of the model, would you be willing to publish a tutorial detailing how this can be utilised in predictive practice? Your time and consideration would be appreciated.
@tstan8121
@tstan8121 Ай бұрын
Extremely useful and enlightening. Thank you!
@kaisong4529
@kaisong4529 3 жыл бұрын
This video and previous one are great and helpful. They solved many questions in my mind. Thanks for sharing! Very nice!
@Chroniom
@Chroniom 2 жыл бұрын
Thank you for the excellent explanations in the video! I have a small question: how could one find out the significance of the coefficients using excel?
@mcanbolat
@mcanbolat 2 жыл бұрын
Excellent question! It will be very different from the approach we take in regular regression. There is a resource here which may help:www.real-statistics.com/logistic-regression/significance-testing-logistic-regression-coefficients/ I may create a video on this myself.
@humbertofrancamarcelo
@humbertofrancamarcelo 11 ай бұрын
Thank you so much for your help with this video! Awesome work!
@karthick2254
@karthick2254 9 ай бұрын
Very good explanation, thank you for the great effort!!!
@MOHITGUPTA-di4hc
@MOHITGUPTA-di4hc Жыл бұрын
Great video. Thanks you How do I fit S curve on this? Any suggestions?
@maheshsaivarma
@maheshsaivarma 2 жыл бұрын
Thanks for such a great video, in my case the solver is not able to solve it, it is showing an error that one of the cells in the worksheet became an error value when solver tried certain values. Please help me what to do in this case
@mcanbolat
@mcanbolat 2 жыл бұрын
Is it a different dataset? Assuming no error in the model, sometimes the solver may stuck if a division by zero error occurs. You can start with arbitrary coefficents to possibly prevent that. You may have to try other software, this is just to explain how the model works. R or other software can easily give you the coefficients.
@pranavsalvi8338
@pranavsalvi8338 3 жыл бұрын
Thank you Mustafa! Your video helped me.
@ApoorwVikramDwivedi
@ApoorwVikramDwivedi Жыл бұрын
Using same data we can also find out R2 of the model but how do you find out p-value from this?
@StellaJeruk-v4u
@StellaJeruk-v4u Жыл бұрын
thanks sir, but i have one question that how to test the model use the data test? cause in this video is only show us how to train a model.
@mcanbolat
@mcanbolat Жыл бұрын
You can use the logistic regression formula from the training data on a test data to see how it performs.
@StellaJeruk-v4u
@StellaJeruk-v4u Жыл бұрын
@@mcanbolat Thank you very much for the reply & information, but i still don't know how, i'm newbie in machine learning, i'm sorry sir can you explain it to me, how it's work? Which one formula that i can use to test the data?
@gembelningrat66
@gembelningrat66 2 жыл бұрын
is it the same for solving multinomial regression?
@-MochMiftachurRifqiAlHusain
@-MochMiftachurRifqiAlHusain Жыл бұрын
Sorry sir, i have little question here about the evaluation model. This video explain us about regression and evalute with confusion matrix. How it works? Is it able to do regression evaluation using a confusion matrix? Why not use MSE, MAE, etc? Thank you sir
@mcanbolat
@mcanbolat Жыл бұрын
Hi, Logistic regression is a classification model and not a least squares regression model.The quality of the model is based on how good the classification is and it does this by maximizing the joint probability of success.
@-MochMiftachurRifqiAlHusain
@-MochMiftachurRifqiAlHusain Жыл бұрын
@@mcanbolat ohh i see, thank you very much sir, i've been confused all day about that. I think the name is Logistic "Regression" that is regression model..
@jeffreymun8221
@jeffreymun8221 2 жыл бұрын
How do you decrease the sum of the log likelihoods more? Mine comes out to be -1800 to after the solver ran through it -1766..
@mcanbolat
@mcanbolat 2 жыл бұрын
Sometimes the solver does not do a good job if there are many variables. You can start with different initial values or try the evolutionary solver option in the menu. The best thing to do is to use a statistical software to get the coefficients. The objective of this video is to explain how the model works.
@StevenDocherty.
@StevenDocherty. 3 жыл бұрын
Would you be open to help with the development of a complex template?
@tagalogmathclub6457
@tagalogmathclub6457 2 жыл бұрын
Hi sir, to make sure, this is ordinal logistic regression right? This is not the multinomial logistic regression if I got it correctly.
@mcanbolat
@mcanbolat 2 жыл бұрын
Hi yes, multinomial means the dependent variable has more than two categories, not just two.
@elenagoudarzvand6861
@elenagoudarzvand6861 2 жыл бұрын
Great job, well described , thanks
@viveknandanwar8458
@viveknandanwar8458 2 жыл бұрын
thank you sir very helpful explanation
@heriheryadi8817
@heriheryadi8817 2 жыл бұрын
clear explanation
@mateotorres8139
@mateotorres8139 3 жыл бұрын
so helpful!!
@luyu4923
@luyu4923 3 жыл бұрын
Very helpful, thank you.
@yalcnozturk4592
@yalcnozturk4592 2 жыл бұрын
Hocam çok teşekkürler, selamlar.
@ElMakk_Med
@ElMakk_Med 7 ай бұрын
thank you
Logistic Regression Using Excel Video 1 (Finding Heart Disease Probabilities)
18:28
Excel@Analytics - Dr. Canbolat
Рет қаралды 52 М.
Logistic Regression in Excel
21:17
Ramakrishnan Vaidyanathan
Рет қаралды 6 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
Quando eu quero Sushi (sem desperdiçar) 🍣
00:26
Los Wagners
Рет қаралды 15 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
Interpreting Linear Regression Results
16:08
Sergio Garcia, PhD
Рет қаралды 329 М.
Monte Carlo Forecasting Using Excel
36:35
Excel@Analytics - Dr. Canbolat
Рет қаралды 696
Forecasting in Excel using Linear Regression
12:44
PK: An Excel Expert
Рет қаралды 278 М.
Logistic Regression for Excel
15:32
KamakuraAnalyticTools
Рет қаралды 30 М.
Seasonality and Trend Forecasting Video 2: Multiple SKUs
9:34
Excel@Analytics - Dr. Canbolat
Рет қаралды 95 М.
Neural Networks Using Excel: A Small Classification Model Example
19:02
Excel@Analytics - Dr. Canbolat
Рет қаралды 25 М.
Logistic Regression Details Pt1: Coefficients
19:02
StatQuest with Josh Starmer
Рет қаралды 941 М.
Learning Curves in Operations Management and Project Management
21:10
Excel@Analytics - Dr. Canbolat
Рет қаралды 7 М.
Statistics 101: Logistic Regression in Excel / Google Sheets, PC / Mac
10:10
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН