From the course: Machine Learning with Logistic Regression in Excel, R, and Power BI

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Solving MLE

Solving MLE

From the course: Machine Learning with Logistic Regression in Excel, R, and Power BI

Start my 1-month free trial Buy for my team

Solving MLE

“

- [Instructor] Unlike the linear regression model, we can't solve for the coefficients of the logistic regression model directly. Instead, we need to run the Solver Excel add-in with our existing logit model to determine the coefficients. I recommend configuring the formulas in Excel completely before you run solver to get the optimized solution for this model or any other model in Excel. There are four main components to think about when configuring models in the Excel Solver add-in. The objective is the cell we're trying to optimize in the model. The variable cells are the numbers we're letting the algorithm change for us to optimize the model. The constraints are the limitations we give to the model. And the solving method is the algorithm the solver use In the solver add-in, there are three different types of solving methods. For our problem, we're going to leverage the GRG non-linear solving method. GRG stands for…

Contents