What what-if analysis tool would you use to compare the impact of different interest rates on a car payment?
A)Solver
B)Goal Seek
C)One-variable data table
D)Two-variable data table

Question

Quizplus · Accepted Answer

A one-variable data table is used to compare the impact of different values of a single input variable, in this case, interest rates, on a specific output, which is the car payment. By listing the different interest rates in the first column and the corresponding car payments in the second column, the one-variable data table can quickly show the impact of varying interest rates on the overall car payment. Solver, Goal Seek, and Two-variable data table are not well suited for this specific scenario.

What What-If Analysis Tool Would You Use to Compare the Impact