Solver, Scenarios, and Goal Seek Tools

Hector Guerrero ()
Additional contact information
Hector Guerrero: College of William & Mary

Chapter Chapter 9 in Excel Data Analysis, 2010, pp 303-338 from Springer

Abstract: Abstract Chapters 1 through 8 have introduced us to some very powerful tools for formulating, solving, and analyzing complex problems. From the seemingly endless array of cell functions, to the sorting, filtering, and querying, to PivotTable and PivotChart reports, to the Data Analysis tools, there seems to be a tool for almost every analytical need. Yet, still there are a number we have not exercised; in particular, the optimization tool Solver. Solver permits us to utilize a problem structure known as constrained optimization. Decision makers can search for a best solution for some desired objective under constrained conditions. We will learn more about this prescriptive analysis procedure later in this chapter.

Keywords: Objective Function; Interest Rate; Decision Variable; Shadow Price; Project Type (search for similar items in EconPapers)
Date: 2010
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:sprchp:978-3-642-10835-8_9

Ordering information: This item can be ordered from
http://www.springer.com/9783642108358

DOI: 10.1007/978-3-642-10835-8_9

Access Statistics for this chapter

More chapters in Springer Books from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().