Solver vs. Python in Excel - Which is Best for Logisitc Regression?
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
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
Been on youtube for 10+ years and this is my favourite channel! Thanks so much for you great content.
Wow! Thank you so much. I am happy to hear you enjoy my content.
You are rocking David. Another gem of a tutorial on LR using Py in excel. Cant wait for next one.
Thank you! My next video will demonstrate importing 300,000 rows of data from SQL Server into Python in Excel using Power Query.