What if Analysis,Goal Seek Analysis,Sensitivity Analysis,Optimization Analysis,Data Mining, Slides of Decisione Making for Managers

Download What if Analysis,Goal Seek Analysis,Sensitivity Analysis,Optimization Analysis,Data Mining and more Slides Decisione Making for Managers in PDF only on Docsity!

BY

SOURAV DAS

SOURAV ACHARJEE

SATYAJIT DEBNATH

ASSAM UNIVERS

ITY SILCHAR

MANAGEMENT INFORMATION SYSTEM

PAPER – CP 201

CONTENT

WHAT IF ANALYSIS

SENSITIVITY ANALYSIS

OPTIMIZATION ANALYSIS

DATA MINING

Makes hypothetical changes

to problem and observes

impact on the results

Types of

What If Analysis

Scenario Analysis

Data Tables Analysis

What-If Analysis is the process of changing the values in cells to see

how those changes will affect the outcome of formulas on the worksheet.

Goal Seek Analysis

Sensitivity Analysis

A sensitivity analysis is a technique used to determine how

different values of an independent variable impact a

particular dependent variable under a given set of

assumptions.

This technique is used within specific boundaries that

depend on one or more input variables, such as the effect

that changes in interest rates have on bond prices.

Example Eagle Airlines

Partial Sensitivity Analysis

Best-case and worst-case scenarios

Break-even analysis

Types Of Sensitivity Analysis

Sensitivity Analysis

Advantages Disadvantages

 Simplicity

 Directing Management Efforts

 Ease of being Automated

 As a quality Check

It does not provide clear cut results

 Not a solution in standalone form

Optimization Analysis

Then one or more other variables are changed repeatedly, subject to the Specified constraints, until the best values for the target variables are discovered

It 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.

Optimization

Analysis

Purpose of Optimization analysis

Goal is to find the optimum value for one or more target variables given certain constraints

One or more other variables are changed repeatedly until the best values for the target variables are discovered

Finding the optimum value for one or more target variables

Optimization methods

One or more other variables are changed

repeatedly until the best values for the target

variables are discovered

25 % 30 % 15 % 35 %

Optimization analysis is

quite similar to the goal

seeking analysis in term of

aiming to attain certain

goal with given constraints

Data Mining

Architecture

Get a modern PowerPoint Presentation that is beautifully designed. Easy to change colors, photos and Text. You can simply impress your audience and add a unique zing and appeal to your Presentations. Get a modern PowerPoint Presentation that is beautifully designed. Easy to change colors, photos and Text.

You can simply impress your audience and add a unique zing.

Your Text Here

You can simply impress your audience and add a unique zing.

Your Text Here

3 Steps Data Mining Process

Exploration

Model building and validation

Deployment

Privacy Issues

Misuse of information (^) Disadvantages

Data Mining

Conclusion

All these analysis help a

manager to take a good decision.