Step 2: In the cell (F2), which is one row above and diagonal to the column which you prepared in the previous step, type this = C6. We have entered different values for interest rates in the column which is highlighted in the figure. Step 1: Prepare a column which consists of different values for the interest rates. The steps to create the one-variable data table are as follows:
In order to do this, there is a need for creating a one-variable data table.
In the case of observing the monthly mortgage amount for different interest rates, where the interest rate is considered as a variable. It uses the PMT formula to calculate the monthly mortgage amount, which can be written as =PMT (C4/12, C5,-C3). The table above shows the data where the mortgage amount is calculated based on the interest rate, mortgage period and loan amount. Consider the below figure, which shows the mortgage amount calculated based on the interest rate using the PMT function. The one-variable data table is useful in scenarios where a person can observe how different interest rates change the amount of their mortgage amount to be paid. Use case of One-Variable Data Table in Excel: One-variable data tables are efficient in the case of analyzing the changes in the result of your formula when you change the values for a single input variable.
#Qpcr data analysis excel template download#
You can download this Data Table Excel Template here – Data Table Excel Template Data Table in Excel Example #1 – One-Variable Data Table
0 kommentar(er)
