| Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Is it sensible to use Excel's Solver to optimize independent variables in a linear regression model? > Using Solver to Maximize the Dependent variable | Share |
Using Solver to Maximize the Dependent variable
Excel Help for Using Solver To Maximize The Dependent Variable in Excel Multiple Regression Analysis and Forecasting Template
| Forum Topic | Login |
Using Solver To Maximize The Dependent Variable | Rate this: (3/5 from 1 vote) |
 | Yes, you can use the Excel Solver add-in to run simulations on the regression formula. You should each independent variable input into a dedicated cell and then create the formula for the dependent variable in another cell. Solver can then be used to maximise the dependent variable cell by changing the independent variable cells within specified constraints. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Using Solver to Maximize the Dependent variable in the Excel Business Solutions Directory |