Associate the Following Concepts with Its Corresponding What-If Analysis Tool

question 18

Short Answer

Associate the following concepts with its corresponding what-if analysis tool.
I.Answer Report
II.PivotTable
III.Set Cell
IV.Change interest rate
V.Change term and down payment
A.Goal Seek
B.Solver
C.One-variable data table
D.Two-variable data table
E.Scenario Manager

---

Definitions:

Time Series

A series of data points gathered or documented at consecutive time periods.

Nominal

Nominal refers to data that is categorized without a natural order or rank, simply identifying different types based on names or labels.

Ethnicity

Ethnicity refers to the social group a person belongs to, and identifies with, often based on cultural, religious, or national characteristics.

Interval Data

A type of data where the order of the data points is significant and the distance between them is equal and meaningful; however, it does not have a true zero point.