


Logistic Regression Step 1 – Sort the Data The purpose of this example of binary logistic regression is to create an equation that will calculate the probability that a production machine is currently producing output that conforms to desired specifications based upon the age of the machine in months and the average number of shifts that the machine has operated during each week of its lifetime.ĭata was collected on 20 similar machines as follows:ġ) Whether the machine produces output that meets specifications at least 99 percent of the time.(1 = Machine Meets Spec – It Does Produce Conforming Output at least 99 Percent of the Time, 0 = Machine Does Not Meets Spec – It Does Not Produce Conforming Output at least 99 Percent of the Time)ģ) The Average Number of Shifts That the Machine Has Operated Each Week During Its Lifetime.

Binary Logistic Regression in 7 Steps in Excel
