You may have good reason to distrust the Excel solver :) See below
John Kane Kingston ON Canada > -----Original Message----- > From: rzw...@ets.org > Sent: Sat, 14 Feb 2015 23:53:55 +0000 > To: r-help@r-project.org > Subject: [R] Nonlinear integer programming (again) > > Oddly, Excel's Solver will produce a solution to such problems but (1) I > don't trust it and (2) it cannot handle a large number of constraints. >From IIRC a discussion on the R-help list but which I forgot to save the link. "The idea that the Excel solver "has a good reputation for being fast and accurate" does not withstand an examination of the Excel solver's ability to solve the StRD nls test problems. Solver's ability is abysmal. 13 of 27 "answers" have zero accurate digits, and three more have fewer than two accurate digits --and this is after tuning the solver to get a good answer. ... Excel solver does have the virtue that it will always produce an answer, albeit one with zero accurate digits." Bruce McCullough ____________________________________________________________ FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your desktop! ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
