<HTML> 
<HEAD> 
<TITLE>Two variable sensitivity analysis with data tables in Excel</TITLE> 
<meta name="description" content="The video demonstrates how a two variable sensitivity analysis with data tables in Excel is performed. Our example demonstrates how the equal monthly payments change with change in interest rates per year and the loan amount. The loan amount is input in a row and the interest rate is entered into a column of the worksheet." /> 
<meta name="keywords" content="two variable,sensitivity analysis,data tables, Excel" /> 
</HEAD> 
<BODY bgcolor="#339999"> 
<table width="800" align="center" bgcolor="#ffffff"> 
<tr><td colspan="2" align="center"><h1>Two variable sensitivity analysis with data tables in Excel</h1></td></tr> 
<tr><td colspan="2">The video in Hindi demonstrates how a two variable sensitivity analysis with data tables in Excel is performed. Our example demonstrates how the equal monthly payments change with change in interest rates per year and the loan amount.<br>A person wants to take a home loan from a bank. Different banks are offering loans at different terms and conditions and the main change appears to be the rate of interest per annum. Also the person can only afford to pay a certain amount every month for the period of the loan. A two way analysis of the data helps to make a quick decision using the data tables feature.<br>मानो आप बैंक से लोन लेना चाहते हैं और आपने सोच लिया है की मैं बीस हज़ार से पच्चीस हज़ार रुपये हर महीने किश्तों में भर सकता हूँ. अब आप यह जानना चाहते हैं की आप ज्यादा से ज्यादा कितना लोन ले सकते हैं यदि इंटरेस्ट रेट इतना हो तो. चलो देखते हैं इस विडियो को और जानकारी लेते हैं की यह एक्स्सल में डेटा टेबल्स  का प्रयोग करके कैसे किया जाता है. आपका बैंक भी तो ऐसे ही करता होगा!</td></tr> 
<tr><td colspan="2"> 
<center><script type="text/javascript"><!--
google_ad_client = "pub-1379996146055698";
/* 728x90, created 3/10/10 */
google_ad_slot = "4763244959";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script> 
<script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> 
</script></center> 
<center> 
 <EMBED src="http://www.familycomputerclub.com/excel/training/two-variable-sensitivity-analysis-with-data-tables-in-excel.wmv" quality=high bgcolor=#217  WIDTH="720" HEIGHT="480" ALIGN="center"> 
</EMBED> 
<br> <a href="http://www.familycomputerclub.com/excel/training/Microsoft-Excel-training-videos-in-Hindi.html">Two variable sensitivity analysis with data tables in Excel in Hindi</a><br><br> 
<center><script type="text/javascript"><!--
google_ad_client = "pub-1379996146055698";
/* 728x15, created 8/14/08 */
google_ad_slot = "1153145213";
google_ad_width = 728;
google_ad_height = 15;
//-->
</script> 
<script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> 
</script></center> 
</td></tr></table> 
</BODY> 
</HTML>