Poll: Was my question clear and easy to understand?

+ Reply to Thread
Results 1 to 1 of 1

Solver-problem. Does not maximize anything

  1. #1
    Registered User
    Join Date
    Stockholm, Sweden
    MS-Off Ver
    Excel 2007

    Solver-problem. Does not maximize anything

    Hello everyone,

    This is my first time here, and I hope to find any friendly spirits that can help me. I would be very grateful. Ive got a problem with the solver that I cant find the solution to, so Im hoping that any of you guys can help me.

    Im trying to maximize a likelihood function. I have a set of adjustable cells and a target cell. Furthermore, I have 6 columns. Each with a different formula that is dependent on the adjustable cells, and directly or indirectly linked to the target cell.

    In 2 of the columns I use the formulas "normdist(x;0;1;true)" to get the cumulative dist. function and "normdist(x;0;1;false)" to get the probability mass function. In the last column I use the formula "product" to get the likelihood that I wish to maximize.

    What I hope to do is to change (maximize) the adjustable cells so that the 6 columns receive their optimal values so that my likelihood function is maximized.

    The problem is that when I use the solver, it returns an answer: "Solver found a solution. All constraints and optimality conditions are satisfied."

    However, nothing changes in the adjustable cells (and hence nothing changes in the 6 columns). I have tried to choose the pre-set values in the adjustable cells so that the result in the 6 columns are close to what I assume to find (and in 2 cases what other research have found).

    Is there anyone who have any thoughts on what might be the problem?

    I have attached the excel 2007-file I you want to have a look at what I have done.

    Best regards,

    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1