+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Solver does not change values

  1. #1
    Registered User
    Join Date
    11-30-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    Solver does not change values

    I am trying to run solver to solve a Maximum Likelihood Estimation problem. It is a fairly complex function so I have a cell for the likelihood, which is a product of the elements of a column, which is the sum of other columns which are functions of the data and two parameters I am maximizing over. When I run the solver, (maximizing the likelihood cell, changing the two parameters) it says it finds a solution, but does not change anything when I choose keep solver solution. Any ideas about what could be going wrong?

    I have attached the spreadsheet I am trying to do this on.

    Thanks so much
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Solver does not change values

    Your Solver is set to cell D7 for the answer, but you don't have a formula there. additionally it is set to change the values in C1 and D1 but there are text values in those cells. Did I miss something??
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    11-30-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Solver does not change values

    My bad.
    I am trying to maximize U102 by changing C2 and D2. I am not able to do it. I don't know how the solver got changed, but that was not the source of the problem I was having.

  4. #4
    Registered User
    Join Date
    11-30-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Solver does not change values

    I think I solved it. I took the log of the column and maximized the sum of the logs instead of the product of the regular function. I still don't know what went wrong with the product way, but I now know how to solve the problem.

+ 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

Bookmarks

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