Advertisements
Advertisements
प्रश्न
Define a two-variable table. Explain these with examples.
व्याख्या
स्पष्ट करा
Advertisements
उत्तर
A Two-Variable Data Table is a structured What-If Analysis tool in electronic spreadsheets that calculates and displays the results of a single formula when alternative values for two distinct input variables are substituted simultaneously.
Example:
Suppose a business wants to calculate the Monthly Loan EMI for a loan of Rs. 5,00,000. They want to check how the EMI changes when both the Interest Rate AND the Loan Tenure (Time) change at the same time.
- Variable 1 (Interest Rate): 8%, 9%, 11%
- Variable 2 (Tenure): 12 Months, 24 Months, 36 Months
| Interest Rate (Variable 1) | 12 Months (Variable 2) | 24 Months (Variable 2) | 36 Months (Variable 2) |
| 8% | Rs. 43,494.21 | Rs. 22,613.65 | Rs. 15,668.20 |
| 9% | Rs. 43,725.93 | Rs. 22,842.19 | Rs. 15,899.86 |
| 11% | Rs. 44,191.24 | Rs. 23,301.92 | Rs. 16,368.60 |
shaalaa.com
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 2: Spreadsheet - EXERCISE [पृष्ठ ८४]
