Logistic Regression in Excel

How to perform logistic regression in Excel using solver

[lindilesigweba]

Thank you so much for your explanation. Helped me a lot. Your demonstrations are perfect I needed to comment.

[JaybeePenaflor]

Good instructions! Where can we download the Excel workbook you used?

[test-mmbv]

the 'step' markers were quite helpful.

[jitendraupadhyay]

great video. How do i use it if one of my input variable is categorical?

[WillianAdamczyk]

Great! It helped me a lot to answer an econometric exercise.

[a.binderup]

"Average shits per week", good one.

[tita_netch_universe]

Hi! Thank you for this, really helpful. However i am wondering why i get 1 value of each of my data record for P(x). I have y - winning bid and the independent variables are kilometers and prices. I wanted to get the probability of winning the bid based on that information. But why my p(x) is always 1?

[Angelfire]

How do you get that log likelihood . the likelihood is a product of the densities of bernaulli distribution, p^y (1-p)^(1-y), but on the video it is inverted
Could you please clarify that point?

[phillipworthington]

Hello,

After using solver, my b0 and b1 cells become 0. What does this mean? Because they are 0, when I try different scenarios for X1 and X2, I get the same answer.

Thank you

[glensaldanha]

good explanation however the sound quality can be improved

[cortlandlaidlaw]

Can hardly understand your words: accent/quiet voice.