Saved Bookmarks
| 1. |
What Is A One-variable Data Table? |
|
Answer» One VARIABLE DATA Table in Excel is most suited in SITUATIONS when you want to see how the final result changes when you change one of the input variables. For example: if you want to know how much on monthly installment change if you increase/decrease the number of months, you can SET up a one-variable data table for it. This can be USEFUL when you want to keep the monthly payment less than $500 and know what all options you have (6 months, 9 months, 12 months, etc.) One variable Data Table in Excel is most suited in situations when you want to see how the final result changes when you change one of the input variables. For example: if you want to know how much on monthly installment change if you increase/decrease the number of months, you can set up a one-variable data table for it. This can be useful when you want to keep the monthly payment less than $500 and know what all options you have (6 months, 9 months, 12 months, etc.) |
|