We need to take the result of interest received. So, we need to perform two calculations here, one for different interest rates and one for different years.įirst, we will apply for different interest rates. Suppose we deposited Rupees 10000 for 5 years with an interest rate of 6 percent and want to know how much we will receive if we extend the number of years or deposit in other banks for different interest rates. Now we will apply this to simple interest calculation. One Variable Data Table in Excel Example #2 In case if inputs in a column, just select “Column input cell” from the pop-up no other changes in the process. Now we have outputs for different inputs at a time. Then automatically, the area of the rectangle calculates for all the inputs and displays the results under each input. Select “row input” and select the cell from where the length input is taking for finding the area of the rectangle. The column input cell is used when the multiple inputs are available in columns that are as shown in the below picture.Īs we are using the different inputs in a row, hence we will use row input. Let’s understand the working of One Variable Data Table in Excel by some examples. One Variable Data Table in Excel is very simple and easy to create. How to Perform One Variable Data Table in Excel? I hope you understand what is “Data table” and what is meant by “One variable data table”. Hence, we can call this “one-variable data table. If we observe one variable is varying, that is, in this process, that is the length. Here we are getting an area of the rectangle at the same time for the multiple inputs of length. This is what exactly the “Data table” performs. We want all the results to need to display at the same time, as shown in the below picture. Now I want to check the area for different lengths that are from 5 to 50 with equal intervals of 5 that mean length should be 5, 10, 15 …50. This is the case where the Data table helps where it will display all results for different inputs. So when we give 15, we cannot see the results for 5 and 10. One more time, I will change the length value and will check the results. Now I want to check the area for the length of 5 then, the area will be 50 again if I want to calculate for length 15. Now, what is the part of the data table here? Suppose we want to know the area of the rectangle for different lengths or different breadths what will we do? We will change the value of length or breadth and will check the results of “Area of a rectangle”. Here length is 15, and Breadth is 10, so multiple of 15 x 10 = 150.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |