Скачать или смотреть Logistic Regression

How do we model yes or no questions? In this video, I discuss logistic regression in Excel to find out the probability of a binary outcome.


Starting with data from pizza deliveries, we ask the question, "What is the probability that a customer will leave a negative review given the delivery time and pizza temperature?"



We use the natural logarithm of the odds (the "logit") as an indirect output for our predictive model. Then we use Excel's Solver to maximize the likelihood of the outcome and solve for variable coefficients. Finally, we test the statistical significance of our model using the Chi Squared test.