dss modeling
Download
Skip this Video
Download Presentation
DSS Modeling

Loading in 2 Seconds...

play fullscreen
1 / 17

DSS Modeling - PowerPoint PPT Presentation


  • 223 Views
  • Uploaded on

DSS Modeling. Current trends Multidimensional analysis (modeling) A modeling method that involves data analysis in several dimensions Influence diagram

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'DSS Modeling' - kellan


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
dss modeling
DSS Modeling
  • Current trends
    • Multidimensional analysis (modeling)

A modeling method that involves data analysis in several dimensions

    • Influence diagram

A diagram that shows the various types of variables in a problem (e.g., decision, independent, result) and how they are related to each other

static and dynamic models
Static and Dynamic Models
  • Static models

Models that describe a single interval of a situation

  • Dynamic models

Models whose input data are changed over time (e.g., a five-year profit or loss projection)

mss modeling with spreadsheets
MSS Modeling with Spreadsheets
  • Models can be developed and implemented in a variety of programming languages and systems
  • The spreadsheet is clearly the most popular end-user modeling tool because it incorporates many powerful financial, statistical, mathematical, and other functions
mss modeling with spreadsheets2
MSS Modeling with Spreadsheets
  • Other important spreadsheet features include what-if analysis, goal seeking, trial and error, optimization , data management, and programmability
  • Most spreadsheet packages provide fairly seamless integration because they read and write common file structures and easily interface with databases and other tools
  • Static or dynamic models can be built in a spreadsheet
multiple goals sensitivity analysis what if analysis and goal seeking
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Multiple goals

Refers to a decision situation in which alternatives are evaluated with several, sometimes conflicting, goals

  • Sensitivity analysis

A study of the effect of a change in one or more input variables on a proposed solution

multiple goals sensitivity analysis what if analysis and goal seeking1
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Sensitivity analysis tests relationships such as:
    • The impact of changes in external (uncontrollable) variables and parameters on the outcome variable(s)
    • The impact of changes in decision variables on the outcome variable(s)
    • The effect of uncertainty in estimating external variables
    • The effects of different dependent interactions among variables
    • The robustness of decisions under changing conditions
multiple goals sensitivity analysis what if analysis and goal seeking2
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Sensitivity analyses are used for:
    • Revising models to eliminate too-large sensitivities
    • Adding details about sensitive variables or scenarios
    • Obtaining better estimates of sensitive external variables
    • Altering a real-world system to reduce actual sensitivities
    • Accepting and using the sensitive (and hence vulnerable) real world, leading to the continuous and close monitoring of actual results
  • The two types of sensitivity analyses are automatic and trial-and-error
multiple goals sensitivity analysis what if analysis and goal seeking3
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Automatic sensitivity analysis
    • Automatic sensitivity analysis is performed in standard quantitative model implementations such as LP
  • Trial-and-error sensitivity analysis
    • The impact of changes in any variable, or in several variables, can be determined through a simple trial-and-error approach
multiple goals sensitivity analysis what if analysis and goal seeking4
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • What-If Analysis

A process that involves asking a computer what the effect of changing some of the input data or parameters would be

multiple goals sensitivity analysis what if analysis and goal seeking6
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Goal seeking

Asking a computer what values certain variables must have in order to attain desired goals

multiple goals sensitivity analysis what if analysis and goal seeking8
Multiple Goals, Sensitivity Analysis, What-If Analysis, and Goal Seeking
  • Computing a break-even point by using goal seeking
    • Involves determining the value of the decision variables that generate zero profit
ad