Solver vs. Python in Excel - Which is Best for Logisitc Regression?

Sdílet
Vložit
  • čas přidán 8. 07. 2024
  • While logistic regression analysis is super useful to ANY professional, it's traditionally been a pain in Microsoft Excel. Not anymore! Python in Excel makes performing powerful logistic regression analyses easy.
    Just in case you're unfamiliar with logistic regression, it's a technique where you craft a predictive model where what you are trying to predict is Yes/No:
    Does this patient have heart disease?
    Should we approve this loan application?
    Is this credit card authorization fraudulent?
    Using logistic regression analysis is universal. Whether you work in healthcare, government, marketing, customer service, or finance doesn't matter.
    Logistic regression with Python in Excel is a great tool for having more impact at work using data.
    ☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
    --------------------------------------------------------------------------------------------
    VIDEO CHAPTERS
    --------------------------------------------------------------------------------------------
    00:00 Intro
    01:03 The Data
    02:23 Logistic Regression Using Solver
    04:38 Loading the Data into Python
    06:31 Wrangling the Data
    08:21 The Logistic Regression Model
    09:56 The Model Summary
    11:49 Interpreting the Model
    --------------------------------------------------------------------------------------------
    FREE MACHINE LEARNING CRASH COURSES
    --------------------------------------------------------------------------------------------
    If you're ready to see what Python in Excel skills make possible, be sure to check out my FREE on-demand machine learning crash courses!
    Here's what you get with any of these courses:
    1️⃣ On-Demand: Watch the course when it fits your schedule
    2️⃣ PDF of all slides
    3️⃣ All Python code as a Jupyter Notebook
    4️⃣ All data so you can experiment
    5️⃣ Resources to continue your learning.
    Machine learning with Python in Excel. You've got this if you want it:
    💻 Decision Trees with Python:
    bit.ly/DecisionTreesWithPython
    💻 Tuning Decision Trees with Python:
    bit.ly/TuningDecisionTreesWit...
    💻 Logistic Regression with Python:
    bit.ly/LogisticRegressionWith...
    💻 Cluster Analysis with Python:
    bit.ly/ClusterAnalysisWithPython
    #pythoninexcel #pythonexcel #pythonforexcel
  • Věda a technologie

Komentáře • 5

  • @DaveOnData
    @DaveOnData  Před 4 měsíci

    Stuck waiting on Microsoft to grant you access to Python in Excel? Don't wait! Here's how to get started NOW: czcams.com/video/0iV4FtpSriY/video.html

  • @djj2564
    @djj2564 Před 4 měsíci +1

    Been on youtube for 10+ years and this is my favourite channel! Thanks so much for you great content.

    • @DaveOnData
      @DaveOnData  Před 4 měsíci

      Wow! Thank you so much. I am happy to hear you enjoy my content.

  • @Belakavadi
    @Belakavadi Před 4 měsíci +1

    You are rocking David. Another gem of a tutorial on LR using Py in excel. Cant wait for next one.

    • @DaveOnData
      @DaveOnData  Před 4 měsíci

      Thank you! My next video will demonstrate importing 300,000 rows of data from SQL Server into Python in Excel using Power Query.