Question

1. The following modeling activities are the basic types of analytical modeling, EXCEPT:
   

   		What-if Analysis
   		Sensitivity Analysis
   		Goal-seeking Analysis
   		PESTLE Analysis

Answer 1

PESTLE analysis is not a type of Analytical modelling.

It is a framework of macro-environmental factors used in the environmental scanning component of strategic management.

It is a strategic tool for understanding market growth or decline, business position, potential and direction for operations.

It contains analysis of the following parameters

political, economic, socio-cultural, technological, legal and enviromental aspects of any particular given problem

Goal Seek

The Goal Seek Excel function (often referred to as What-if-Analysis) is a method of solving for a desired output by changing an assumption that drives it

Sensitivity Analysis

A sensitivity analysis is a financial modeling tool companies use to determine how changes to a given variable might affect an outcome, assuming other conditions stay the same.

What if analysis

process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.