Goal seeking Examples See also References Navigation menuexpanding ite

Computing terminologyGoalComputer programming stubs


computingtrial and improvementspreadsheetMicrosoft Excel




In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical means. Basic goal seeking functionality is built into most modern spreadsheet packages such as Microsoft Excel.


According to O'Brien and Marakas,[1]optimization analysis is a more complex extension of goal-seeking analysis. Instead of setting a specific target value for a variable, the goal is to find the optimum value for one or more target variables, given certain constraints. Then one or more other variables are changed repeatedly, subject to the specified constraints, until you discover the best values for the target variables.



Examples


Suppose a family wanted to take out the biggest loan that they could afford to pay for. If they set aside $500 a month, the goal-seeking program would try to work out how big a loan the family could afford to take out. Even using simple trial and improvement, a computer could quickly determine that they could not afford a $50,000 loan, but could afford a $48,000 loan. It would then repeat the process until it had reached a figure such as $48,476.34, which would give them a monthly repayment as close to $500 as possible, without exceeding it.


A more efficient method, especially on more complicated calculations, would be for the program to logically work through the argument. By drawing up a simple equation, the program could come to the conclusion that the output equalled one ninety-sixth of the input, and could then multiply the output (or goal) by ninety-six to find the necessary input.



See also


  • Global optimization

  • Goal programming

  • TK Solver


References




  1. ^ O’Brien, J & Marakas, G. (2011). Supporting Decision Making. In B.Gordon (Ed.), Management Information Systems 10e (p. 409). New York: McGraw-Hill Irwin






Computer programming stubs, Computing terminology, GoalUncategorized
-

Popular posts from this blog

Can I redirect output to a log file and background a process at the same time?2019 Community Moderator ElectionUnable to write to file in shell script when running command in backgroundredirect and log script outputhow to properly log the output of a console program that frequently updates “parts” of the screen, resulting in a messy log file?How can I redirect the output of a child process?grep script - output lines at the same time into echoHow to run process in background and get its pid to create log file nameHow to redirect output to a log from expect commandHow to clear a redirect log file content in shell?Log background jobs started in all the manually started shells?Why do `jobs` and `dirs` run in command subsitution, process substitution, pipeline, and background jobs output the same as in original shell?How to redirect output to file to STDOUT?

Image
Makefile strange variable substitution Are all players supposed to be able to see each others' character sheets? How to draw cubes in a 3 dimensional plane Shifting between bemols (flats) and diesis (sharps)in the key signature They call me Inspector Morse An alternative proof of an application of Hahn-Banach Virginia employer terminated employee and wants signing bonus returned Why was Goose renamed from Chewie for the Captain Marvel film? Accepted offer letter, position changed Why does Captain Marvel assume the people on this planet know this? Word for a person who has no opinion about whether god exists Are babies of evil humanoid species inherently evil? How do I express some one as a black person? Am I not good enough for you? Does the nature of the Apocalypse in The Umbrella Academy change from the first to the last episode? Definition of Statistic What problems would a superhuman have whose skin is constantly hot? meaning and function of ...
Read more

Can I sign legal documents with a smiley face?Do Legal Documents Require Signing In Standard Pen Colors?Is it possible to legally prohibit someone from linking to specific pages on your website?Do scans of signed documents have the same legal power as the original document?What can I do if I signed an excessively restrictive contract?Can other party sneak in new contract terms via termination notice?How to prove that someone forged my signature on a contract that I was not aware of?In Australia, Is it legal to sign a document as somebody else?making a contract that includes video licenceLease dispute, over email and text messageIf you must include all of the natural language prose in a legal document, or if it can be abstracted outE-signing: legal ramifications of “identifying” a person

Image
What should I use for Mishna study? Lightning Web Component - do I need to track changes for every single input field in a form Can a malicious addon access internet history and such in chrome/firefox? Hostile work environment after whistle-blowing on coworker and our boss. What do I do? Giant Toughroad SLR 2 for 200 miles in two days, will it make it? Installing PowerShell on 32-bit Kali OS fails What was required to accept "troll"? Books on the History of math research at European universities A known event to a history junkie My boss asked me to take a one-day class, then signs it up as a day off Partial sums of primes What if somebody invests in my application? Simple recursive Sudoku solver Greatest common substring Why does this part of the Space Shuttle launch pad seem to be floating in air? What is the term when two people sing in harmony, but they aren't singing the same notes? Bob has never been a M before How do I repair my sta...
Read more

Word for a person who has no opinion about whether god existsWord for having a definite opinion while simultaneously withholding judgment?What's the opposite of “newcomer? Is ”veteran" OK?What do you call an “atheist” who might believe in an afterlife?What's a word for someone who wants to voice opinions but not have them challenged?Word for someone who dismisses contrary opinions as irrational?Somone who thinks they are overly special/out of the ordinaryIs there a word, phrase or idiom for “a person who is incapable of thinking about the future”?The belief that a god is human-likeA word for a non-famous person/thing you have heard a lot aboutAdjective for a person who enjoys taking care of their appearance

Image
Reverse string, can I make it faster? How strictly should I take "Candidates must be local"? Are there historical instances of the capital of a colonising country being temporarily or permanently shifted to one of its colonies? Accepted offer letter, position changed Could you please stop shuffling the deck and play already? How to secure an aircraft at a transient parking space? At what distance can a bugbear, holding a reach weapon, with the Polearm Master feat, get their Opportunity Attack? Why was Goose renamed from Chewie for the Captain Marvel film? Is it necessary to separate DC power cables and data cables? Is "history" a male-biased word ("his+story")? Why the color red for the Republican Party What's wrong with this bogus proof? Doesn't allowing a user mode program to access kernel space memory and execute the IN and OUT instructions defeat the purpose of having CPU modes? Can one live in the U.S. and not use a c...
Read more