Sunday, June 23, 2024
No menu items!
HomeData Analytics and VisualizationHow to Create Logistic Regression Model Using Excel

How to Create Logistic Regression Model Using Excel

This tutorial explains how to build logistic regression models in Excel, along with examples.

Logistic regression is a statistical technique used for binary classification tasks. It is used when dependent variable has two possible values such as 0 and 1. For example : success/failure, attrition/retention etc.

Sample Data

We need to check whether a student will be admitted (1) or not admitted (0) into graduate school based on their GRE and GPA grades along with the ranking of the undergraduate school they attended.

The raw data looks like the image shown below. We have 397 observations and 5 independent variables in our dataset. Data are in range A2:F398 in Excel. The column admit is a dependent variable in this case and the remaining columns contain data for independent variables.

To read this article in full, please click here

Read MoreListenData



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments