Logistic Regression in R and Excel

Logistic Regression in R and Excel

Business decisions are often binary: take on this project or put it off for a year; extend credit to this customer or insist on cash; open a new retail outlet in a particular location or find another spot. When an outcome is a continuous variable such as revenue, ordinary regression is often a good technique, but when there are only two outcomes, logistic regression usually offers better tools.

Learn how to use R and Excel to analyze data in this course with us. We take you through advanced logistic regression, starting with odds and logarithms and then moving on into binomial distribution and converting predicted odds back to probabilities. After this foundation is established, We shift the focus to inferential statistics, likelihood ratios, and multinomial regression. Our comprehensive coverage of how to perform logistic regression includes tackling common problems, explaining relationships, reviewing outcomes, and interpreting results.

Topics include:

• Recognizing the problems with ordinary regression on a binary outcome
• Quantifying errors in forecasts
• Managing different slopes
• Forecasting odds instead of probabilities
• Limiting probabilities on the upside and downside
• Working with exponents and bases
• Predicting the logit
• Working with original data and coefficients
• Establishing the Log Likelihood
• Interpreting -2LL or deviance
• Establishing a data frame with XLGetRange
• Using the R functions mlogit or and glm
• Understanding long versus wide shapes in data sets

Reach out to us for more details on outreach@opencastlabs-africa.com