Logistic Regression Using Excel Solver

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ม.ค. 2025

ความคิดเห็น • 10

  • @keynote8274
    @keynote8274 9 หลายเดือนก่อน +2

    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  9 หลายเดือนก่อน +2

      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 9 หลายเดือนก่อน +2

    fantastic video!! well explained and very concise. saved me a long night of struggling to learn R haha

    • @lsw278
      @lsw278  9 หลายเดือนก่อน +1

      That's the whole reason I made this video - finding a way to do this WITHOUT R! Glad this helped

  • @MarioRuscovici
    @MarioRuscovici หลายเดือนก่อน

    I really enjoyed this video , because each step in calculating coefficients is clear as a bell. However, there is no calculations of the p values for each variable, or the significance of the regression as a whole

  • @atienzavlogs378
    @atienzavlogs378 หลายเดือนก่อน

    Thank you! Question: how do I find the p-value of the beta coefficients after the fact?

  • @ElMakk_Med
    @ElMakk_Med 9 หลายเดือนก่อน +1

    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  9 หลายเดือนก่อน +3

      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.

  • @mikenyc1589
    @mikenyc1589 5 หลายเดือนก่อน

    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

  • @j0zdesigns
    @j0zdesigns 6 หลายเดือนก่อน

    Thank you.