Data: We shall use the same data we have used for all our previous exercises – HMGT400Hosp.CSV
Data: We shall use the same data we have used for all our previous exercises – HMGT400Hosp.CSV
Using Excel
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 RegressItLogistic add-in. Of course, XLMiner Analysis ToolPak is an add-in for Google Sheets or Excel Online.
The “RegressItLogistic” 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”.