Need Binary Logistic Regression in Excel?

QI Macros can do it for you!

Run Binomial Logistic Regression using QI Macros

  1. Select your data.
  2. Click on the QI Macros menu > Statistical Tools > Regression & Other Statistics > Logistic Regression.
  3. QI Macros will do the math and analysis for you.

What is Binary Logistic Regression Analysis?

Binary Logistic Regression estimates the probability of an event occurring (e.g., voted or didn't vote/passed or didn't pass), based on a given dataset of independent variables. Since the outcome is a probability, the dependent variable is bounded between 0 and 1.

Example of Binary Logistic Regression in Excel using QI Macros

  1. Select two or more columns of data (NOTE: The first column of your data must be setup as 1 (pass) or 0 (fail), purchase/no purchase, good/bad, etc. while the next column(s) in your data set should include your predictors):
  2. Binomial Regression Example data

    The sample data shown above is found in QI Macros Help > Open QI Macros Sample Data > statistical.xlsx > "Binomial Logistic Regression" tab

  3. Next, click on the QI Macros menu and choose Statistical Tools > Regression & Other Statistics > Logistic Regression (Binary):
  4. QI Macros Binomial Logistic Regression Menu

    Excel's Solver add-in is used to perform the Coefficients calculations.
    If Solver is not enabled in your Excel, OR you are using a Mac, you will be provided with information about how to calculate the Coefficients manually, using Solver.

  5. Evaluate the Binary Logistic Regression results:

    Binary Logistic Regression Example Results

    If we change the Zip Code to 2, the probability of a sale increases 10X:

    Binomial Logistic Regression Predictive Analytics

In this example:

  • The probability of someone making a purchase is derived from past data.
  • The income, age, and Zip Code can then be used to predict the probability that a person will purchase the product.

NOTE: We will offer both Binary Logistic Regression and Multinomial Logistic Regression in the October 2023 version of QI Macros.

*Logistic Regression functionality introduced in the July 2022 version of QI Macros*

Stop Struggling with Logistic Regression Analysis!
Start conducting Logistic Regression Analysis in just minutes.

Download a free 30-day trial. Run Logistic Regression Analysis now!

QI Macros can draw these charts too!