Logistic Regression Using Excel Video 1 (Finding Heart Disease Probabilities)

  Рет қаралды 52,945

Excel@Analytics - Dr. Canbolat

Excel@Analytics - Dr. Canbolat

Күн бұрын

Пікірлер: 23
@humbertofrancamarcelo
@humbertofrancamarcelo 11 ай бұрын
With this video, I implemented logistic regression at my job using variables to describe the percentage of approval for financial proposals. I applied the same principle but divided my results into three clusters instead of two, making the model significantly stronger. Thank you for this video!
@mcanbolat
@mcanbolat 11 ай бұрын
Although I am happy that the video helped, I recommend that you start using R or Phython for your future work. I posted this video to explain the basics of the model. You need to check the optimal number of clusters using an elbow diagram in which Excel is going to be very inefficient.
@treykalieph
@treykalieph 3 жыл бұрын
Thanks, Mustafa! My professor is incapable of teaching this kind of information to his own class. He almost exclusively outsources other people's work to teach his students in a Master's Program. Very helpful and many thanks!
@haovan1674
@haovan1674 3 жыл бұрын
Thanks, I was looking for a detailed explanation so I can backtest my trading data. These videos are of great help.
@hash2shyam
@hash2shyam 3 жыл бұрын
Thanks a lot for this video. really helped me a lot on right time.
@renatofarias41
@renatofarias41 2 ай бұрын
Great vídeo!!! Thanks for sharing your knowledge.
@eddys2007yt
@eddys2007yt 3 жыл бұрын
good explanation. but how to get b0 (intercept)?.
@korirerick5066
@korirerick5066 6 ай бұрын
i have a question; how did you choose the intercept to be -2 and why does intercept be upon you to choose?
@mcanbolat
@mcanbolat 6 ай бұрын
I just used arbitrary numbers first. The optimal values were found later.
@kiaanmaharaj
@kiaanmaharaj 8 ай бұрын
Why did you use log() instead of ln()
@DanCLMG
@DanCLMG 2 жыл бұрын
Very nice and useful video, thank you very much for that!
@shaunkiyabu2707
@shaunkiyabu2707 Жыл бұрын
Did you do a regression to get the slopes and the intercepts using a training model first? Not sure how you got the B1, b2, b3 etc. thank you
@mcanbolat
@mcanbolat Жыл бұрын
I maximized the sum of the log likelihoods. In regression you minimize the sum of the squared errors. In logistic regression you maximize the joint probability of success.
@shaunkiyabu2707
@shaunkiyabu2707 Жыл бұрын
Hello, thanks for the reply. I think im still confused. Around the 7 min 30 second mark (or a little bit after), you state “assume you know the numbers from the log of best fit”. This implies that you got b1,b2,b3 from a previous regression correct?
@mcanbolat
@mcanbolat Жыл бұрын
What I mean is that we need to enter a formula to calculate the logit, odds, and probabilities referring to the coefficients cells which are empty (not known yet). Later, by optimizing the sum of the log likelihood, we will find the correct coefficients resulting in correct probabilities.
@srinivasalagesan1708
@srinivasalagesan1708 2 жыл бұрын
Hello Dr. Canbolat, I want to use a different data set from UCI repository. But there are no direct spreadsheets available. Could you please help me in that?
@alessandroserra9779
@alessandroserra9779 Жыл бұрын
hi, i am trying to apply this in a school research. But when I launch the solver it gives me all the coefficient to Zero! Why it happens? It seems I cannot maximize log-likelyhood without choosing any other coefficient beyond zero...
@mcanbolat
@mcanbolat Жыл бұрын
Sometimes Excel Solver is not able to find the optimal values if the model has a lot of variables and/or records. You can try with some arbitrary values in the coefficients to increase your chances. Otherwise, you will have to rely on other software such as R, Minitab, Stata, etc. to get the results very quickly. I used Excel here to give insights about how logistic regression classification works.
@pranjalshandilya8772
@pranjalshandilya8772 3 жыл бұрын
Nice interpretation!
@sajidnoor9482
@sajidnoor9482 2 жыл бұрын
Excellent video thanks
@itsvignan
@itsvignan 2 жыл бұрын
Wt are the values in b0,b1,2,3….???
@mcanbolat
@mcanbolat 2 жыл бұрын
Those are the coefficients for each variable in the dataset (and the intercept). The coefficients represent the expected change in log of odds for one unit change in that variable. If they are negative, they decrease the probability of success and if they are positive they increase the probability of success.
@salekbinislam2008
@salekbinislam2008 6 ай бұрын
Y= log (odds)= b0+b1x1
Logistic Regression Using Excel Video 2 - Predicting Heart Disease Probabilities
19:32
Excel@Analytics - Dr. Canbolat
Рет қаралды 22 М.
Support each other🤝
00:31
ISSEI / いっせい
Рет қаралды 81 МЛН
Statistics 101: Logistic Regression, An Introduction
11:26
Brandon Foltz
Рет қаралды 652 М.
Logistic regression : the basics - simply explained
20:25
TileStats
Рет қаралды 38 М.
Logistic Regression Using Excel Solver
8:00
Linda Williams
Рет қаралды 8 М.
Using Multiple Regression in Excel for Predictive Analysis
9:18
Management Information Systems
Рет қаралды 1,8 МЛН
Logistic Regression in Excel
21:17
Ramakrishnan Vaidyanathan
Рет қаралды 6 М.
Statistics 101: Logistic Regression in Excel / Google Sheets, PC / Mac
10:10
Predictive Analytics Guide For Excel Data Analysts
18:05
David Langer
Рет қаралды 51 М.
Logistic Regression for Excel
17:59
KamakuraAnalyticTools
Рет қаралды 52 М.
Statistics 101: Logistic Regression Probability, Odds, and Odds Ratio
13:03