Logistic Regression Excel Template. When the dependent variable is categorical it is often possible to show that the relationship between the dependent variable and the independent variables can be represented by using a logistic regression model. The purpose of sorting the data is to make data patterns more evident.

Sort data first by regressor variable. First, input the following data: That you are trying to explain ordinal logistic to some group of people.