You could easily follow the same steps as you did during the part 01. Steps to setup and use two variable Data Tables Step 01: Prepare the input section and calculation section We can use this feature to review the compare the loan payment amount due for a period, total amount of payments or the total amount of the interest portion of the loan payments. But you may find it is very useful in some situations.Īs an example we can use a two variable data table to evaluate & and analysis different loan schemes having different interest rates for different loan duration. We can use Microsoft Excel two variable Data Tables to evaluate the results of a calculation formula for different combination of values for two variables.Įven though we can evaluate multiple calculations simultaneously using the one variable data table, we can only evaluate a single calculation formula here. It is more useful if we can evaluate formulas against the change of values of two variables instead of one variable. In part 01 of this tutorial you learned the basics of Microsoft excel data tables and how to use one variable data table. If you find any issues doing regression analysis in those versions, please leave a comment below. Other compatible versions are Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011. This tutorial created using Microsoft Excel 2016.
