• Originally published: 08/03/2021 08:58
Publication number: ELQ-31039-1
View all versions & Certificate

What İf Analysis Data Table Model

A simple model to understand What If Data analysis, in Microsoft Excel.

Description
Data Analysis

Data Analysis is the application of tools and techniques to organize, study, reach conclusions and sometimes also make predictions about a specific collection of information. (Paul McFedries, Excel Pivot Table & Pivot Charts)

Different kinds of people including Sales Managers, Scientists, Family Members, etc. may use data analysis to get the necessary information beginning from trend determination through studying experimental findings to making retirement plans.

Raw Data is the necessary item that is needed in Data Analysis.

Microsoft Excel offers a number of tools to meet the most demanding needs regarding Data Analysis.

What-If 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.

Four kinds of What-If Analysis tools come with Excel:

Scenarios, Goal Seek, Solver, and Data Tables.

Scenarios and Data tables take sets of input values and determine possible results.
https://support.office.com/en-us/article/introduction-to-what-if-analysis-22bffa5f-e891-4acc-bf7a-e4645c446fb4)

Scenarios: It is a collection of input values that are placed in formulas to get a result.

Goal Seek: It is used to find desired result by changing an input value.

Solver: It is used to find optimal solutions for all kind of decision issues.

Data Table: It is a range of cells where one column consists of a series of values, called input cells

This Best Practice includes
1 PDF File, 1 Excel File

Discuss

Further information

Objectives

To keep Users to examine the range of possibilities while varying up to two of the calculation inputs

Use it if

If you have one or two variables

Don't use it if

More than two variables

See all

Any questions on What İf Analysis Data Table Model?

The user community and author are here to help. Go ahead!