To analyze the data using the logit regression model (Logistic Regression analysis) in Excel, we cannot use regular Analysis ToolPak. But we can use either the XLMiner Analysis ToolPak add-in or the Regress ItLogistic add-in. Of course, XLMiner Analysis ToolPak is an add-in for Google Sheets or Excel Online.
The “Regress It Logistic” add-in was developed by Professor Robert Nau, at the Duke University Business School in North Carolina. Instructions for downloading and using the add-in are at https://regressit.com/regressitlogistic.html . Note that we need the add-in that runs regressions including logistic regressions called “RegressItLogistic”. You can use it to run both linear regression and logistic regression models. There is a version for running just linear regression models called “RegressItPC”.