This tutorial explains how to compute confusion matrix in Excel, along with examples.
Please ensure you have the following two columns in Excel:
Binary Dependent Variable (0 / 1)
Predicted probabilities
Let’s say you have data for dependent variable in cells A2:A100 and probabilities in cells B2:B100.
To read this article in full, please click here
Read MoreListenData