Forum Discussion
Excel Solver Question
Hi. I am working on hypothetical problem relating to optimizing expected return on investments subject to constraints. I cannot figure out how to put the linear programming model I developed into the excel format so that I can use excel solver to find the optimal solution. Would appreciate any help I could get in figuring this out. Do I need to solve for the expected return, the mean, the standard deviation, as well as have a covariance matrix? I have attached the question below, it is part B that I cannot figure out how to input into excel solver.
- EricStarker
Community Manager
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. (You can find this and other product discussion spaces in the future through the Community Hubs page.)
