These Excel templates are designed for a statistical analysis in Excel. Main screen:
If we want to calculate a correlation matrix and partial correlation matrix, click the template 'corr1'.
We enter our data in A, B, C ... and then pres the 'Correlation' button. And VBA code shows the following sheet:
If we want to calculate a partial correlation coefficient between two variables when the third one is held then we open 'corr partial' sheet:
If we want to calculate the regression coefficients, then we open the 'linest' sheet:
Linear, polynomial and exponential regression analysis is also enabled.
This workbook also contains several sheets for forecasting using a regression analysis.
The download also contains the Securities Excel templates for a financial analysis.
Windows XP / 2000 / 2003 or later. Or NT4 Server, Windows 9x, Me, NT or Mac.
Requires Excel 2000 or later.
30 day money back guarantee!
Buy Online Correlation & Regression Excel Templates $67.00
The download contains correlation and regression Excel templates.
This download contains also our bonus!
sec.xls - contains 26 securities Excel templates: templates for coupons (6 templates), teplates for price calculation (6 templates), templates for Yield calculation (9 templates), discount rate, interest rate, bond-equivalent yield, macualey duration, modified duratinn for a security. Full instructions.
Please note that we included this bonus just temporarily. You can also order the following more power product.
This product contains 56 financial Excel Templates
1. npv.xls - NPV & IRR for
periodic cash flows templates
2. npvirrdate.xls - NPV & IRR for any cash flows templates
3. mirr.xls - MIRR template
4. sec.xls - 26 securities templates
5. amort.xls - 5 amortization templates
6. datetime.xls - 4 date templates
7. finexcelsoft.xls - additional 16 financial templates
Excel templates for almost all financial calculations: NPV, IRR, MIRR, amortization templates, securities templates, effective annual interest rate, annual nominal interest rate, price per $100 face value of security that pays periodic interest, yield on a security that pays periodic interest, number of periods for an investment based on an interest rate and a constant payment schedule, future value of an investment based on an interest rate and a constant payment schedule, present value of an investment based on an interest rate and a constant payment schedule, payment amount for a loan based on an interest rate and a constant payment schedule, and more. finExcelSoft.xls workbook contains also the spreadsheet for easy function navigation in 7 workbooks. Use of some complex financial functions are simplified by VBA procedures. Our workbooks contain also full instructions.
This download also contains our bonus - correlation and regression Excel templates descrived above.
30 day money back guarantee!
Buy Online 56 Excel Financial Templates and correlation®ression Excel Templates for just $94.95
Our Bonus: if you order this product you may order Excel add-in for Extended Accounting with hierarchies for free. For more information about this Excel add-in please visit: Extended Accounting page. This offer is just temporary. To order this accounting Excel add-in, please email to firstname.lastname@example.org. Please include: your first and last name and your order number.
More FinExcelSoft Excel Templates
iovsoft.netfirms.com Excel Templates
IovSoft Financial Excel Templates
Copyright © FinExcelSoft 2007 All Rights Reserved