Estimating the relationships between variables in a spreadsheet model can be done using:
A) data tables
B) Goal Seek
C) the VLOOKUP function
D) curve fitting

Question

Estimating the relationships between variables in a spreadsheet model can be done using:
A) data tables 
B) Goal Seek 
C) the VLOOKUP function 
D) curve fitting

Quizplus · Accepted Answer

Curve fitting is the best choice for estimating the relationships between variables in a spreadsheet model as it allows for a mathematical model to be created based on the available data, which can be used to make predictions or analyze the impact of changes in the input variables. Data tables, Goal Seek, and VLOOKUP can also be useful tools in spreadsheet modeling, but they are more appropriate for analyzing specific scenarios or finding specific results, rather than estimating relationships between variables.

Estimating the Relationships Between Variables in a Spreadsheet Model Can