Home
Flashcards
Preview
CIS111E Chapter 6 What-If Analysis
The flashcards below were created by user
davecowman
on
FreezingBlue Flashcards
.
Quiz
iOS
Android
More
Variable (p. 378)
A value that can change to see how that change affects other values.
What-If Analysis (p. 378)
The process of changing variables to observe how changes affect calculated results.
One-Variable Data Table (p. 378)
A data analysis tool that provides various results based on changing one variable.
Two-Variable Data Table (p. 382)
A data analysis tool that provides results based on changing two variables
Goal Seek (p. 389)
A tool that identifies the necessary input value to obtain a desired goal.
Scenario (p. 390)
A set of values that represent a possible situation.
Scenario Manager (p. 390)
Enables you to define and manage scenarios to compare how they affect results.
Scenario Summary Report (p. 392)
A worksheet that contains scenario results.
Add-Ins (p. 398)
A program that can be added to Excel to provide enhanced functionality
Optimization models (p. 398)
Finds the highest, lowest, or exact value for one particular result by adjusting values for selected variables.
Objective Cell (p. 399)
The cell that contains the formula-base value that you want to maximize, minimize, or set to a value in Solver.
Changing variable cells (p. 399)
A cell containing a variable whose value changes until Solver optimizes the value in the objective cell.
Constraints (p. 400)
A limitation that imposes restrictions on Solver.
Binding Constraint (p. 402)
A constraint that Solver enforces to reach the target value.
Nonbinding constraint (p. 403)
A constraint that does not restrict the target value that Solver finds.
Author:
davecowman
ID:
309652
Card Set:
CIS111E Chapter 6 What-If Analysis
Updated:
2015-10-16 20:44:42
Tags:
Chapter6
Folders:
Description:
What-If Analysis
Show Answers:
Home
Flashcards
Preview