What Is A Two-variable Data Table?

1.	What Is A Two-variable Data Table?
Answer» Two variables Data Table in EXCEL is most suited in situations when you want to see how the final RESULT changes when you change two of the input variables. For example, if you want to know how much on monthly installment changes if you increase/decrease the number of months and the interest rate. You can set up a two-variable data table for it that will show you the final monthly installment based on different combinations of interest rate and number of months. This can be useful when you want to keep the monthly payment LESS than $500 and know what all OPTIONS you have.

Answer»

Two variables Data Table in EXCEL is most suited in situations when you want to see how the final RESULT changes when you change two of the input variables.
For example, if you want to know how much on monthly installment changes if you increase/decrease the number of months and the interest rate.
You can set up a two-variable data table for it that will show you the final monthly installment based on different combinations of interest rate and number of months. This can be useful when you want to keep the monthly payment LESS than $500 and know what all OPTIONS you have.

Discussion