ex 5

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”.