Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Goal Seek

Status
Not open for further replies.
zdas04

zdas04

Mechanical
Joined
Jun 25, 2002
Messages
10,274
Location
US
I just went through the goal seek exercise from hell trying to do a GENFIT exercise for six variables trying to match a data set stacked into 16 vectors (i.e., for each vector I would vary the guesses until one of the variables converged to a target number, capture the other 5 and move on the the next vector; at the end of the 16 vectors I would put the solved variable into the function and start over with the next one with one fewer variables). I guess I spent 30 hours tweaking guesses and trying again.

Now that it is over (the resulting equation matches the data set within 5%), I was wondering if there was any way that I could have automated it within native MathCad to do a goal seak like Excel does.

David
 
Sort by date Sort by votes
I would use the minerr function and have it done in 15 minutes after I figured out how to read your data.
With only 16 vectors the actual computation time would be less than second. Using Scilab the results would be the same. I would use the optim function.



 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top