Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default How accurate is SOLVER?

"Augabog" wrote...
....
I'm using SOLVER to change three variables in order to get a
minimum sum squared error. I've noticed that if I change the
initial values for the 3 variables before running solver,
that the solver will return different values! There should
only be one value for each associated with a minimum sum of
squared error, and I have placed non constraints on what
Excel can change the three variables in order to reach that
minimum value for the target cell . . . Therefore, what the
values for those three cells are prior to running the
solver shouldn't matter, . . .


Well, you're dead wrong.

First off, Solver, like any other iterative numerical optimization
software, only iterates until the change between a specified number of
iterations is less than a specified threshold. If the initial values
lead to a plateau or local minimum, that's what Solver is going to
give as its result, even if it's not a GLOBAL minimum. There are
settings in Solver's Options dialog which YOU can change to increase
the odds of Solver winding up with a global minimum.

There's a lot of literature on the pitfalls of numerical optimization.
You might want to consider buying a textbook on the subject.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I CALCULATE ACCURATE HUMAN AGES ON A SPREADSHEET ? seege Excel Worksheet Functions 1 January 22nd 07 09:48 PM
My calculations are not always exact/accurate kanye Excel Discussion (Misc queries) 1 April 29th 05 03:09 PM
How can I fit an accurate trendline and formulae geoff Excel Worksheet Functions 1 April 28th 05 12:55 PM
goal seek wont calculate an accurate value past 3 decimal places Joe Browning Excel Discussion (Misc queries) 1 April 13th 05 07:29 AM
getting accurate results when sorting LineRicher Excel Worksheet Functions 3 January 31st 05 12:40 AM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"